Dec 2007: PL/SQL Knowledge Quiz

Home

Products

Community

Experts

Knowledge

Downloads

Hello, you are not logged in. Login or sign up

Experts >> Steven Feuerstein's PL/SQL Obsession >> Puzzles and Quizzes >> Dec 2007: PL/SQL Knowledge Quiz


		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