QUESTION: 13

Examine the following PL/SQL code:

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

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

Answer(s): A

Show Answer Next Question

QUESTION: 14

View the Exhibit and examine the blocks of code that you plan to execute.
Which statement is true about the blocks of code?

All the blocks execute successfully and the anonymous block displays cant: 45
cnt: 45
All the blocks execute successfully and the anonymous block displays cut: 0
cart: 1
The anonymous block gives an error because the function invocation in line 2 is not valid.
The procedure creation gives an error because the function invocation in line 1 is not valid.

Answer(s): A

Show Answer Next Question

QUESTION: 15

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

A row trigger fires once even if no rows are affected.
A statement trigger fires once even if no rows are affected.
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.
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.

Answer(s): B,C

Show Answer Next Question

View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:

Which statement is true about the above trigger?

It gives an error on compilation because it should be a statement-level trigger.
It compiles and fires successfully when the credit limit is updated in the customer table.
It gives an error on compilation because of the commit command in the trigger code
It compiles successfully, but gives an error when the credit limit is updated in the

CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.

Answer(s): D

Show Answer Next Question

Free Oracle 1Z0-144 Exam Questions (page: 7)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16

1Z0-144 Exam Discussions & Posts