Oracle
1Z0-052 · Question #34
1Z0-052 Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Implementing Oracle Database Auditing
Question
What is the effect of this command? SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
Options
- AOne audit record is created for every successful DROP TABLE command executed in the session
- BOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege
- COne audit record is created for the whole session if user SCOTT successfully drops one or more
- DOne audit record is created for every session of any other user in which a table owned by SCOTT
- EOne audit record is created for every successful DROP TABLE command executed by any user to
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#statement auditing#BY SESSION#WHENEVER SUCCESSFUL#audit record granularity