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
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
Following are opensource monitoring tools
Nagios
HP OM
Sitescope
zabbix
DBSPI is used for
Network Monitoring
Database Monitoring
Storage Monitoring
Server Monitoring