1Z0-144 Exam Question 26
View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the PIVSQL block of code.

What is the outcome?

View Exhibit2 and examine the PIVSQL block of code.

What is the outcome?
1Z0-144 Exam Question 27
Which statements are true about database triggers? (Choose all that apply.)
1Z0-144 Exam Question 28
View Exhibit1 and examine the structure of the DO table. View Exhibit2 and examine the code.


The anonymous block gives an error on execution. Whatisthe reason?


The anonymous block gives an error on execution. Whatisthe reason?
1Z0-144 Exam Question 29
Which statement is true about triggers on data definition language (DDL) statements?
1Z0-144 Exam Question 30
View the exhibit and examine the structure of the EMPLOYEES table.

The salary of EMPLOYEE_ID 195 is 2800.
You execute the following code:

What is the outcome?

The salary of EMPLOYEE_ID 195 is 2800.
You execute the following code:

What is the outcome?