移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

计算机考试 | Oracle认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 Which of the following statements best describes Flashback Versions Query?()  

A

 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

B

 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.

C

 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

D

 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

单选题 You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()

A

Restore the backup control file and open the database with RESETLOGS option.

B

Perform point-in-time recovery because flashback cannot be performed again on this table

C

Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

D

Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

多选题 What two are the prerequisites for enabling Flashback Database?() (Choose two)

A

The database must be in ARCHIVELOG mode

B

The database must be in MOUNT EXCLUSIVE mode

C

The database must be opened in RESTRICTED mode

D

The database instance must be started in the NOMOUNT state

E

The database instance must have the keep buffer pool defined

多选题 You plan to execute the following command to perform a Flashback Database operation in your database:   SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()

A

 The database must have multiplexed redo log files

B

 The database must be in the MOUNT state to execute the command

C

 The database must be in the NOMOUNT state to execute the command

D

 The database must be opened in RESTRICTED mode before this operation

E

 The database must be opened with the RESETLOGS option after the flashback operation

多选题 Which two commands never trigger an implicit rebalancing within the disk group?() (Choose two.)

A

ALTER DISKGROUP misc MOUNT;

B

ALTER DISKGROUP misc DROP DISK misc2;

C

ALTER DISKGROUP misc CHECK ALL NOREPAIR;

D

ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

E

ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

单选题 Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?()  

A

 a cumulative level 1 backup

B

 a differential level 1 backup

C

 a full backup

D

 a whole backup

单选题 To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?()

A

EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.

B

EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.

C

EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.

D

Either B or C

E

All of the above

单选题 Performance divergence indicated in the Workload Replay report is most likely due to what?()  

A

 DML and SQL statement results that do not match between the capture and replay systems

B

 When errors that occur in the capture system dont occur in the replay system

C

 Top SQL statements

D

 Infrastructure or system-configuration differences

E

 Time-of-day differences between capture and replay systems

最新资讯

首页 上一页 1 2 3 4 5 下一页 尾页 /

到第