Free Oracle 1Z0-146 Exam Dumps Questions & Answers

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.PL/SQL statements in a PL/SQL program unit are compiled into machine-readable code, and stored in the SYSTEM tablespace.
• B.The compiler automatically inlines subprograms even if you specify that they not be inlined.
• C.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.
• D.The compiler optimizes PL/SQL programs by elimination of unnecessary computations and exceptions.

Which two types of query results cannot be stored in the query result cache? (Choose two.)

• A.results of a query having the GROUP BY clause
• B.results of a query having the SYSDATE function
• C.results of a query having the DATE data type in the WHERE clause
• D.subquery results

Examine the section of code taken from a PL/SQL program:
PROCEDURE p1 (x PLS_INTEGER) IS
... ...
PRAGMA INLINE (p1, 'NO');
x:= p1(1) + p1(2) + 17; -- Call 1
...
x:= p1(3) + p1(4) + 17; -- Call 2
Call 1 and Call 2 are the comments for distinguishing the code. The PLSQL_OPTIMIZE_LEVEL
parameter is set to 3. Which two statements are true in this scenario? (Choose two.)

• A.The calls to the P1 procedure might be inlined in the section commented as Call 2.
• B.The calls to the P1 procedure are not inlined in the section commented as Call 1.
• C.The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
• D.The calls to the P1 procedure are never inlined in both the sections commented as Call 1 and Call 2.

View the Exhibit and examine the code in the PL/SQL block.

The PL/SQL block generates an error on execution. What is the reason?

• A.The DELETE(n) method cannot be used with nested tables.
• B.The DELETE(n) method cannot be used with varrays.
• C.The NEXT method cannot be used with an associative array with VARCHAR2 key values.
• D.The NEXT method cannot be used with a nested table from which an element has been deleted.

View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure.

Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)

• A.Explicitly validate the identifier length limit.
• B.Filter out control characters in user-supplied identifier names.
• C.Use the object ID of the table from the data dictionary to build the trigger name.
• D.Add AUTHID DEFINER to the definition of the procedure.
• E.Use PRAGMA RESTRICT_REFERENCES in the procedure.