READ Free Dumps For Oracle- 1z0-144
| Question ID 2633 | View the Exhibit and examine the structure of the customer table. |
| Option A | A. It compiles successfully. |
| Option B | B. It gives an error because the when condition is not valid. |
| Option C | C. It gives an error because when cannot be used for row-level triggers. |
| Option D | D. It gives an error because the statements under updating are not valid. |
| Option E | E. It gives an error because the new qualifier in the when clause requires a colon prefix. |
| Correct Answer | A |
| Question ID 2634 | Which statements are true about PL/SQL procedures? (Choose all that apply.) |
| Option A | A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself. |
| Option B | B. Reuse of parsed PL/SQL code that becomes available in theshared SQL area of the server avoids the parsing overhead of SQL statements at run time. |
| Option C | C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance. |
| Option D | D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java. |
| Correct Answer | B,D |