Tag: performance

Questions Related to performance

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

  1. Performance Counters

  2. Data Performance Counters

  3. Web Performance Counters

  4. Data Readers

Show answer
Correct Option: A

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

  1. CPU

  2. Availabilty

  3. Response Time

  4. Throughput

Show answer
Correct Option: C

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

technology performance

  1. Instance Tuning

  2. Object Tuning

  3. SQL Tuning

  4. Space Management

Show answer
Correct Option: A

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.

technology performance

  1. Optimizer Index Caching

  2. Optimizer Index Cost Adjustments

  3. Optimizer Mode

  4. Parallel Automatic Tuning

Show answer
Correct Option: B

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.

technology performance

  1. RAID 1

  2. RAID 0+1

  3. RAID 3

  4. RAID 5

Show answer
Correct Option: C

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.
technology performance

  1. Automatic Maintenance Tasks(AMT)

  2. Automatic Workload Repository(AWR)

  3. Automatic Database Diagnostic Monitor(ADDM)

  4. Automatic Storage Management(ASM)

Show answer
Correct Option: B

What is the full form of ISM?
technology performance

  1. Internet Service Monitor

  2. Internet Service Monitors

  3. Internet Service Monitoring

  4. Internet Services Monitoring

Show answer
Correct Option: B

Where does ISM store logs?
technology performance

  1. /opt/Netcool/var/logs

  2. /opt/Netcool/ism/datalogs

  3. /opt/Netcool/log/ism

  4. /opt/Netcool/ism/log

Show answer
Correct Option: C

ISM startup script resides in...

technology performance

  1. /opt/Netcool/bin/ism

  2. /opt/Netcool/bin

  3. /opt/Netcool/ism/scripts

  4. /opt/Netcool/ism/bin

Show answer
Correct Option: D

ISM can monitor RADIUS servers.

technology performance

  1. True

  2. False

Show answer
Correct Option: A