单项选择题
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the yearend 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 valuebased auditing by using triggers
B.implementing finegrained 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
相关考题
-
单项选择题
You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL What is the effect of this command？（）
A.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT. -
单项选择题
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）
A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area （SGA） size to increase memory hits. -
多项选择题
WhichthreestatementsaretrueregardingthelogicalstructureoftheOracledatabase？（）
A.Each segment contains one or more extents.
B.Multiple tablespaces can share single data file.
C.A data block is the smallest unit of I/O for data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one OS block.
