Which two actions should you perform to make the cursor…

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.)

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.)

A.
Create a histogram on the DEPARTMENT_ID column.

B.
Change the default CURSOR_SHARING value to FORCE.

C.
Execute the query with the same DEPARTMENT_ID value multiple times.

D.
Create an index on the DEPARTMENT_ID column.

E.
Gather statistics for the index.

F.
Regather statistics on the table.



Leave a Reply 0

Your email address will not be published. Required fields are marked *