Performance Monitoring and Optimization
Covers application monitoring tools, database performance optimization, code performance techniques, and load testing with JMeter
Questions
What is the purpose of a sampler
- To send requests to a server and wait for a response
- Collect data from Server
- Tune Server
- Generate Report from server response
Which of the following is false about Listeners
- Provide access to the information
- Plots the response times on a graph
- Shows details of sampler requests and responses
- Allows to insert Logic to the request
Which element of JMeter is used to process response data and extract values out of server response
- Pre-processors
- Post-processors
- Listeners
- Assertions
Identify index that needs to be created for the query
- CSP_ENTITY_ID
- CSP_ENTITY_ID,CSP_EVNT_ID
- CSP_ENTITY_ID, CSP_EVNT_ID,CSP_DPT_ID
- CSP_ENTITY_ID, CSP_EVNT_ID,CSP_DPT_ID,CSP_DPT_EVNT_IND
Calculate the selectivity of the Below Index
- .89
- .25
- .5
- .005
The following select statement has accessed 54 blocks to retrieve 1000 records. What is the Blocks/Row ratio
- 100
- 18
- 200
- 50
What is selectivity of an Index
- Ratio of number of distinct values in column/columns to the total number of rows in the table
- Ratio of total number of rows in the table to the number of distinct values in column/columns
- Ratio of distinct values in the table to the total number of rows in the table
- Total number of rows
Which for loop will run fastest?
- for (var i = 0; i < arr.length; i++) { // some code here }
- for (var i = 0, len = arr.length; i < len; i++) { // some code here }
- for (var i = arr.length; i--; ) { // some code here }
- for ( i = 0; i < arr.length; i++) { // some code here }
Its faster to do heavy processing in Javascript than java.
- True
- False
Caching variable values in a another local variables is a not useful
- True
- False
With the following code, var x = 10; var y = true; which of the options are slower two ?
- if (x*x < 1000 && y) alert("true!");
- if (x*x > 1000 && y) alert("true!");
- if (y || x*x > 1000) alert("true!");
- if (x*x > 1000 || y) alert("true!");
HP Operation Manager
- Agent based monitoring tools
- Auto-discovers the managed environment and auto-deploys management policies
- Monitors and detects events or potential performance problems arising from managed nodes and services.
- Collects network, managed node, and performance metrics to help you optimize performance and prevent problems.
- Options 1 and 3
HP SiteScope is an agentless monitoring application
- True
- False
Following are opensource monitoring tools
- Nagios
- HP OM
- Sitescope
- zabbix
DBSPI is used for
- Network Monitoring
- Database Monitoring
- Storage Monitoring
- Server Monitoring
Threashold value in sitescope?
- The error, warning, and good status
- Job Numeric Values
- Maximum level value
- Minimum level value
383 is the default port number for HPOM agent
- True
- False
Which provides console and server functionality to centrally monitor performance and events using agents installed on nodes being managed
- Sitescope
- HP Operations Manager for Windows
- HP Operations Manager for Unix
- BAC
Storage Essential and Report optimizer
- Storage discovery and Generate report
- Storage utilization and capacity planning
- Netowrk monitoring and report generation
- Server monitoring and report generation
Which command is used to take java core dump?
- kill -3
- kill -6
- kill -9
- kill -t