Free Oracle 1Z1-144 Exam Dumps Questions & Answers

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

• A.  The code generates an error because the EMP_RECORD variable is not declared.
• B.  The code executes successfully and gives the desired output.
• C.  The code generates an error because the cursor is not opened before the FOR loop.
• D.  The code generates an error because the loop does not have the exit when clause.

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

Examine the following block of code:

What is the outcome when the above code is executed?

• A.  It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.
• B.  It gives an error because decode cannot be used in a PL/SQL block.
• C.  It gives an error because the AVG function cannot be used in a PL/SQL block
• D.  It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.
• E.  It executes successfully.

View the Exhibit to examine the PL/SQL code.

The record for the employee with employee__id 100 in the employees table is as follows;

Identify the correct output for the code.

• A.  King 17-JUN-87 1500
• B.  King 17-JUN-87 24000
• C.  King current sysdate 24000
• D.  King current sysdate 1500

View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

• A.  It gives an error in line 6.
• B.  It gives an error in line 8.
• C.  It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.
• D.  It gives an error in line 5.
• E.  It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

• A.  It gives an error on compilation because it is not a row-level trigger.
• B.  It compiles and executes successfully.
• C.  It gives an error on compilation because the exception section Is used in the trigger.
• D.  It compiles successfully but gives an error on execution because it is not a row-level trigger.