网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）
A
ARCH
B
SMON
C
LGWR
D
SERVER
参考答案
参考解析
解析：
暂无解析
更多 “单选题Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）A ARCH B SMON C LGWRD SERVER” 相关考题
考题
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)
考题
Which three statements are true about memory buffer allocation by a MySQL Server?()
A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedB.Thread buffers are allocated when a client connects, and are freed when the client disconnectsC.Buffers that are needed for certain operation are allocated when the operation starts, and freed when it endsD.User buffers are allocated at server startup and freed when the user is droppedE.All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
考题
Note the functionalities of various background processes： 1：Perform recovery at instance startup. SMON 2：Free the resources used by a user process when it fails. PMON 3：Cleanup the database buffer cache when a process fails. PMON 4：Dynamically register database services with listeners. PMON 5：Monitor sessions for idle session timeout. PMON 6：Cleanup unused temporary segments. SMON 7：Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process（）A、Checkpoint （CKPT）： 1， 2， 5B、System Monitor （SMON）： 1， 6C、Process Monitor （PMON）： 4， 6， 7D、Database Writer （DBWR）： 1， 3， 4
考题
Upgrading which of the following components in a server has the GREATEST affect on virtualization？（）A、Amount of MemoryB、Number of HBAsC、Hard drive cache sizeD、ECC ability in memory
考题
Which is the correct description of a pinned buffer in the database buffer cache（）A、The buffer is currently being accessed.B、The buffer is empty and has not been used.C、The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D、The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
考题
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A、User processB、Server processC、System Monitor (SMON)D、Process Monitor (PMON)E、Checkpoint process (CKPT)
考题
Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A、The minimum memory size for the database buffer cache is set to 100 mb.B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
考题
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 three statements are true about memory buffer allocation by a MySQL Server?（）A、Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedB、Thread buffers are allocated when a client connects, and are freed when the client disconnectsC、Buffers that are needed for certain operation are allocated when the operation starts, and freed when it endsD、User buffers are allocated at server startup and freed when the user is droppedE、All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
考题
Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）A、ARCH B、SMON C、LGWRD、SERVER
考题
Records from the data dictionary information are stored in which of the following database memory areas?（）A、Library cache B、Row cache C、Session UGA D、Buffer cache
考题
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） writes
考题
Which background process reads the redo log buffer and writes it to a file？（）A、ARCnB、DBWnC、CKPTD、LGWRE、PMONF、SMON
考题
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 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 component of the SGA stores parsed SQL statements is used for process sharing?（）A、Buffer cache B、Redo log buffer C、Private SQL area D、Library cache E、Row cache
考题
单选题Which of the following is the GREATEST environmental concern for a server operating environment?（）A
TemperatureB
LightingC
Structural columnsD
Elevation
考题
多选题Which two statements about the background process of the database writer are true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes
考题
单选题Which component of the SGA stores parsed SQL statements is used for process sharing?（）A
Buffer cache B
Redo log buffer C
Private SQL area D
Library cache E
Row cache
考题
单选题Upgrading which of the following components in a server has the GREATEST affect on virtualization？（）A
Amount of MemoryB
Number of HBAsC
Hard drive cache sizeD
ECC ability in memory
考题
多选题Which three statements are true about memory buffer allocation by a MySQL Server?（）AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedBThread buffers are allocated when a client connects, and are freed when the client disconnectsCBuffers that are needed for certain operation are allocated when the operation starts, and freed when it endsDUser buffers are allocated at server startup and freed when the user is droppedEAll dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
考题
单选题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
考题
单选题Note the functionalities of various background processes： 1：Perform recovery at instance startup. SMON 2：Free the resources used by a user process when it fails. PMON 3：Cleanup the database buffer cache when a process fails. PMON 4：Dynamically register database services with listeners. PMON 5：Monitor sessions for idle session timeout. PMON 6：Cleanup unused temporary segments. SMON 7：Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process（）A
Checkpoint （CKPT）： 1， 2， 5B
System Monitor （SMON）： 1， 6C
Process Monitor （PMON）： 4， 6， 7D
Database Writer （DBWR）： 1， 3， 4
考题
单选题Which is the correct description of a pinned buffer in the database buffer cache（）A
The buffer is currently being accessed.B
The buffer is empty and has not been used.C
The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D
The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
考题
单选题Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A
The minimum memory size for the database buffer cache is set to 100 mb.B
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
考题
多选题Which two statements about the background process of thedatabase writerare true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
考题
单选题Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）A
User processB
Server processC
System Monitor （SMON）D
Process Monitor （PMON）E
Checkpoint process （CKPT）
热门标签
最新试卷
