单项选择题
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 -
单项选择题
WhichstatementistrueabouttheUNDO_RETENTIONparameterwhenretentionguaranteeisnotenabled()
A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporarytablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
