we provide Precise Oracle 1Z0-146 answers which are the best for clearing 1Z0-146 test, and to get certified by Oracle Oracle 11g: Advanced PL/SQL. The 1Z0-146 Questions & Answers covers all the knowledge points of the real 1Z0-146 exam. Crack your Oracle 1Z0-146 Exam with latest dumps, guaranteed!
Q1. Examine the following parameter values for a session:
PLSQL_CODE_TYPE = NATIVE
PLSQL_OPTIMIZE_LEVEL = 2
Which two statements are true in this scenario? (Choose two.)
A. The compiler automatically inlines subprograms even if you specify that they not be inlined.
B. The compiler optimizes PL/SQL programs by elimination of unnecessary computations and exceptions.
C. PL/SQL statements in a PL/SQL program unit are compiled into machine-readable code, and stored in the SYSTEM tablespace.
D. PL/SQL statements in a PL/SQL program unit are compiled into an intermediate form, machine-readable code, which is stored in the database dictionary.
Q2. Which two statements are true about the extproc process? (Choose two.)
A. It loads the dynamic library.
B. It is started by the server process.
C. It converts the C output back to PL/SQL.
D. A single extproc process serves all user sessions.
Q3. Which two types of query results cannot be stored in the query result cache? (Choose two.)
A. subquery results
B. results of a query having the SYSDATE function
C. results of a query having the GROUP BY clause
D. results of a query having the DATE data type in the WHERE clause
Q4. Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure? (Choose two.)
A. You can describe remote objects.
B. You can describe anonymous PL/SQL blocks.
C. You can describe a stored procedure, stored function, packaged procedure, or packaged function.
D. You can obtain information about the position, name, and data type of the arguments of a procedure.
Q5. View the Exhibit and examine the output.
Which statement is an inference from the output?
A. The class file is pinned into the Java pool.
B. The class file has been loaded into the shared library.
C. Java class methods in the Java class file have been published.
D. The loadjava command has been executed to load the Java source and class files.
Q6. Which two statements correctly describe the features of SecureFiles? (Choose two.)
A. Compression is performed only on the server side and enables random reads and writes to LOB data.
B. Deduplication stores identical data, which occurs in a LOB column in each row, as a single copy within the LOB.
C. Compression can be performed on the client side and it enables random and sequential reads and writes to LOB data.
D. Deduplication stores identical data occurring two or more times in the same LOB column as a single copy for the table.
Q7. Which three statements are true about hierarchical profiling? (Choose three.)
A. It provides function-level summaries.
B. It produces an aggregated report of the SQL and PL/SQL execution times.
C. It is useful for understanding the structure and control flow of complex programs.
D. It can be used to identify hotspots and tuning opportunities in PL/SQL applications.
E. It generates trace information for PL/SQL programs in the PLSQL_TRACE_EVENTS table.
Q8. Examine the commands:
CREATE TYPE typ_course_tab IS VARRAY(5) OF VARCHAR2(20)
/ CREATE TYPE typ_course_nst AS TABLE OF typ_course_tab / CREATE TABLE faculty (faculty_id NUMBER(5), faculty_name VARCHAR2(30), courses typ_course_nst) NESTED TABLE courses STORE AS course_stor_tab / INSERT INTO faculty VALUES (101, 'Jones', NULL); UPDATE (SELECT courses FROM faculty WHERE faculty_id=101) SET courses = typ_course_nst(11,'Oracle'); Which statement is true about the execution of these commands?
A. All the commands execute successfully.
B. Only the first two commands execute successfully. C. Only the first four commands execute suc cessfully. D. Only the first three commands execute successfully.
Q9. Which two statements are true about the OPEN and FILEOPEN routines in the DBMS_LOB package? (Choose two.)
A. OPEN can be used to open only internal LOBs in the indicated mode.
B. FILEOPEN can be used to open only external LOBs in the indicated mode.
C. OPEN can be used to open internal and external LOBs in the indicated mode.
D. FILEOPEN can be used to open internal and external LOBs in the indicated mode.
Q10. 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 specification.
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.