单项选择题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）
A.implementing value-based auditing by using triggers
B.implementing fine-grained auditing with audit condition and event handler
C.performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D.performing standard database auditing to audit SQL statements with granularity level set to ACCESS
相关考题
-
单项选择题
YouareusingthebackupschedulerinEnterpriseManager（EM）toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate？（）
A.SQL script
B.PL/SQL script
C.Operating System （OS） script
D.Enterprise Manager （EM） script
E.Recovery Manager （RMAN） script -
单项选择题
You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）
A.by using triggers
B.by using external tables
C.by using anonymous PL/SQL blocks
D.by auditing all DML operations on the table -
单项选择题
Asaresultofperformanceanalysis，youcreatedanindexontheprod_namecolumnoftheprod_dettable，whichcontainsabouttenthousandrows.Later，youupdatedaproductnameinthetable.Howdoesthischangeaffecttheindex？（）
A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates.
