单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）A ARCH B SMON C LGWRD SERVER

第1题：

Note the functionalities of various background processes：  1：Perform recovery at instance startup. SMON  2：Free the resources used by a user process when it fails. PMON  3：Cleanup the database buffer cache when a process fails. PMON  4：Dynamically register database services with listeners. PMON  5：Monitor sessions for idle session timeout. PMON  6：Cleanup unused temporary segments. SMON  7：Record the checkpoint information in control file. CKPT  Which option has the correct functionalities listed for a background process（）

• A、Checkpoint （CKPT）： 1， 2， 5
• B、System Monitor （SMON）： 1， 6
• C、Process Monitor （PMON）： 4， 6， 7
• D、Database Writer （DBWR）： 1， 3， 4

第2题：

Which is the correct description of a pinned buffer in the database buffer cache（）

• A、The buffer is currently being accessed.
• B、The buffer is empty and has not been used.
• C、The contents of the buffer have changed and must be flushed to the disk by the DBWn process. 
• D、The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.

第3题：

第4题：

Which three statements are true about memory buffer allocation by a MySQL Server?（）

• A、Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
• B、Thread buffers are allocated when a client connects, and are freed when the client disconnects
• C、Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
• D、User buffers are allocated at server startup and freed when the user is dropped
• E、All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed

第5题：

Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）

• A、The minimum memory size for the database buffer cache is set to 100 mb.
• B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
• C、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
• D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

第6题：

Upgrading which of the following components in a server has the GREATEST affect on virtualization？（）

• A、Amount of Memory
• B、Number of HBAs
• C、Hard drive cache size
• D、ECC ability in memory

第7题：

Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

• A、User process
• B、Server process
• C、System Monitor (SMON)
• D、Process Monitor (PMON)
• E、Checkpoint process (CKPT)

第8题：

第9题：

During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）

• A、DBW0 
• B、LGWR 
• C、ARCH 
• D、SMON 
• E、PMON

第10题：

Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）

• A、ARCH 
• B、SMON 
• C、LGWR
• D、SERVER