12C-OCP升级1z-060-009

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle
Database 12c when it is enabled?
A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved parallel Execution performance
D. Improved Serial Execution performance
E. Reduced physical I/O
F. Reduced CPU utilization

Answer: B,C,F

正确答案解析：
Multiprocess and Multithreaded Oracle Database Systems 官方文档的位置
https://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT1245
摘取官方文档中的内容
Multiprocess and Multithreaded Oracle Database Systems

Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users—either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously.
在多进程的Oracle数据库中，通常会运行一些的进程作为Oracle本身的部分功能存在（我们通常叫这些进程为后台进程），此外，还有一些额外的进程用于处理用户的连接（这种我们称之为前台进程）。在多数的情况，商业数据库最大的优势就是执行多用户可以同时并发的来访问我们的数据库。

Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.
所谓存在即合理，数据库中的每一个进程都有不同的任务。Oracle数据库把各种工作或者功能分发给不同的进程进程承担，不同的用户或者是应用能够同时的连接到数据库实例，通过这种多进程的架构，可以获得更好的性能。

In releases earlier than Oracle Database 12c, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces. When Oracle Database 12c is installed, the database runs in process mode. You must set the THREADED_EXECUTION initialization parameter to TRUE to run the database in threaded mode. In threaded mode, some background processes on UNIX and Linux run as processes (with each process containing one thread), whereas the remaining Oracle processes run as threads within processes.
在12c以前的Oracle数据库都是多进程的架构，在Oracle Database 12c中，Oracle引入了多线程模式，允许在Windows平台之外的Unix、Linux系统使用多线程模式，结合多进程与多线程模式，Oracle可以改进进程管理与性能。当12c数据库安装安城以后，数据库默认还是运行在多进程的模式下面的，如果你想要使你的数据库运行在多进程这个模式下面，你必须设置THREADED_EXECUTION为True。在多进程模式下面，某些进程依旧是以操作系统的进程在存在的，但某些进程有了变化，作为了进程中的线程而存在了

In a database running in threaded mode, PMON and DBW might run as operating system processes, whereas LGWR and CMON might run as threads within a single process. Two foreground processes and a parallel execution (PX) server process might run as threads in a second operating system process. A third operating system process might contain multiple foreground threads. Thus, "Oracle process" does not always mean "operating system process."
当数据库运行在县城模式下面的时候，PMON和DBWN进程依旧还是作为操作系统的进程在运行的，但是LGWR和CMON这两耳，现在只作为一个进程中的线程而存在了。两个前台进程和一个并行的服务进程可以同时作为一个进程下面的县城而存在。在12c的多线程模式中。一个操作系统进程现在是可以包含有多个前台进程中，这也意味了，"Oracle 进程"在12c中与操作系统进程不在是一一对应的关系，很有可能，它只是一个线程。

具体的关于12c多线程的内容可以参考eygle的技术博客：
http://www.eygle.com/archives/2013/07/oracle_database_12c_multithreaded_model.html
所以：
A不正确 多进程，多线程的架构，并没有提到对逻辑IO的影响。
B正确 在多线程的架构中，进程的数量明显的减少了，会减少对内存的消耗
C确定 多进程，多线程的架构，显然提高的是并行的性能。
D不正确
E不正确 没提到对物理IO的影响
F正确 进程数量的减少，使得CPU要处理的进程的数量也减少了