多项选择题
Which two statements about Automatic Storage Management （ASM） are true？（）
A.ASM provides mirroring on file by file basis.
B.ASM provides automatic load balancing across all ASM disks.
C.ASM supports the Oracle database and operating system files.
D.ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
相关考题
-
多项选择题
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
