Examine the statements that use flashback technologies:
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');
SELECT * FROM customers AS OF SCN 123456;
FLASHBACK TABLE customers TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?
Choose three. Which three are performed by Oracle Automatic Storage Management (ASM) instances?
Copyright © 2021-2024 CertsTopics. All Rights Reserved
