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

相似题目

• 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 .  log writer B .  archival C .  process monitor D .  system monitor E .  change tracking writer F .  database writer

  查看最佳答案

• Which background process coordinates the rebalance activity for disk groups？（）

  A .  ORBn B .  OSMB C .  RBAL D .  ASM

  查看最佳答案

• Which statement is true about the Manageability Monitor （MMON） background process（）

  A . It transfers statistics from memory to disk at regular intervals. B . It coordinates the rebalance activity for disk groups when ASM is used. C . It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance. D . It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

  查看最佳答案

• Which three statements correctly describe the features of the I/O calibration process?（）

  A . Only one I/O calibration process can run at a time. B . It automates the resource allocation for the Automated Maintenance Tasks. C . It improves the performance of the performance-critical sessions while running. D . It can be used to estimate the maximum number of I/Os and maximum latency time for the system. E . The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

  查看最佳答案

• 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

  查看最佳答案

• You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）

  A . System monitor （SMON） B . Process monitor （PMON） C . Memory manager process （MMAN） D . Manageability Monitor process （MMON）

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）

  A . CKPT DBWn LGWR PMON SMON B . ARCn CKPT DBWn LGWR SMON C . CJQ0 CKPT DBWn LGWR SMON D . DBWn LGWR PMON RECO SMON E . CKPT DBWn LMON PMON SMON

  查看最佳答案

• The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）

  A . DISPATCHER  B . USER  C . SERVER  D . LGWR  E .  DBW0

  查看最佳答案

• 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

  查看最佳答案

• Which three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）

  A .  It creates jobs without considering the priorities associated with them. B .  It translates tasks into jobs for execution by the scheduler. C .  It determines the list of jobs that must be created for each maintenance window. D .  It is spawned by the MMON background process at the start of the maintenance window. E .  It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

  查看最佳答案

• You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  A .  MMAN B .  PMON C .  MMON D .  MMNL

  查看最佳答案

• As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?（）

  A . CKPT B . SMON C . MMON D . DBWR

  查看最佳答案

• Which three statements correctly describe the features of the I/O calibration process？（）

  A .  Only one I/O calibration process can run at a time B .  It automates the resource allocation for the Automated Maintenance Tasks C .  It improves the performance of the performance-critical sessions while running D .  It can be used to estimate the maximum number of I/Os and maximum latency time for the system E .  The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE

  查看最佳答案

• Which two statements about the background process of thedatabase writerare true（） 

  A . It is possible to have multiple database writers in an Oracle instance. B . It writes dirty buffers， if any， to data files whenever a checkpoint occurs. C . It writes dirty buffers， if any， to data files whenever a transaction commits. D . It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.

  查看最佳答案

• Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）

  A . PMON B . SMON C . LGWR D . CKRT

  查看最佳答案

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

  A . CKPT B . SMON C . LGWR D . DBWn E . ARC

  查看最佳答案

• Which background process reads the redo log buffer and writes it to a file？（）

  A . ARCn B . DBWn C . CKPT D . LGWR E . PMON F . SMON

  查看最佳答案

• Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）

  A . PMON B . SMON C . CKPT D . LGWR E . ARC

  查看最佳答案

• Which two statements about the background process of the database writer are true（）

  A . It is possible to have multiple database writers in an Oracle instance. B . It writes dirty buffers， if any， to data files whenever a checkpoint occurs. C . It writes dirty buffers， if any， to data files whenever a transaction commits. D . It writes dirty buffers， if any， to data files before the log writer （LGWR） write

  查看最佳答案

• You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）

  A .  RBAL B .  CKPT C .  SMON D .  PMON E .  MMON F .  CTWR G .  DBWR

  查看最佳答案

• You need to enhance performance of foreground and background applications. How can you configure Windows 2000 Professional to process both foreground and background applications at the same priority？ （）

  A . By selecting the applications options in the performance options dialog box. B . By selecting the application services option in the performance options dialog box. C . By selecting the background option in the performance options dialog box. D . By selecting the background services option in the performance options dialog box.

  查看最佳答案

• Which pattern of comparison do you find in the following outlines? Person A 1) family background 2) educational background 3) working experience Person B 1) family background 2) educational background 3) working experience

  查看最佳答案