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

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

1 Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ？（）

2 View the Exhibits and examine lock waits.

Users HR and SH complain that their transactions on one of the application tables， EMP， are waiting for response.
Which action would you take to release the lock and enable users HR and SH to continue with theirtransactions（）

點(diǎn)擊查看答案

3 To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）

點(diǎn)擊查看答案

4 You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）

點(diǎn)擊查看答案

5 How many database instances are used during a database-duplication process？（）

點(diǎn)擊查看答案

6 Which four are valid Oracle constraint types? （）

點(diǎn)擊查看答案

7 Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？（）

點(diǎn)擊查看答案

8 To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）

點(diǎn)擊查看答案

9 Given：

Which statement is true？（）

點(diǎn)擊查看答案

10 Examine the data in the EMPLOYEES table:

Which three subqueries work?（）

點(diǎn)擊查看答案