Tag: performance

Questions Related to performance

The following select statement has accessed 54 blocks to retrieve 1000 records. What is the Blocks/Row ratio

  1. 100

  2. 18

  3. 200

  4. 50


Correct Option: B
  1. Ratio of number of distinct values in column/columns to the total number of rows in the table

  2. Ratio of total number of rows in the table to the number of distinct values in column/columns

  3. Ratio of distinct values in the table to the total number of rows in the table

  4. Total number of rows


Correct Option: A
  1. for (var i = 0; i < arr.length; i++) { // some code here }

  2. for (var i = 0, len = arr.length; i < len; i++) { // some code here }

  3. for (var i = arr.length; i--; ) { // some code here }

  4. for ( i = 0; i < arr.length; i++) { // some code here }


Correct Option: C

Its faster to do heavy processing in Javascript than java.

  1. True

  2. False


Correct Option: B
  1. if (x*x < 1000 && y) alert("true!");

  2. if (x*x > 1000 && y) alert("true!");

  3. if (y || x*x > 1000) alert("true!");

  4. if (x*x > 1000 || y) alert("true!");


Correct Option: A,D
  1. Agent based monitoring tools

  2. Auto-discovers the managed environment and auto-deploys management policies

  3. Monitors and detects events or potential performance problems arising from managed nodes and services.

  4. Collects network, managed node, and performance metrics to help you optimize performance and prevent problems.

  5. Options 1 and 3


Correct Option: A,B,C,D
  1. Nagios

  2. HP OM

  3. Sitescope

  4. zabbix


Correct Option: A,D
  1. Network Monitoring

  2. Database Monitoring

  3. Storage Monitoring

  4. Server Monitoring


Correct Option: B