Oracle OCP 19c 认证1Z0-083考试题库(第8题)

本文主要是介绍Oracle OCP 19c 认证1Z0-083考试题库(第8题)，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

8、Examine the statements that use flashback technologies:

1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);

2. SELECT * FROM customers AS OF SCN 123456;

3. FLASHBACK TABLE customers TO BEFORE DROP;

4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00’, ‘YYYY-MM-DD HH:MI:SS’);

5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

6. ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements 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

Answer：B

(解析：答案 6 是不依赖 undo，答案 3 也是不依赖 undo，使用排除法，正确答案是 B。)

这篇关于Oracle OCP 19c 认证1Z0-083考试题库(第8题)的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！