网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
As shown in the diagram, in－memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()
A. CKPTB. SMONC. MMOND. DBWR
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A. ASMBB. PMONC. RBALD.SMON
考题
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 fileB、the core dump filesC、the change tracking fileD、the user session trace filesE、the database audit trail filesF、the background process trace files
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?（）A、ASMBB、PMONC、RBALD、SMON
考题
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A、 DBWnB、 RECOC、 RVWRD、 LGWR
考题
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A、 RBALB、 CKPTC、 SMOND、 PMONE、 MMONF、 CTWRG、 DBWR
考题
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、 MMANB、 PMONC、 MMOND、 MMNL
考题
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.
考题
Which of the following OSPF messages contains entire complete LSAs used during the database exchange process?（）A、LSRB、LSAckC、LSUD、DDE、Hello
考题
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、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
考题
While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A、ARCnB、CKPTC、DBWnD、LGWRE、PMONF、SMON
考题
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
考题
Which statements are true regarding the Oracle Data Pump export and import operations（）A、You cannot export data from a remote database.B、You can rename tables during an import operation.C、You can overwrite existing dump files during an export operation.D、You can compress the data during export but not the metadata because it is not supported
考题
Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）A、CKPTB、SMONC、LGWRD、DBWnE、ARCn
考题
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）A、ASMBB、PMONC、RBALD、SMON
考题
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
考题
Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）A、Archiver Process （ARCn）： 1， 2， 5B、System Monitor Process （SMON）： 1， 4， 5C、Process Monitor Process （PMON）： 4， 5， 6D、Database Writer Process （DBWn）： 1， 3， 4
考题
单选题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
考题
单选题Which of the following OSPF messages contains entire complete LSAs used during the database exchange process?（）A
LSRB
LSAckC
LSUD
DDE
Hello
考题
单选题Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A
ASMBB
PMONC
RBALD
SMON
考题
单选题While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）A
ARCnB
CKPTC
DBWnD
LGWRE
PMONF
SMON
考题
单选题Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）A
DBWnB
RECOC
RVWRD
LGWR
考题
多选题Which two statements are true regarding the Oracle Data Pump export and import operations（）AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported.
考题
单选题As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?（）A
CKPTB
SMONC
MMOND
DBWR
考题
单选题You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A
RBALB
CKPTC
SMOND
PMONE
MMONF
CTWRG
DBWR
考题
单选题Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）A
CKPTB
SMONC
LGWRD
DBWnE
ARCn
考题
单选题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
考题
多选题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？（）Athe alert log fileBthe core dump filesCthe change tracking fileDthe user session trace filesEthe database audit trail filesFthe background process trace files
热门标签
最新试卷