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

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 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.

‍

Question 2:

1. Explicit cursors
2. Cursor variables
3. Both explicit cursors and cursor variables

A. Can only be used for a single query
B. Is used with the OPEN, FETCH, and CLOSE commands.
C. Can accept parameters
D. Can be passed as a subprogram parameter
E. Can be used in a cursor FOR LOOP.
F. Can make use of SQL attributes (i.e. %FOUND, %NOT_FOUND).

Select the answer that properly matches the above characteristics to explicit cursors, cursor variables, or both:

A. A-3, B-2, C-3, D-1, E-1, F-3
B. A-2, B-3, C-1, D-1, E-1, F-3
C. A-1, B-1, C-2, D-2, E-2, F-1
D. A-1, B-1, C-2, D-2, E-2, F-2
E. A-1, B-3, C-1, D-2, E-1, F-3

‍

Question 3:

Which of the following statements about nested tables is correct?

A. Elements stored in a PL/SQL nested table variable are given consecutive index values starting at 0.
B. A nested table can be used as a column type in database tables.
C. A nested table is always dense.
D. Rows in a nested table are stored in a specific order that remain stable as values are stored and retrieved from it.
E. A nested table has a declared number of elements.

‍

Question 4:

Which of the following statements about Oracle Virtual Private Database is true?

A. It allows for the creation of security policies to control database access at the table level.
B. When a VPD security policy is created, the applicable trigger object required to enforce the policy is created automatically.
C. Users attempting to access protected data will receive a system-generated error message from VPD.
D. VPD dynamically modifies SQL statements when a protected table or view is accessed by an operation.
E. Oracle Virtual Private Database policies can be applied to SELECT, INSERT, UPDATE, INDEX, DELETE, and TRUNCATE statements.

‍

Question 5:

Which of the following statements about LOB encryption is true?

A. LOB encryption is applicable to BasicFiles LOBs and SecureFiles LOBs.
B. The DECRYPT option can be used in an ALTER TABLE statement to convert encrypted columns to clear text form.
C. A partitioned LOB column can be encrypted in some partitions or all available partitions.
D. LOB encryption is salted by default. The NO SALT clause disables the use of salt in the encryption key.
E. The ENCRYPT option can be used in an ALTER TABLE statement to re-key encrypted columns to a new key or algorithm.

‍