READ Free Dumps For Oracle- 1z0-050
| Question ID 6053 | You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.) |
| Option A | Auditing is enabled for all privileges. |
| Option B | Auditing is disabled for all privileges. |
| Option C | The audit trail is stored in the database |
| Option D | The audit trail is stored in an operating system file. |
| Option E | Auditing is enabled for certain privileges related to database security. |
| Correct Answer | C,E |
| Question ID 6054 | A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition? |
| Option A | It remains valid. |
| Option B | It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used. |
| Option C | It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table. |
| Option D | It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used. |
| Correct Answer | A |