Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

valid statement about the above scenario?

a.        Tune the number of latches by setting it to db_cache_size(50*db_block_size)
b.        Tune the number of latches by setting to large_pool_size/1000
c.        Tune the number of latches by setting it to Number of CPUs *1 *2
d.        Oracle9i would automatically calculate the number of latches required, based on the environment defined by the initialization parameters for the database and the operating system level parameters

Consider the following SQL statement:

SELECT         manufacturer_id, COUNT(*), order_date
FROM            ITEM
WHERE         price > 14.00
GROUP BY    order_date, manufacturer_id
HAVING        COUNT(*) > 10

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 9, 2015 by rajesh
0 votes

Related Hot Questions

Government Jobs Opening