black

OCP 11G认证考试

单项选择题

Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）

A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5

相关考题

单项选择题 You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?（）

单项选择题 In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）

多项选择题 Which three functions are performed by the SQL Tuning Advisor? （）

All Rights Reserved 版权所有©在线考试题库网(zxkao.com)

备案号：湘ICP备14005140号-7

经营许可证号：湘B2-20140064