ExamSoon 1Z0-146 Exams
Oracle Oracle 11g: Advanced PL/SQL
O rder : 1Z0-146 Exam
Practice Exam: 1Z0-146
Exam Number/Code: 1Z0-146
Exam Name: Oracle 11g: Advanced PL/SQL
Questions and Answers: 136 Q&As
Free 1Z0-146 Braindumps
Exam : Oracle 1Z0-146
Title : Oracle 11g: Advanced PL/SQL
1. Which two statements are true about SecureFile LOB options? (Choose two.)
A. The COMPRESSION HIGH option can be enabled only for CLOBs.
B. The COMPRESSION HIGH option can be enabled for all internal LOBs.
C. The DECRYPT option can be used to remove encryption only if the LOB column is empty.
D. The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data.
2. Examine the structure of the DEPARTMENTS table.
Name Null? Type
----------------------------- ------------ ----------
DEPARTMENT_ID NOT NULL NUMBER(4)
DEPARTMENT_NAME NOT NULL VARCHAR2(30)
View the Exhibit and examine the code that you plan to use for creating a package to obtain the details of an
employee using a host variable on the client side.
In SQL*Plus, you plan to use the following commands:
SQL> VARIABLE x REFCURSOR
SQL> EXECUTE emp_data.get_emp(195,:x)
SQL> PRINT x
Which statement is true about the above scenario?
A. The package executes successfully and passes the required data to the host variable.
B. The package specification gives an error on compilation because cursor variable types cannot be defined in the
C. The package specification gives an error on compilation because the cursor variable parameter was specified
before you defined it.
D. The package executes successfully, but does not pass the required data to the host variable because the cursor is
closed before the PRINT statement runs.
3. Which statement describes the purpose of the plshprof command?
A. It produces HTML output from raw profiler output.
B. It produces HTML output from profiler tables in the database.
C. It populates profiler tables in the database from ra