网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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” 相关考题
考题
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
考题
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A、Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B、Increase the database buffer cache size.C、Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D、Configure Automata Shared Memory Management.E、Configure Automatic Memory Management
考题
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.
考题
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
考题
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
考题
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）A、Library cache B、Row cacheC、Dictionary cache D、Large area E、Buffer cache
考题
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 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
考题
单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B
Increase the database buffer cache size.C
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D
Configure Automata Shared Memory Management.E
Configure Automatic Memory Management
考题
单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题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.
考题
多选题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.
考题
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）A
Because 4194304 is the granule sizeB
Because 4194304 is the standard block sizeC
Because 4194304 is the largest nonstandard block size defined in the databaseD
Because 4194304 is the total size of data already available in the database buffer cache
考题
单选题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
多选题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
考题
多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）AThe size of the shared pool is too small.BCursors are not being shared.CA large number COMMITS are being performed.DThere are frequent logons and logoffs.EThe buffers are being read into the buffer cache, but some other session is changing the buffers.
考题
多选题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
考题
单选题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 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
考题
单选题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
考题
单选题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
考题
单选题Before the sludge in a purifier is ejected,（）A
the oil feeding is stopped and replaced by admitting flushing waterB
the flushing water feeding is stopped and replaced by admitting oilC
the feeding of dirty oil and flushing water is stoppedD
the feeding of dirty oil and flushing water is admitted
热门标签
最新试卷