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

相似题目

• 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

  查看最佳答案

• 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 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 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 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

  查看最佳答案

• When clearing customs for a foreign voyage，which of the following is processed at the custom’s house and returned to the vessel（）.

  A . Shipping Articles B . Traveling Curio Manifest C . Official Logbook D . Cargo Gear Register

  查看最佳答案

• 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.

  查看最佳答案

• We make inferences about another’s “intelligence, gender, age, approachability, financial well-being, class, tastes, values, and cultural background” from . Which of the following is NOT true?

  查看最佳答案

• Scientist 2 explains that ice sublimes to water vapor and enters Europa&39;s atmosphere. If ultraviolet light then broke those water vapor molecules apart, which of the following gases would one most likely expect to find in Europa&39;s atmosphere as a result of this process？

  A.Nitrogen B.Methane C.Chlorine D.Oxygen

  查看最佳答案