During regular database operation, which background process 

题目
单选题
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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

In the parameter file of the production database, the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location?()

  • A、the alert log file
  • B、the core dump files
  • C、the change tracking file
  • D、the user session trace files
  • E、the database audit trail files
  • F、the background process trace files

正确答案:A,F

第2题:

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

正确答案:C

第3题:

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


参考答案:C

第4题:

Which of the following OSPF messages contains entire complete LSAs used during the database exchange process?()

  • A、LSR
  • B、LSAck
  • C、LSU
  • D、DD
  • E、Hello

正确答案:C

第5题:

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

正确答案:A

第6题:

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

正确答案:A

第7题:

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

正确答案:F

第8题:

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


参考答案:A

第9题:

Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()

  • A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
  • B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
  • C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
  • D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

正确答案:A

第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

正确答案:A,B,C

更多相关问题