Which two statements about Automatic Storage Management （ASM） are true？（）

多项选择题Whichthreestatementsaretrueregardingthefine-grainedauditing（FGA）？（）

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.

单项选择题Yourdatabaseisfunctionalwithpeakloadforonehour.Youwanttopreservetheperformancestatisticscollectedduringthisperiodsothattheycanbeusedforcomparisonwhileanalyzingtheperformanceofthedatabaseinthefuture.Whatactionwouldyoutaketoachievethistask？（）

A.Set the STATISTICS_LEVEL initialization parameter to ALL.
B.Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C.Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

单项选择题Whichisthememoryareathatiscreatedwhenadedicatedserverprocessisstarted，andcontainsdataandcontrolinformationforthatserverprocess？（）

A.SGA
B.PGA
C.Shared Pool
D.Streams Pool

单项选择题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.

单项选择题Your database is not configured for session failover. Your tnsnames.ora file contains the following details：  test.us.oracle.com= （DESCRIPTION=  （ADDRESS_LIST= （LOAD_BALANCE=off）   （FAILOVER=ON）   （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））   （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））   （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com）））   Which feature is enabled in this case？（）

A.Load balancing
B.Instance failover
C.Database failover
D.Connect-time failover
E.Transparent Application Failover （TAF）