单项选择题
You execute the following command toauditdatabase activities：
SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command（）
A.Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
B.Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
相关考题
-
单项选择题
In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information. What action would you take to achieve this task（）
A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to auditobject privileges.
D.Impose standard databaseauditing to audit SQL statements. -
单项选择题
ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N Which statement describes the purpose of the above password file（）
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups. -
多项选择题
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
A.the retention period to support flashback
B.the expected length of the longest-running query
C.the number of undo tablespaces in the database
D.the size of the Flash Recovery Area for the database instance
