READ Free Dumps For Oracle- 1z0-144
Question ID 2731 | View the exhibit and examine the structure of the EMPLOYEE table. |
Option A | A. It consists of two transactions |
Option B | B. It consists of a single transaction, |
Option C | C. The data is automatically committed after the block execution ends, |
Option D | D. It gives an error on execution because sequences cannot be used in anonymous blocks. |
Correct Answer | A |
Question ID 2732 | View the Exhibit and examine the structure of the customer table. |
Option A | A. The trigger is fired, a message is displayed, and the update is successful |
Option B | B. The trigger is fired and a message is displayed, but the update is rolled back. |
Option C | C. The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful. |
Option D | D. The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful. |
Correct Answer | D |