Oracle
1Z0-064 · Question #9
Examine the structure of the EMPLOYEES table. EMPLOYEE_ID is the primary key. No other indexes exist on this table. View the Exhibit to examine the commands and their output. Which two actions…
The correct answer is C. Execute the query with the same DEPARTMENT_ID value multiple times. D. Create an index on the DEPARTMENT_ID column. See the full explanation below for the reasoning.
Question
Examine the structure of the EMPLOYEES table. EMPLOYEE_ID is the primary key. No other indexes exist on this table. View the Exhibit to examine the commands and their output. Which two actions should you perform to make the cursor bind aware? (Choose two.)
Exhibits
Options
- ACreate a histogram on the DEPARTMENT_ID column.
- BChange the default CURSOR_SHARING value to FORCE.
- CExecute the query with the same DEPARTMENT_ID value multiple times.
- DCreate an index on the DEPARTMENT_ID column.
- EGather statistics for the index.
- FRegather statistics on the table.
How the community answered
(21 responses)- A10% (2)
- B10% (2)
- C76% (16)
- E5% (1)
Community Discussion
No community discussion yet for this question.