Online Access Free 1Z0-146 Practice Test

Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)

• A.Verify an existing schema name.
• B.Verify qualified SQL names.
• C.Check input string length.
• D.Enclose string literals within double quotation marks.
• E.Validate TNS connect strings.
• F.Detect a wrong user.

Which two statements are true about cursor variables? (Choose two.)

• A.Cursor variables can be parameterized like cursors.
• B.The FETCH statement executes the query associated with a cursor variable and identifies the result set.
• C.The query associated with a cursor variable cannot reference host variables and PL/SQL variables.
• D.The OPEN FOR statement executes the query associated with a cursor variable and identifies the result set.
• E.Cursor attributes (%FOUND, %NOTFOUND, %ISOPEN, and %ROWCOUNT) can be applied to a cursor variable.

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 a stored procedure, stored function, packaged procedure, or packaged function.
• C.You can obtain information about the position, name, and data type of the arguments of a procedure.
• D.You can describe anonymous PL/SQL blocks.

View the Exhibit and examine the structure of the EMPLOYEES table.

Examine the following PL/SQL block for storing the salary of all sales representatives from the
EMPLOYEES table in an associative array:
1 DECLARE
2 emp_cv SYS_REFCURSOR;
3 TYPE list IS TABLE OF emp_cv;
4 sals list;
5 BEGIN
6 OPEN emp_cv FOR SELECT salary FROM employees
7 WHERE job_id = 'SA_REP';
8 FETCH emp_cv BULK COLLECT INTO sals;
9 CLOSE emp_cv;
10 END;
What should you correct in the above code to ensure that it executes successfully?

• A.Replace line 2 with TYPE refcur IS REF CURSOR; emp_cv refcur;.
• B.Replace EMP_CV in line 3 with employees.salary%TYPE.
• C.Replace line 2 with TYPE refcur IS REF CURSOR RETURN employees.salary%TYPE; emp_cv refcur;.
• D.Replace BULK COLLECT in line 8 with the OPEN, FETCH, LOOP, and CLOSE statements.

You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?

• A.It enables only named PL/SQL blocks that are executed subsequently in the session for tracing.
• B.It enables all PL/SQL blocks that are compiled subsequently in the session for tracing.
• C.Only anonymous PL/SQL blocks that are executed subsequently in the session are traced.
• D.All PL/SQL blocks that are executed subsequently in the session are traced.