多项选择题
A.FGA is possible on SELECT statements only.
B.The audit trail for FGA is stored in the FGA_LOG$ table.
C.The audit trail for FGA is stored in the AUD_LOG$ table.
D.FGA enables a SQL predicate to define when to audit an event.
E.FGA audits DELETE statements only when audit columns are specified.
F.FGA includes the SQL statement used by the user as part of the audit event entry.
单项选择题 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?()
单项选择题 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?()
单项选择题 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?()