单选题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？（）AThe alter database archivelog command will failBThe alter database archivelo

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

相似考题

1.SHUTDOWN的()选项在下次启动数据库时需要进行数据库恢复。A.SHUTDOWN IMMEDIATEB.SHUTDOWN TRANSACTIONALC.SHUTDOWN NORMALD.SHUTDOWN ABORT

2.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?()A. Issue the ALTER DISKGROUP ... ADD DISK command.B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D. Retrieve the disk from the Recycle Bin after the operation completes

3.假设用户正在执行UPDATE操作,此时用以下哪种方法可以关闭数据库()A.SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORTB.SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONALC.SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATED.SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONALE.SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL

4.What happens if you shutdown abort ASM instance?()A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance recovery after startup

更多“If you issue the command shutdown abort prior to trying to p”相关问题

  • 第1题：

    While logged into a router you manually shut down the serial 0 interface using the "shutdown" interface configuration command. You then issue the "show interface serial 0" command in exec mode. What could you expect the status of the serial 0 interface to be?（）

    • A、Serial 0 is up, line protocol is up
    • B、Serial 0 is up, line protocol is down
    • C、Serial 0 is down, line protocol is down
    • D、Serial 0 is down, line protocol is up
    • E、Serial 0 is administratively down, line protocol is down
    • F、Serial 0 is administratively down, line protocol is up

    正确答案:E

  • 第2题：

    SHUTDOWN的（）选项在下次启动数据库时需要进行实例恢复。

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

    正确答案:D

  • 第3题：

    假设用户正在执行UPDATE操作，此时用以下哪种方法可以关闭数据库（）

    • A、SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORT
    • B、SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONAL
    • C、SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATE
    • D、SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
    • E、SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL

    正确答案:A

  • 第4题：

    You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

    • A、 Start the database in the MOUNT stage.
    • B、 Back up the control file to trace.
    • C、 Set the DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第5题：

    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）  

    • A、 Issue the ALTER DISKGROUP ... ADD DISK command.
    • B、 Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
    • C、 Issue the ALTER DISKGROU
    • D、 Retrieve the disk from the Recycle Bin after the operation completes.

    正确答案:A

  • 第6题：

    SHUTDOWN的（）选项在下次启动数据库时需要进行数据库恢复。

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

    正确答案:D

  • 第7题：

    单选题
    You enter configuration mode with the configure command. You need to abort the changes that you have made and start again with a fresh copy of the active configuration. Which command should you use?（）
    A

    rollback 0

    B

    load active

    C

    reset config

    D

    clear candidate config


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

  • 第8题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）
    A

     Issue the ALTER DISKGROUP ... ADD DISK command.

    B

     Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.

    C

     Issue the ALTER DISKGROU

    D

     Retrieve the disk from the Recycle Bin after the operation completes.


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

  • 第9题：

    单选题
    While logged into a router you manually shut down the serial 0 interface using the "shutdown" interface configuration command. You then issue the "show interface serial 0" command in exec mode. What could you expect the status of the serial 0 interface to be?（）
    A

    Serial 0 is up, line protocol is up

    B

    Serial 0 is up, line protocol is down

    C

    Serial 0 is down, line protocol is down

    D

    Serial 0 is down, line protocol is up

    E

    Serial 0 is administratively down, line protocol is down

    F

    Serial 0 is administratively down, line protocol is up


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

  • 第10题：

    单选题
    You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）
    A

     Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

    B

     Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

    C

     Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

    D

     Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

    E

     Issue the restore spfile from autobackup command from the RMAN prompt.


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

  • 第11题：

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

  • 第12题：

    单选题
    What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；
    A

     The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.

    B

     The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

    C

     The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.

    D

     This command will fail because you cannot drop a specific disk in an ASM disk group.

    E

     The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.


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

  • 第13题：

    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）

    • A、Issue the ALTER DISKGROUP ... ADD DISK command.
    • B、Issue the ALTER DISKGROUP ... UNDROP DISKS command.
    • C、Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
    • D、Retrieve the disk from the Recycle Bin after the operation completes

    正确答案:A

  • 第14题：

    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

  • 第15题：

    What is the proper command to shut down the database in a consistent manner?（）

    • A、shutdown abort 
    • B、shutdown kill 
    • C、Shutdown nowait 
    • D、shutdown immediate
    • E、shutdown halt

    正确答案:D

  • 第16题：

    What happens if you shutdown abort ASM instance?（）

    • A、The RDBMSs connected will shutdown abort too
    • B、CLUSTER SERVICE will shutdown
    • C、ASM wil do instance recovery after startup

    正确答案:A

  • 第17题：

    SHUTDOWN的（）选项会等待用户完成他们没有提交的事务。

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

    正确答案:B

  • 第18题：

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

  • 第19题：

    单选题
    假设用户正在执行UPDATE操作，此时用以下哪种方法可以关闭数据库（）
    A

    SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORT

    B

    SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONAL

    C

    SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATE

    D

    SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL

    E

    SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL


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

  • 第20题：

    单选题
    You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL> shutdown immediate; What is the result of executing this command?（）
    A

    All the instances, including the ASM instance, are shut down in the ABORT mode

    B

    The ASM instance is shut down, but the other instances are still running 

    C

    The ASM instance is still functional, but the other instances are shut down 

    D

    All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. 

    E

    HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode 

    F

    HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode


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

  • 第21题：

    单选题
    If you（）a conflict prior to the meeting, discuss the issue with participants in advance.
    A

    anticipate

    B

    participate

    C

    preserve

    D

    announce


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

  • 第22题：

    单选题
    What happens if you shutdown abort ASM instance?（）
    A

    The RDBMSs connected will shutdown abort too

    B

    CLUSTER SERVICE will shutdown

    C

    ASM wil do instance recovery after startup


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

  • 第23题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed？（）
    A

     Issue the ALTER DISKGROUP ... ADD DISK command.

    B

     Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

     Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

     Retrieve the disk from the Recycle Bin after the operation completes.


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

相关内容