1Z0-117 · Question #41
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?
The correct answer is A. The literal value `NORTH' is replaced by a system-generated bind variable. B. Bind peeking will not happen and subsequent executions of the statement with different literal values. CURSOR_SHARING determines what kind of SQL statements can share the same cursors. Forces statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect the meaning of the statement. Causes statements that may differ in…
Question
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?
Options
- AThe literal value `NORTH' is replaced by a system-generated bind variable.
- BBind peeking will not happen and subsequent executions of the statement with different literal values
- CAdaptive cursor sharing happens only if there is a histogram in the REIGN column of the CUSTOMERS table.
- DAdaptive cursor sharing happens irrespective of whether there is a histogram in the REIGN column of
How the community answered
(41 responses)- A73% (30)
- C17% (7)
- D10% (4)
Explanation
CURSOR_SHARING determines what kind of SQL statements can share the same cursors. Forces statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect the meaning of the statement. Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is Only allows statements with identical text to share the same cursor.
Topics
Community Discussion
No community discussion yet for this question.