The EMP table exists in your schema. You want to execut

多项选择题

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？（）

多项选择题 OnwhichtwodatabaseobjectscantheVERSIONSclauseoftheFlashbackVersionsQuerybeused？（）

多项选择题 WhichtwoinitializationparameterswouldyousettoenableAutomaticSharedMemory Management？（）

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064

1Z0-053