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

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

1 Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)

2 Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.Which two RMAN commands may be; used to back up only the PDB1 pluggable database?（）

點(diǎn)擊查看答案

3 You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？（）

點(diǎn)擊查看答案

4 Given:

Under which three circumstances will the code on line 37 be executed?（）

點(diǎn)擊查看答案

5 Which operator can be used with a multiple-row subquery? （）

點(diǎn)擊查看答案

6.問答題什么是事務(wù)？事務(wù)相關(guān)的三個(gè)命令是什么？

參考答案：

事務(wù)就是把很多相聯(lián)的sql語句作為一個(gè)單元進(jìn)行操作。
相關(guān)命令：Commit；，savepoint，rollback。

進(jìn)入題庫練習(xí)

7 You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）

點(diǎn)擊查看答案

8 Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）

點(diǎn)擊查看答案

9 What effect should the loss of an index tablespace have on an Oracle instance that is running？（）

點(diǎn)擊查看答案

10 View the Exhibit and examine the output.
You execute the following RMAN command to perform the backup operation:

What is the multiplexing level in the preceding backup process（）

點(diǎn)擊查看答案