niusouti.com

单选题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

相似考题

1.You executed the following commands in a database session:What could have caused the recycle bin to clean up?()A. There is demand for space from the new table从B. The undo tablespace does not have sufficient free spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free space

2. 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

3.An administrator has added a new hard drive to a server that is running out of space on its C Drive and is experiencing slow performance.  The administrator needs to free up space on the C Drive.Which of the following is the BEST action for the administrator to take to free up space on the drive？（）A、Move the page file to the new drive.B、Copy the system32 directory to the new drive.C、Convert the C drive to a basic disk.D、Setup a software RAID to mirror the C drive.

4.Evaluate the following command and its output:Which two statements correctly interpret the output?()A. FREE_SPACE indicates only the space that is currently unallocated.B. ALLOCATED_SPACE indicates only the space currently allocated and in use.C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

更多“单选题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”相关问题

  • 第1题：

    While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)

    • A、An entry is created in the alert log file and the database instance continues to function normally
    • B、The log switch hangs occur for transactions until free space is available in the flash recovery area
    • C、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
    • D、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

    正确答案:B,C

  • 第2题：

    You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

    • A、run a procedure to check the tablespace space usage
    • B、define the warning threshold for the tablespace at 75% in Database Control
    • C、create a trigger to be executed when tablespace space usage reaches 75%
    • D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
    • E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

    正确答案:B

  • 第3题：

    As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）

    • A、Coalesce the application tables at a regular interval.
    • B、Export and Import the application tables a regular interval.
    • C、Drop and recreate the application tables at a regular interval.
    • D、Move the application tables to a tablespace with less space usage.
    • E、Distribute the application tables across multiple tablespaces depending on usage.
    • F、Move the application tables to automatic segment space management tablespace.

    正确答案:F

  • 第4题：

    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）

    • A、System monitor （SMON）
    • B、Process monitor （PMON）
    • C、Memory manager process （MMAN）
    • D、Manageability Monitor process （MMON）

    正确答案:D

  • 第5题：

    By default, checkpoints happen at least as often as（）.

    • A、Redo log switches. 
    • B、UPDATE statements are issued against the database. 
    • C、The SYSTEM tablespace is accessed. 
    • D、SMON coalesces free space in a tablespase.

    正确答案:A

  • 第6题：

    You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

    • A、The database automatically determines the extent-sizing policy for the tablespace.
    • B、The segments are automatically shrunk when the contents are removed from them.
    • C、The allocation of extents within the tablespace is managed through the dictionary tables.
    • D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.
    • E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL

    正确答案:A,D

  • 第7题：

    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， 5
    • B、System Monitor Process （SMON）： 1， 4， 5
    • C、Process Monitor Process （PMON）： 4， 5， 6
    • D、Database Writer Process （DBWn）： 1， 3， 4

    正确答案:C

  • 第8题：

    单选题
    ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）
    A

    CKPT  DBWn  LGWR  PMON  SMON

    B

    ARCn  CKPT  DBWn  LGWR  SMON

    C

    CJQ0  CKPT  DBWn  LGWR  SMON

    D

    DBWn  LGWR  PMON  RECO  SMON

    E

    CKPT  DBWn  LMON  PMON  SMON


    正确答案： C
    解析： 暂无解析

  • 第9题：

    多选题
    You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）
    A

    The database automatically determines the extent-sizing policy for the tablespace.

    B

    The segments are automatically shrunk when the contents are removed from them.

    C

    The allocation of extents within the tablespace is managed through the dictionary tables.

    D

    The space utilization description of the data blocks in segments is recorded inbitmapblocks.

    E

    The space utilization description of the data blocks in segments is managed through free lists.MANUAL


    正确答案： E,C
    解析： 暂无解析

  • 第10题：

    单选题
    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， 5

    B

    System Monitor （SMON）： 1， 6

    C

    Process Monitor （PMON）： 4， 6， 7

    D

    Database Writer （DBWR）： 1， 3， 4


    正确答案： D
    解析： 系统监视器进程(SMON) 在实例启动时执行恢复（如果需要）。SMON 还负责清除不再使用的临时段。如果在实例恢复过程中由于文件读取或脱机错误跳过任何已终止的事务处理，则SMON 将在表空间或文件重新联机时恢复这些事务处理。SMON 定期检查以查看是否需要该进程。其它进程在检测到需要SMON 时也可以调用它。

  • 第11题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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，5

    B

    System Monitor Process （SMON）：1，4，5

    C

    Process Monitor Process （PMON）：4，5，6

    D

    Database Writer Process （DBWn）：1，3，4


    正确答案： D
    解析： 进程监视器进程(PMON) 在用户进程失败时执行进程恢复。PMON 负责清除数据库缓冲区高速缓存以及释放该用户进程使用的资源。例如，它重置活动事务处理表的状态，释放锁，并且从活动进程列表中删除该进程ID。PMON定期检查分派程序和服务器进程的状态，并重新启动任何已停止运行（但并非Oracle DB 故意终止）的分派程序和服务器进程。PMON 还将有关实例和分派程序进程的信息注册到网络监听程序。与SMON 一样，PMON 定期检查以查看是否需要执行；如果其它进程检测到需要该进程，也可以调用它。

  • 第13题：

    Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）

    • A、 FREE_SPACE indicates only the space that is currently unallocated.
    • B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.
    • C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.
    • D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
    • E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

    正确答案:D,E

  • 第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?（）

    • A、DBW0 
    • B、LGWR 
    • C、ARCH 
    • D、SMON 
    • E、PMON

    正确答案:D

  • 第15题：

    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，5
    • B、System Monitor Process （SMON）：1，4，5
    • C、Process Monitor Process （PMON）：4，5，6
    • D、Database Writer Process （DBWn）：1，3，4

    正确答案:C

  • 第16题：

    You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

    • A、The database automatically determines the extent-sizing policy for the tablespace.
    • B、The segments are automatically shrunk when the contents are removed from them.
    • C、The allocation of extents within the tablespace is managed through the dictionary tables.
    • D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
    • E、The space utilization description of the data blocks in segments is managed through free lists.

    正确答案:A,D

  • 第17题：

    Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）

    • A、No more data files can be added to the tablespace.
    • B、Segment space is managed by free lists in the tablespace.
    • C、A user created without being assigned a default tablespace uses this tablespace.
    • D、The tablespace can be dropped with the current setting with segments present in it

    正确答案:A,C

  • 第18题：

    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）

    • A、System monitor （SMON）
    • B、Process monitor （PMON）
    • C、Memory manager process （MMAN）
    • D、Manageability Monitor process （MMON）

    正确答案:D

  • 第19题：

    单选题
    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）
    A

    System monitor （SMON）

    B

    Process monitor （PMON）

    C

    Memory manager process （MMAN）

    D

    Manageability Monitor process （MMON）


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）
    A

    run a procedure to check the tablespace space usage

    B

    define the warning threshold for the tablespace at 75% in Database Control

    C

    create a trigger to be executed when tablespace space usage reaches 75%

    D

    submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals

    E

    define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command


    正确答案： B
    解析： 暂无解析

  • 第21题：

    多选题
    You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）
    A

    The database automatically determines the extent-sizing policy for the tablespace.

    B

    The segments are automatically shrunk when the contents are removed from them.

    C

    The allocation of extents within the tablespace is managed through the dictionary tables.

    D

    The space utilization description of the data blocks in segments is recorded in bitmap blocks.

    E

    The space utilization description of the data blocks in segments is managed through free lists.


    正确答案： A,E
    解析： 暂无解析

  • 第22题：

    单选题
    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， 5

    B

    System Monitor Process （SMON）： 1， 4， 5

    C

    Process Monitor Process （PMON）： 4， 5， 6

    D

    Database Writer Process （DBWn）： 1， 3， 4


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）
    A

    FREE_SPACE indicates only the space that is currently unallocated.

    B

    ALLOCATED_SPACE indicates only the space currently allocated and in use.

    C

    FREE_SPACE indicates only the space that is currently allocated and available for reuse.

    D

    ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.

    E

    FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    单选题
    You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）
    A

    System monitor （SMON）

    B

    Process monitor （PMON）

    C

    Memory manager process （MMAN）

    D

    Manageability Monitor process （MMON）


    正确答案： B
    解析： 可管理性监视器进程(MMON)，可执行各种与可管理性相关的后台任务，
    例如： 
    • 每当给定的度量超过其阈值时发出预警 
    • 通过衍生附加进程（MMON 从属进程）获取快照 
    • 捕获近期已做修改的SQL 对象的统计值

相关内容