Oracle認(rèn)證考試章節(jié)練習(xí)(2019.12.21)

來源：考試資料網(wǎng)

1 In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

點(diǎn)擊查看答案

2 CREATE，DROP，ALTER等命令屬于下列哪類命令（）

點(diǎn)擊查看答案&解析

3 Given：

Which statement is true？（）

點(diǎn)擊查看答案

4 Consider the following scenario for your database:

Which statement is true regarding the backup of the TOOLS tablespace?（）

點(diǎn)擊查看答案

5 （）是Oracle維護(hù)數(shù)據(jù)庫中其他文件的列表、數(shù)據(jù)庫名稱和系統(tǒng)改變號(hào)（SCN）的文件。

點(diǎn)擊查看答案&解析

6 You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

點(diǎn)擊查看答案

7 You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

點(diǎn)擊查看答案

8 While deploying a new application module，the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences？（）

點(diǎn)擊查看答案

9 Which four are types of functions available in SQL? （）

點(diǎn)擊查看答案

10 You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?（）

點(diǎn)擊查看答案

广告位招租联系QQ:5245112（WX同号）