Performance | Practice Questions

Multiple choice performance

Which one of the following is used to obtain performance information about a Web Application?

Performance Counters
Data Performance Counters
Web Performance Counters
Data Readers

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

This is the most important measure in dealing with performance issues.

CPU
Availabilty
Response Time
Throughput

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

This phase of Oracle tuning is directed at looking for resource shortages in the db_block_buffers, shared_pool_size and sort_area_size.

Instance Tuning
Object Tuning
SQL Tuning
Space Management

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

This parameter lets you tune optimizer behavior for access path selection to be more or less index friendly, that is, to make the optimizer more or less prone to selecting an index access path over a full table scan. The default makes full table scan and index use equal.

Optimizer Index Caching
Optimizer Index Cost Adjustments
Optimizer Mode
Parallel Automatic Tuning

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

This RAID configuration stripes data across multiple volumes. One volume is devoted to "parity bits." The bits are used to reconstruct data should you lose a data volume.

RAID 1
RAID 0+1
RAID 3
RAID 5

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

This tool in Oracle10g defaults to a collection interval every 30 minutes and collects data that is the foundation for all of the other self-tuning features. It is very much like STATSPACK, especially the level-5 STATSPACK collection mechanism where top SQL is collected every hour, based on your rolling thresholds for high-use SQL.

Automatic Maintenance Tasks(AMT)
Automatic Workload Repository(AWR)
Automatic Database Diagnostic Monitor(ADDM)
Automatic Storage Management(ASM)

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

What is the full form of ISM?

Internet Service Monitor
Internet Service Monitors
Internet Service Monitoring
Internet Services Monitoring

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

Where does ISM store logs?

/opt/Netcool/var/logs
/opt/Netcool/ism/datalogs
/opt/Netcool/log/ism
/opt/Netcool/ism/log

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

ISM startup script resides in...

/opt/Netcool/bin/ism
/opt/Netcool/bin
/opt/Netcool/ism/scripts
/opt/Netcool/ism/bin

Reveal answer Fill a bubble to check yourself

Multiple choice technology performance

ISM can monitor RADIUS servers.

True
False

Reveal answer Fill a bubble to check yourself

Tag: performance

Questions Related to performance