Oracle Database Administration II 1z0-083 Question # 17 Topic 2 Discussion

Oracle Database Administration II 1z0-083 Question # 17 Topic 2 Discussion

1z0-083 Exam Topic 2 Question 17 Discussion:
Question #: 17
Topic #: 2

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?


A.

1,3,6


B.

1,2,5


C.

3,4,5


D.

2,3,5,6


Get Premium 1z0-083 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.