Oracle
1Z0-064 · Question #9
1Z0-064 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.