ARCH
SMON
LGWR
SERVER
第1题:
Which is the correct description of a pinned buffer in the database buffer cache()
第2题:
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()
第3题:
Which three statements are true about memory buffer allocation by a MySQL Server?()
第4题:
Records from the data dictionary information are stored in which of the following database memory areas?()
第5题:
Which background process reads the redo log buffer and writes it to a file?()
第6题:
Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint?()
第7题:
Temperature
Lighting
Structural columns
Elevation
第8题:
Buffer cache
Redo log buffer
Private SQL area
Library cache
Row cache
第9题:
Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
Thread buffers are allocated when a client connects, and are freed when the client disconnects
Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
User buffers are allocated at server startup and freed when the user is dropped
All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed
第10题:
Checkpoint (CKPT): 1, 2, 5
System Monitor (SMON): 1, 6
Process Monitor (PMON): 4, 6, 7
Database Writer (DBWR): 1, 3, 4
第11题:
The minimum memory size for the database buffer cache is set to 100 mb.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
第12题:
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
第13题:
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?()
第14题:
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?()
第15题:
Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?()
第16题:
Which two statements about the background process of the database writer are true()
第17题:
Which two statements about the background process of thedatabase writerare true()
第18题:
Which component of the SGA stores parsed SQL statements is used for process sharing?()
第19题:
It is possible to have multiple database writers in an Oracle instance.
It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
It writes dirty buffers, if any, to data files whenever a transaction commits.
It writes dirty buffers, if any, to data files before the log writer (LGWR) writes
第20题:
Amount of Memory
Number of HBAs
Hard drive cache size
ECC ability in memory
第21题:
CKPT
SMON
LGWR
DBWn
ARCn
第22题:
The buffer is currently being accessed.
The buffer is empty and has not been used.
The contents of the buffer have changed and must be flushed to the disk by the DBWn process.
The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
第23题:
It is possible to have multiple database writers in an Oracle instance.
It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
It writes dirty buffers, if any, to data files whenever a transaction commits.
It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.