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

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.

‍