READ Free Dumps For Oracle- 1z0-144
Question ID 2656 | Which statement is true about triggers on data definition language (DDL) statements? |
Option A | A. They can be used to track changes only to a table or index. |
Option B | B. They can be defined by all users in the database or only by a specific user. |
Option C | C. They are fired only when the owner of the object Issues the DDL statement. |
Option D | D. They can be used to track changes to a table, table space, view, or synonym. |
Correct Answer | A,B |
Question ID 2657 | Which two statements are correct about PL/SQL package components? (Choose two) |
Option A | A. A package must have both specification and body. |
Option B | B. A package body can exist without the package specification. |
Option C | C. A package specification can exist without the package body. |
Option D | D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory. |
Correct Answer | C,D |