ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 19c 认证1Z0-083考试题库(第8题)

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

原创 Oracle 作者:unix_5359 时间:2021-03-02 10:36:09 0 删除 编辑

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

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


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31544987/viewspace-2760495/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

注册时间:2018-07-05

  • 博文量
    270
  • 访问量
    164923