单项选择题
The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.
What would you do？（）
A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a time period of two hours.
D. Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.
相关考题
-
多项选择题
The EMP table exists in your schema. You want to execute the following query： SELECT ename， sal FROM emp AS OF TIMESTAMP （SYSTIMESTAMP - INTERVAL ’6’ MINUTE） WHERE ename = ’ALLEN’； What are the minimum requirements for the statement to execute successfully？（）
A. ARCHIVELOG mode must be enabled
B. Row Movement must be enabled for the table
C. FLASHBACK must be set to ON for the database
D. The UNDO_MANAGEMENT parameter must be set to AUTO
E. The UNDO_RETENTION parameter must be set appropriately -
单项选择题
You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows： CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ； Which statement regarding the above command is correct？（）
A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group. -
多项选择题
OnwhichtwodatabaseobjectscantheVERSIONSclauseoftheFlashbackVersionsQuerybeused？（）
A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables （IOTs）
