In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information. Whataction would you take to achieve this task（）A.Apply fine-grained auditing.B.Implement value-based auditing.C.Impose standard database auditing to audit object privileges.D.Impose standard database auditing to audit SQL statements.

单项选择题

In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track
users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.
Whataction would you take to achieve this task（）

A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to audit object privileges.
D.Impose standard database auditing to audit SQL statements.

相关考题

单项选择题 The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects. Which statement is true in this scenario（）

多项选择题 WhichtwostatementsaretrueregardingB-treeindexs（）

单项选择题 Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

1Z0-052