Online Access Free 1Z0-146 Exam Questions

You enabled PL/SQL tracing in a user session using the following command:
SQL> EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS);
View Exhibit1 to examine the output. After some time, the query produces a different result as
shown in Exhibit2.

What is the cause for the change?

• A.The FOO procedure has been compiled with the DEBUG option, and executed.
• B.Schema level statistics have been gathered by the database administrator (DBA).
• C.The FOO procedure has been executed more than once.
• D.The PLSQL_DEBUG parameter is set to FALSE for the user session.

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 optimizes PL/SQL programs by elimination of unnecessary computations and exceptions.
• 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.PL/SQL statements in a PL/SQL program unit are compiled into machine-readable code, and stored in the SYSTEM tablespace.

Identify two strategies against SQL injection. (Choose two.)

• A.Using parameterized queries with bind arguments.
• B.Use RESTRICT_REFERENCE clauses in functions that use dynamic SQLs.
• C.Use subprograms that are run with the definer's right.
• D.Validate user inputs to functions that use dynamic SQLs built with concatenated values.

Examine the structure of the EMPLOYEES table in the SCOTT schema. Name Null? Type
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
SALARY NOT NULL NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
DEPARTMENT_ID NUMBER(4)
View the Exhibit and examine the code for the EMP_TOTSAL procedure created by user SCOTT.
Which statement is true regarding the EMP_TOTSAL procedure?

• A.It is created successfully and displays the correct output message for both existent and nonexistent employee IDs.
• B.It is created successfully, but displays the correct output message only for existent employee IDs.
• C.It generates an error because a user-defined exception has to be included whenever the %NOTFOUND attribute is used in combination with a SELECT INTO statement.
• D.It generates an error because the %NOTFOUND attribute cannot be used in combination with a SELECT INTO statement.

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 are never inlined in both the sections commented as Call 1 and Call 2.
• B.The calls to the P1 procedure are inlined in both the sections commented as Call 1 and Call 2.
• C.The calls to the P1 procedure are not inlined in the section commented as Call 1.
• D.The calls to the P1 procedure might be inlined in the section commented as Call 2.