READ Free Dumps For Oracle- 1z0-117

Question ID 2574	In your database, the CURSOR_SHARING parameter is set to FORCE. A user issues the following SQL statement: Select * from SH.CUSTOMERS where REIGN=’NORTH’ Which two statements are correct?
Option A	A.    The literal value ‘NORTH’ is replaced by a system-generated bind variable.
Option B	B.    Bind peeking will not happen and subsequent executions of the statement with different literal values will use the same plan.
Option C	C.    Adaptive cursor sharing happens only if there is a histogram in the REIGN column of the CUSTOMERS table.
Option D	D.    Adaptive cursor sharing happens irrespective of whether there is a histogram in the REIGN column of the CUSTOMERS table.
Correct Answer	A,D

Explanation

Question ID 2575	Examine Exhibit 1 to view the query and its execution plan.   Examine Exhibit 2 to view the structure and indexes for the EMPLOYEES and DEPARTMENTS tables.   Examine Exhibit 3 to view the initialization parameters for the instance.     Why is sort-merge join chosen as the access method?
Option A	A.    Because the OPTIMIZER_MODE parameter is set to ALL_ROWS.
Option B	B.    Because of an inequality condition.
Option C	C.    Because the data is not sorted in the LAST_NAME column of the EMPLOYEES table
Option D	D.    Because of the LIKE operator used in the query to filter out records
Correct Answer	A

Explanation

Previous-Page 1 2. . . 32 33 34 35 36 37 38. . . 60 61 Next-Page

Send email to admin@getfreedumps for new dumps request!!!