Oracle Database 12c Advance Adminstration1z0-063 Test 4

© examsnet.com

Question : 30 of 40

Marks: +1, -0

Examine this query:

SELECT cust_name, amt_due FROM customers   
 AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) 
 WHERE cust_no = 'AYR2011';

Which two requirements guarantee that the query will execute successfully? (Choose two.)

Row movement must be enabled for CUSTOMERS.
Automatic Undo Management must be configured.
FLASHBACK must be ON for the database.
Undo retention guarantee must be enabled.
The database must be in ARCHIVELOG mode.
Supplemental logging must be enabled.

Go to Question:

Advertisements