网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
ARCn
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A PMONB SMONC CKPTD LGWRE ARCn” 相关考题
考题
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
考题
WhichOraclebackgroundprocessfreesSGAresourcesthatwereallocatedtoauserprocessthatfailed?()
A.PMONB.SMONC.CKPTD.LGWRE.ARCn
考题
Oracle Instance由哪两个部分组成?()
A. Shared pool和Server processB. Shared pool和Background processC. SGA和user processD. PGA和user processE. SGA和Background process
考题
Oracle Server由哪两个部分组成?()
A. INSTANCE和DATABASEB. SGA和PGAC. SGA和DATABASED. Server process和Background processE. SGA和Background process
考题
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）A、PMONB、SMONC、LGWRD、CKRT
考题
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
考题
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.
考题
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
考题
Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）A、PMONB、SMONC、CKPTD、LGWRE、ARCn
考题
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 does Automatic Shared Memory Management use to coordinate the sizing of memory components？（）A、PMONB、SMONC、MMNLD、MMANE、MMON
考题
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（） A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
考题
Note the following functionalities of various background processes： 1：Record the checkpoint information in data file headers. CKPT 2：Perform recovery at instance startup. SMON 3：Cleanup unused temporary segments. SMON 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
考题
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 reads the redo log buffer and writes it to a file？（）A、ARCnB、DBWnC、CKPTD、LGWRE、PMONF、SMON
考题
Oracle Instance由哪两个部分组成？（）A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process
考题
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
考题
单选题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
考题
单选题Oracle Instance由哪两个部分组成？（）A
Shared pool和Server processB
Shared pool和Background processC
SGA和user processD
PGA和user processE
SGA和Background process
考题
单选题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
考题
单选题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（）A
Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B
Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C
Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D
Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
考题
单选题Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）A
PMONB
SMONC
LGWRD
CKRT
考题
单选题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
考题
单选题Oracle Server由哪两个部分组成？（）A
INSTANCE和DATABASEB
SGA和PGAC
SGA和DATABASED
Server process和Background processE
SGA和Background process
考题
单选题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.
考题
单选题Note the following functionalities of various background processes： 1：Record the checkpoint information in data file headers. CKPT 2：Perform recovery at instance startup. SMON 3：Cleanup unused temporary segments. SMON 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
热门标签
最新试卷