Which background process of a database instance，using Automa

第1题：

第2题：

Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）

• A、ASMB
• B、PMON
• C、RBAL
• D、SMON

第3题：

第4题：

You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

• A、The instance would hang.
• B、The instance needs to be shut down.
• C、The instance would be in the open state.
• D、The instance would abort in such cases.
• E、The instance would be in the open and invalid state.
• F、The instance would in the open state， but all the background processes will be restarted.

第5题：

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

第6题：

Which statement is true regarding Dynamic Service Registration？（）

• A、Dynamic service registration requires configuration in the listener .ora file.
• B、Dynamic service registration can be used only with an Oracle9/instance.
• C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
• D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

第7题：

Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

• A、 DBWn
• B、 RECO
• C、 RVWR
• D、 LGWR

第8题：

第9题：

Which two statements are true regarding the starting of the database instance using the following command?（） SQL>STARTUP UPGRADE

• A、It enables all system triggers.
• B、It allows only SYSDBA connections.
• C、It ensures that all job queues remain active during the upgrade process.
• D、It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

第10题：

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

• A、archival
• B、log writer
• C、database writer
• D、system monitor
• E、process monitor
• F、change tracking writer