單項(xiàng)選擇題

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）

A.No literal value is substituted for a shared cursor.
B.Different execution plans are generated for substituted literal values.
C.The substitution of a literal value will produce different execution plans.
D.The substitution of any literal value will produce exactly the same execution plan.

你可能感興趣的試題

單項(xiàng)選擇題

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）

A.The filename format.
B.Information stored inside a data dictionary table.
C.Information stored in the ALERT.LOG file for the corresponding instance.
D.Information stored inside the corresponding initialization parameter file for the instance.

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）

你可能感興趣的試題

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）