Exam 1Z0-144 - Oracle Database 11g: Program with PL/SQL

Young woman smiling and studying

PL/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 is an exam for junior-level PL/SQL developers and covers the syntax and the programming elements most commonly used in PL/SQL.

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-144 — Oracle Database 11g: Program with 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 is not one of the benefits of using PL/SQL?

A. Ability to declare variables and constants.
B. Support for Object-Oriented Programming.
C. Capability to develop web applications.
D. Mostly OS-independent.
E. Tight Integration with SQL.

Question 2:

Which of the following statements about anonymous PL/SQL blocks is true?

A. They are compiled only the first time the block is executed in a session.
B. They can be imbedded in an OCI program.
C. They can only make use of bind variables.
D. They can be created as either a function or a procedure.
E. They can be called from other PL/SQL blocks.

Question 3:

You need a small lookup table that will be generated in memory every time a PL/SQL procedure is invoked or a package that declares it is initialized. Which of the following is the proper composite data type to use?

Choose one answer:

A. Nested Table
B. Bulk Collection
C. Associative array
D. FORALL Array
E. VARRAY

Question 4:

Which of the following is a valid implicit cursor attribute?

A. SQL%OPEN
B. SQL%NODATAFOUND
C. SQL%ROWTYPE
D. SQL%GROUP_COUNT
E. SQL%ROWCOUNT

Question 5:

Which of the following is a valid reason for deciding to create a subprogram as a function rather than as a procedure?

A. It must be callable from SQL statements.
B. It must be stored as a named object in the data dictionary.
C. It must be callable from both named and anonymous PL/SQL blocks.
D. The purpose is to accept one parameter and return multiple values.
E. The subprogram will require the use of both IN and OUT parameters.

MORE HISTORIC HACKS
Would you like more insight into the history of hacking? Check out Calvin's other articles about historical hackery:
"Work on Your Wellness" Articles
Want to improve your health and live a better life? Check out Reena's other articles in this series:
About the Author

GoCertify's mission is to help both students and working professionals get IT certifications. GoCertify was founded in 1998 by Anne Martinez.