Dec 2007: PL/SQL Knowledge Quiz

Toad World
ORACLE
Steven Feuerstein's PL/SQL Obsession
Puzzles and Quizzes
Dec 2007: PL/SQL Knowledge Quiz

WELCOME, GUEST

Toad World Puzzler - December 2007

PL/SQL Knowledge Quiz

Answer the following multiple choice question to see how well you understand the nuances of PL/SQL.

Which of the following statements is not true?

A. On Oracle 10g, cursor for loops are automatically optimized to perform at speeds similar to BULK COLLECT queries.
B. On Oracle 11g, the function result cache feature improves query performance by sharing queried data across multiple sessions within the same instance.
C. Oracle recommends that as of Oracle 10g, you should convert all of your static SQL to dynamic SQL in order to improve performance.
D. The OPEN FOR statement can be used with both dynamic and static queries.

Submit