|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#70. The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below: SELECT * FROM employees WHERE department _id=50; SELECT * FROM employees WHERE department_id=70;
There is an index on the DEPARTMENT ID column of the 1,000,000 row EMPLOYEES table.
Ninety percent of the employees are part of DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two statements? (Choose two.)
Show comments for this question (1)
Add comments
Link to this question
|
|
|
|
 gen. 0.061
|
Server date 00:47 08-01-2009
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump