itgle.com

单选题Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）Aonly the control file， the current SPFILE， and data filesBon

题目
单选题
Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）
A

 only the control file， the current SPFILE， and data files

B

 only the current SPFILE and data files if autobackup is disabled

C

 only the data files and the archived redo logs

D

 the control file，current SPFILE file，data files，and archived redo logs

相似考题

1.Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED

2.In order to perform Flashback Transaction Query operations， which of these steps are required？（）A、 Ensure that database is running with version 10.1 compatibility.B、 Enable Flashback Logging.C、 Enable Supplemental Logging.D、 Ensure that the database is running with version 10.0 compatibility.E、 Ensure that the database is in ARCHIVELOG mode.

3.Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

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

参考答案和解析
正确答案： D
解析： 暂无解析
更多“Your database is running in ARCHIVELOG mode， and the databas”相关问题

  • 第1题：

    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

  • 第2题：

    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第3题：

    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

  • 第4题：

    Which is the correct command to put the database in ARCHIVELOG mode？（）  

    • A、 alter database archivelog
    • B、 alter system enable archivelog mode
    • C、 alter database enable archive
    • D、 alter database archivelog enable
    • E、 None of the above

    正确答案:A

  • 第5题：

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


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

  • 第6题：

    单选题
    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
    解析： 暂无解析

  • 第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.


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

  • 第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 execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG；  Where is the information that the database is now in ARCHIVELOG mode stored？（）
    A

    SPFILE

    B

    archive log

    C

    control file

    D

    system tablespace


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

  • 第10题：

    单选题
    Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）
    A

    Data files that belong to only the root container

    B

    Data files that belong to the root container and all the pluggable databases (PDBs)

    C

    Data files that belong to only the root container and PDB$SEED

    D

    Data files that belong to the root container and all the PDBs excluding PDB$SEED


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

  • 第11题：

    单选题
    Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）
    A

     only the control file， the current SPFILE， and data files

    B

     only the current SPFILE and data files if autobackup is disabled

    C

     only the data files and the archived redo logs

    D

     the control file，current SPFILE file，data files，and archived redo logs


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

  • 第12题：

    多选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第15题：

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

    • A、 backup database all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第16题：

    多选题
    In order to perform Flashback Transaction Query operations， which of these steps are required？（）
    A

    Ensure that database is running with version 10.1 compatibility.

    B

    Enable Flashback Logging.

    C

    Enable Supplemental Logging.

    D

    Ensure that the database is running with version 10.0 compatibility.

    E

    Ensure that the database is in ARCHIVELOG mode.


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

  • 第17题：

    单选题
    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


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

  • 第18题：

    单选题
    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
    A

     backup database all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


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

  • 第19题：

    多选题
    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）
    A

    The destination must be global only.

    B

    A maximum of five destinations can be assigned.

    C

    A maximum of ten different destinations can be assigned.

    D

    All the destinations are determined by the server automatically.

    E

    The destination may be local or remote for a Standby Database.

    F

    The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.


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

  • 第20题：

    多选题
    Which two statements are true regarding the database in ARCHIVELOG mode？（）
    A

    You have to shut down the database to perform the backups.

    B

    Archiving information is written to the data files and redo log files.

    C

    You can perform complete database backups without closing the database.

    D

    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

    E

    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.


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

  • 第21题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.


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

  • 第22题：

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


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

  • 第23题：

    单选题
    Which is the correct command to put the database in ARCHIVELOG mode？（）
    A

     alter database archivelog

    B

     alter system enable archivelog mode

    C

     alter database enable archive

    D

     alter database archivelog enable

    E

     None of the above


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

  • 第24题：

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


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

相关内容