Performance Monitoring and Optimization

Covers application monitoring tools, database performance optimization, code performance techniques, and load testing with JMeter

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

What is the purpose of a sampler

  1. To send requests to a server and wait for a response
  2. Collect data from Server
  3. Tune Server
  4. Generate Report from server response
Question 2 Multiple Choice (Single Answer)

Which of the following is false about Listeners

  1. Provide access to the information
  2. Plots the response times on a graph
  3. Shows details of sampler requests and responses
  4. Allows to insert Logic to the request
Question 3 Multiple Choice (Single Answer)

Which element of JMeter is used to process response data and extract values out of server response

  1. Pre-processors
  2. Post-processors
  3. Listeners
  4. Assertions
Question 4 Multiple Choice (Single Answer)

Identify index that needs to be created for the query

  1. CSP_ENTITY_ID
  2. CSP_ENTITY_ID,CSP_EVNT_ID
  3. CSP_ENTITY_ID, CSP_EVNT_ID,CSP_DPT_ID
  4. CSP_ENTITY_ID, CSP_EVNT_ID,CSP_DPT_ID,CSP_DPT_EVNT_IND
Question 5 Multiple Choice (Single Answer)

Calculate the selectivity of the Below Index

  1. .89
  2. .25
  3. .5
  4. .005
Question 6 Multiple Choice (Single Answer)

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
Question 7 Multiple Choice (Single Answer)

What is selectivity of an Index

  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
Question 8 Multiple Choice (Single Answer)

Which for loop will run fastest?

  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 }
Question 9 True/False

Its faster to do heavy processing in Javascript than java.

  1. True
  2. False
Question 10 True/False

Caching variable values in a another local variables is a not useful

  1. True
  2. False
Question 11 Multiple Choice (Multiple Answers)

With the following code, var x = 10; var y = true; which of the options are slower two ?

  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!");
Question 12 Multiple Choice (Multiple Answers)

HP Operation Manager

  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
Question 13 True/False

HP SiteScope is an agentless monitoring application

  1. True
  2. False
Question 14 Multiple Choice (Multiple Answers)

Following are opensource monitoring tools

  1. Nagios
  2. HP OM
  3. Sitescope
  4. zabbix
Question 15 Multiple Choice (Single Answer)

DBSPI is used for

  1. Network Monitoring
  2. Database Monitoring
  3. Storage Monitoring
  4. Server Monitoring
Question 16 Multiple Choice (Single Answer)

Threashold value in sitescope?

  1. The error, warning, and good status
  2. Job Numeric Values
  3. Maximum level value
  4. Minimum level value
Question 17 True/False

383 is the default port number for HPOM agent

  1. True
  2. False
Question 18 Multiple Choice (Single Answer)

Which provides console and server functionality to centrally monitor performance and events using agents installed on nodes being managed

  1. Sitescope
  2. HP Operations Manager for Windows
  3. HP Operations Manager for Unix
  4. BAC
Question 19 Multiple Choice (Multiple Answers)

Storage Essential and Report optimizer

  1. Storage discovery and Generate report
  2. Storage utilization and capacity planning
  3. Netowrk monitoring and report generation
  4. Server monitoring and report generation
Question 20 Multiple Choice (Single Answer)

Which command is used to take java core dump?

  1. kill -3
  2. kill -6
  3. kill -9
  4. kill -t