Examine the following command:

SQL>ALTER SESSION SET plsql_warnings * 'enable: severe', 'enable: performance', 'ERROR: 05003';

What is the implication of the above command?

A. It issues a warning whenever ERROR: 05003 occur during compilation.

B. It causes the compilation to fail whenever the warning ERROR.05003 occurs.

C. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.

D. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

A. The SELECT list is not known until run time.

B. The dynamic SQL statement retrieves rows into records.

C. You do not know how many columns a SELECT statement will return, or what their data types will be.

D. You must use the % FOUND SQL cursor attribute after issuing a dynamic SQL statement that is an INSERT or UPDATE statement.

View the Exhibit and examine the code.

Why does the code give an error on execution?

A. because the WORD_LIST variable is not visible in PROCEDURE WORDING

B. because the LEXICON variable is not visible in PROCEDURE ADD_ENTRY

C. because the LEXICON variable is not initialized in PROCEDURE WORDING

D. because the WORD_LIST parameter in IN OUT mode cannot be of a RECORD data type

Which two statements are true about statement-level and row-level triggers? (Choose two.)

A. A row trigger fires once even if no rows are affected.

B. A statement trigger fires once even if no rows are affected.

C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

Which system events can be used to create triggers that fire both at DATABASE and SCHEMA levels? (Choose two.)

A. AFTER LOGON

B. AFTER STARTUP

C. BEFORE SHUTDOWN

D. AFTER SERVERERROR

View the Exhibit to examine the PL/SQL block.

Which statement is true about the output of the PL/SQL block?

A. It executes and the output is emprec.deptname:.

B. It executes and the output is emprec.deptname: Sales.

C. It produces an error because NULL is assigned to the emprec.empid field in the record.

D. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

View the Exhibit to examine the PL/SQL code.

Which statement is true about the execution of the code?

A. The exception raised in the code is handled by the exception handler for the PAST_DUE exception.

B. It does not execute because you cannot declare an exception with a similar name in the subblock.

C. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock.

D. The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler

Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose two.)

A. line 2

B. line 3

C. line 4

D. line 5

Which three statements are true about wrapping? (Choose three.)

A. The PL/SQL wrapper detects and reports only syntactic errors.

B. The PL/SQL wrapper detects and reports both syntactic and semantic errors.

C. When wrapping a package or object type, both the body and specification should be wrapped.

D. When wrapping a package or object type, only the body should be wrapped, not the specification.

E. To change a wrapped object, the original source code needs to be modified and then wrapped again.

F. To change a wrapped object, the wrapped code can be unwrapped, modified in a text file, and then wrapped again.

Which two statements are true about the EXIT statement encountered in LOOP? (Choose two.)

A. The PL/SQL block execution terminates immediately after the EXIT statement.

B. The loop completes immediately and control passes to the statement after END LOOP.

C. The statements after the EXIT statement in the iteration are not executed before terminating the LOOP.

D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.