READ Free Dumps For Oracle- 1z0-144
| Question ID 2682 | View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.
|
| Option A |
A. It executes successfully but the output statements show different values.
|
| Option B | B. It executes successfully and both output statements show the same values. |
| Option C | C. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT. |
| Option D | D. It gives an error because the INSERT SELECT construct cannot be used with the FORALL |
| Correct Answer | A |
| Question ID 2683 | Which two statements are true about triggers? (Choose two.) |
| Option A | A. All the triggers that are created on a table cannot be disabled simultaneously. |
| Option B | B. Any user who has the alter privilege on a table can create atrigger using that table. |
| Option C | C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database. |
| Option D | D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation. |
| Correct Answer | C,D |