单选题Which mode of database shutdown requires an instance recovery at the time of the next database startup?（）A ABORTB NORMALC IMMEDIATED TRANSACTIONAL

题目
单选题
Which mode of database shutdown requires an instance recovery at the time of the next database startup?（）
A

ABORT

B

NORMAL

C

IMMEDIATE

D

TRANSACTIONAL

相似考题

1.Which mode of database shutdown requires an instance recovery at the time of the next database startup?()A. ABORTB. NORMALC. IMMEDIATED. TRANSACTIONAL

2.You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

3.You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance recovery.B、On startup， CKPT coordinates instance recovery.C、On startup， use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup， perform media recovery and then instance recovery.F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

4.Youplantotakeacloseddatabasebackupusingoperatingsystemcommands.WhichthreeSHUTDOWNoptionsareappropriateforthistypeofbackup?()A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL

更多“单选题Which mode of database shutdown requires an instance recovery at the time of the next database startup?（）A ABORTB NORMALC IMMEDIATED TRANSACTIONAL”相关问题

  • 第1题：

    What are the consequences of executing the SHUTDOWN ABORT command？ （）

    • A、The database files are synchronized.
    • B、Uncommitted changes are not rolled back.
    • C、The database is closed， but the instance is still started.
    • D、Database buffers and redo buffers are not written to the disk.
    • E、The database undergoes automatic media recovery during the next startup.

    正确答案:B,D

  • 第2题：

    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）

    • A、The online redo log files and archived redo log files are required to accomplish the recovery.
    • B、The uncommitted transaction will be committed at the next startup of the database instance.
    • C、The uncommitted transaction is rolled back automatically at the next opening of the database.
    • D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

    正确答案:C

  • 第3题：

    Which mode of database shutdown requires an instance recovery at the time of the next database startup?（）

    • A、ABORT
    • B、NORMAL
    • C、IMMEDIATE
    • D、TRANSACTIONAL

    正确答案:A

  • 第4题：

    Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  

    • A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
    • B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
    • C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
    • D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

    正确答案:C

  • 第5题：

    You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup？（）

    • A、ABORT
    • B、NORMAL
    • C、IMMEDIATE
    • D、TRANSACTIONAL

    正确答案:B,C,D

  • 第6题：

    单选题
    Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）
    A

     If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.

    B

     If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.

    C

     If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.

    D

     If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.


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

  • 第7题：

    单选题
    ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction.


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

  • 第8题：

    单选题
    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）
    A

     The database will open，and the tablespace automatically comes out of the backup mode.

    B

     The database will be mounted，and recovery must be performed on the USERS tablespace.

    C

     The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.

    D

     The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.


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

  • 第9题：

    多选题
    What are the consequences of executing the SHUTDOWN ABORT command？ （）
    A

    The database files are synchronized.

    B

    Uncommitted changes are not rolled back.

    C

    The database is closed， but the instance is still started.

    D

    Database buffers and redo buffers are not written to the disk.

    E

    The database undergoes automatic media recovery during the next startup.


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

  • 第10题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
    A

     Enable the flash recovery area and specify it as the archived redo log destination.

    B

     Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

     Enable the flash recovery area but do not specify it as the archived redo log destination. 

    D

     Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.


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

  • 第11题：

    单选题
    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction


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

  • 第12题：

    多选题
    Which operation requires that you create an auxiliary instance manually before executing the operation？（）
    A

    Backup-based database duplication.

    B

    Active database duplication.

    C

    Tablespace point-in-time recovery.

    D

    No operation requires the creation of an auxiliary instance.


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

  • 第13题：

    在oracle数据库中，下列哪种方法关闭数据库后，在下次重启时需要进行恢复？（）

    • A、shutdown abort
    • B、shutdown normal
    • C、shutdown immediate
    • D、shutdown force

    正确答案:A

  • 第14题：

    To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  

    • A、 The database will open，and the tablespace automatically comes out of the backup mode.
    • B、 The database will be mounted，and recovery must be performed on the USERS tablespace.
    • C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
    • D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

    正确答案:C

  • 第15题：

    You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

    • A、Enable the flash recovery area and specify it as the archived redo log destination.
    • B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
    • C、Enable the flash recovery area but do not specify it as the archived redo log destination.
    • D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

    正确答案:A

  • 第16题：

    If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

    • A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
    • B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
    • C、 The next time you connect RMAN to just the recovery catalog
    • D、 The next time you connect to the recovery catalog and the target database with RMAN
    • E、 Connecting to the recovery catalog and issuing the resync all databases command

    正确答案:A,B

  • 第17题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第18题：

    单选题
    You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）
    A

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

    B

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    C

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    D

     Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.


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

  • 第19题：

    单选题
    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
    A

    The database will open, and the tablespace automatically comes out of the backup mode

    B

    The database will be mounted, and recovery must be performed on the USERS tablespace.

    C

    The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

    D

    The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.


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

  • 第20题：

    多选题
    You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）
    A

    On startup， SMON coordinates instance recovery.

    B

    On startup， CKPT coordinates instance recovery.

    C

    On startup， use RMAN to perform instance recovery.

    D

    Uncommitted changes will be rolled back after the database is opened.

    E

    On startup， perform media recovery and then instance recovery.

    F

    On startup， all the files will be synchronized and you get both committed and uncommitted data.


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

  • 第21题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）
    A

    Enable the flash recovery area and specify it as the archived redo log destination.

    B

    Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

    Enable the flash recovery area but do not specify it as the archived redo log destination.

    D

    Disable the flash recovery area and start the database instance in NOARCHIVELOG mode


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

  • 第22题：

    多选题
    If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）
    A

    The next time you back up the database when you are also connected to the recovery catalog and the target database

    B

    The next time you are connected to the target database and the recovery catalog database and issue the resync command

    C

    The next time you connect RMAN to just the recovery catalog

    D

    The next time you connect to the recovery catalog and the target database with RMAN

    E

    Connecting to the recovery catalog and issuing the resync all databases command


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

  • 第23题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal？（）
    A

    You should recreate the indexes. 

    B

    You should compress the log file backups 

    C

    You should make the Dworks database use the Full recovery mode 

    D

    You should make the Dworks database use the Simple recovery mode.


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

相关内容