Oracle认证考试章节练习(2020.01.15)

来源：考试资料网

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?（）

点击查看答案

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？（）

点击查看答案

4 Given:

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

点击查看答案

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

点击查看答案

6.问答题什么是事务？事务相关的三个命令是什么？

参考答案：

事务就是把很多相联的sql语句作为一个单元进行操作。
相关命令：Commit；，savepoint，rollback。

进入题库练习

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？（）

点击查看答案

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

点击查看答案

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

点击查看答案

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（）

点击查看答案