Question 5) New Features for Administrators

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Objective : Security
SubObjective : Use Fine-Grained Auditing for DML Statements

Single Answer Multiple Choice

 

You need to audit the records of the SALES table in your database. The auditing activity should capture information about the details of the Structured Query Language (SQL) statements that affect the records of the SALES table. Which auditing technique would enable you to capture the SQL statements that query or manipulate your data?

 

A. Value-Based Auditing
B. Fine-Grained Auditing
C. Standard Database Auditing
D. You cannot capture the SQL statements that are manipulating the data by auditing your data.

 

Answer:
B. Fine-Grained Auditing

 

Tutorial:
Fine-Grained Auditing (FGA) would enable you to capture the SQL statements that query or manipulate your data. You implement FGA by using the DBMS_FGA package.

 

Value-Based Auditing cannot be used to capture the SQL statements that query or manipulate data. Value-Based Auditing uses database triggers to capture the changed values of data but does not capture the SQL statements that query or manipulate data.

 

Standard Database Auditing cannot be used to capture the SQL statements that query or manipulate data. Standard Database Auditing audits the actions being performed on data but does not capture the SQL statements and does not store the changed data in the database.

 

The option stating you cannot capture the SQL statements that are manipulating the data by auditing your data is incorrect because you can use fine-grained auditing to capture SQL statements manipulating your data.

 

Reference:
1. Oracle University – Oracle Database 10g: New Features for Administrators – Security

 

2. OTN – http://download-west.oracle.com/docs/cd/B14117_01/network.101/b10773/cfgaudit.htm#1011303

 

These questions are derived from the Self Test Software Practice Test for Oracle exam #1Z0-040: Oracle Database 10g: New Features for Administrators.

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: