What action would you take to achieve this task?

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 long
with the user information.
What action would you take to achieve this task?

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 long
with the 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 audit object privileges.

D.
Impose standard database auditing to audit SQL statements.

Explanation:



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Vij

Vij

D

anonym

anonym

It is B !!!

Standard database auditing does not record old and new values as requested here. With the standard you will only see the statements with the new values (e.g. in case of an update). To get the result you have to implement triggers.
Sadly I could not find some good official statement but a good summary could be found here: http://www.myoracletips.in/2013_02_01_archive.html

Piotr

Piotr

B, no doubts

Google

Google

Every the moment in a when we opt for blogs that we study. Listed below are the newest web-sites that we opt for.