niusouti.com

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY

题目

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）

  • A、 MMON
  • B、 LGWR
  • C、 ARCH
  • D、 ARWR
  • E、 COPY
相似考题

1.WhatOracleprocessrunswhenthedatabaseisinARCHIVELOGmodebutnotwhenitisinNOARCHIVELOGmode?()A.MMONB.LGWRC.ARCHD.ARWRE.COPY

2.Oracle数据库运行在（）模式时启用ARCH进程。A、PARALLEL ModeB、ARCHIVELOG ModeC、NOARCHIVELOG ModeD、RAC Mode

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

4.When performing recover of a database in NOARCHIVELOG mode with RMAN， the target database must be in the （） state to restore the control file.A、OPENB、IDLEC、MOUNTD、NOMOUNT

更多“What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY”相关问题

  • 第1题：

    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  

    • A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
    • B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
    • C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
    • D、 If you restart the database，the database will not be opened.

    正确答案:D

  • 第2题：

    You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

    • A、The backups would be consistent.
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure

    正确答案:B,C,E

  • 第3题：

    you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

    • A、 True
    • B、 False

    正确答案:B

  • 第4题：

    Which three actions are required to configure the Flashback Database? （）

    • A、set Flash Recovery Area
    • B、enable Flashback logging
    • C、create FLASHBACK tablespace
    • D、start the database in the ARCHIVELOG mode
    • E、start the database in the NOARCHIVELOG mode

    正确答案:A,B,D

  • 第5题：

    Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）

    • A、ARCHIVELOG mode.
    • B、NOARCHIVELOG mode.
    • C、Open database backups.
    • D、Consistent whole backups.

    正确答案:A,C

  • 第6题：

    In which of the following scenarios is a tablespace recovery required？（）

    • A、 when recovering a lost read-only tablespace from a read-only tablespace backup
    • B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
    • C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
    • D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

    正确答案:B

  • 第7题：

    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）

    • A、The backups would be consistent. 
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure.

    正确答案:B,C,E

  • 第8题：

    单选题
    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
    A

     Enable flashback logging.

    B

     Start the database in the ARCHIVELOG mode.

    C

     Issue the ALTER DATABASE FLASHBACK ON； command.

    D

     Set the FAST_START_MTTR_TARGET initialization parameter.


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

  • 第9题：

    多选题
    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）
    A

    The backups would be consistent.

    B

    The backups would be inconsistent.

    C

    The backups would be possible only if the database is running in ARCHIVELOG mode.

    D

    The backups would be possible only if the database is running in NOARCHIVELOG mode.

    E

    The backups need to be restored and the database has to be recovered in case of a media failure.


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

  • 第10题：

    多选题
    Which three actions are required to configure the Flashback Database？（）
    A

    set Flash Recovery Area

    B

    enable Flashback logging

    C

    create FLASHBACK tablespace

    D

    start the database in the ARCHIVELOG mode

    E

    start the database in the NOARCHIVELOG mode


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

  • 第11题：

    单选题
    you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）
    A

     True

    B

     False


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

  • 第12题：

    单选题
    If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）
    A

     The alter database archivelog command will fail

    B

     The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode

    C

     The alter database archivelog command will succeed

    D

     The alter database archivelog command will ask if you want to make the database consistent first

    E

     There is no alter database archivelog command. The correct command is alter database alterlogging


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

  • 第13题：

    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

    • A、 Enable flashback logging.
    • B、 Start the database in the ARCHIVELOG mode.
    • C、 Issue the ALTER DATABASE FLASHBACK ON； command.
    • D、 Set the FAST_START_MTTR_TARGET initialization parameter.

    正确答案:A

  • 第14题：

    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

    • A、 The database is in NOMOUNT state.
    • B、 The database is in NOARCHIVELOG mode and the tablespace is online.
    • C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
    • D、 The database is in ARCHIVELOG mode and the tablespace is offline.
    • E、 The database is in ARCHIVELOG mode and the tablespace is online.

    正确答案:C,D,E

  • 第15题：

    What are the different logging modes available in Oracle Database 11g？（） 

    • A、 NOLOG mode
    • B、 NOARCHIVELOG mode
    • C、 LOGGING mode
    • D、 HOTDATABASE mode
    • E、 ARCHIVELOG mode

    正确答案:B,E

  • 第16题：

    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

    • A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
    • B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.
    • C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
    • D、 The database will open with the file in hot backup mode. You can restart the backup at any time.
    • E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

    正确答案:C

  • 第17题：

    Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）

    • A、You can perform open database backups.
    • B、You can perform closed database backups.
    • C、You cannot perform schema-level logical backups.
    • D、You can perform the backup of only the SYSTEM tablespace when the database is open.

    正确答案:B

  • 第18题：

    Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）

    • A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 
    • B、 Datafiles are not written to during hot backups.
    • C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
    • D、 The datafile headers are not updated during the backup.
    • E、 The way data is written to the online redo logs is unchanged during the backup.

    正确答案:D

  • 第19题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
    A

    The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

    C

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

    D

    If you restart the database, the database will not be opened.


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

  • 第20题：

    单选题
    What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）
    A

     MMON

    B

     LGWR

    C

     ARCH

    D

     ARWR

    E

     COPY


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

  • 第21题：

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

    archival

    B

    log writer

    C

    database writer

    D

    system monitor

    E

    process monitor

    F

    change tracking writer


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

  • 第22题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第23题：

    单选题
    Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）
    A

     Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 

    B

     Datafiles are not written to during hot backups.

    C

     Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

    D

     The datafile headers are not updated during the backup.

    E

     The way data is written to the online redo logs is unchanged during the backup.


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

相关内容