The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

Exam 1Z0-146 — Oracle Advanced PL/SQL Developer Certified Professional

My tunes are helping me studyPL/SQL, or Procedural Language/Structured Query Language, is a custom procedural extension of SQL created by Oracle Corporation for use with the Oracle relational database. Oracle Database 11g has been in the field since 2007. Exam 1Z0-146 covers knowledge of using PL/SQL to develop database-centric internet applications.

 

Oracle certification expert Matthew Morris has created a series of practice tests at his site, Oracle Certification Prep. These free practice questions are a sampling of what you'll find there. After you try these questions, visit Oracle Certification Prep for (paid) access to a full 1Z0-146: Oracle Database 11g: Advanced PL/SQL practice test.

 

Ready to rumble? Simply scroll down the page to begin your quiz. Or check out our other free Oracle quizzes.

 

Note: Your browser must permit multiple dialog boxes per page in order to complete this quiz.

 

Question 1:

Which of the following statements about cursors is correct?

A. If an explicit cursor is closed and immediately reopened, the associated query is not reparsed.
B. For explicit cursors that use parameters, you should use different names for formal and actual cursor parameters.
C. A named explicit cursor can be passed as a subprogram parameter.
D. The SQL%NOTFOUND attribute can be used as an exception handler for a SELECT INTO statement.
E. The attribute values of an implicit cursor are available only until the cursor closes.