单选题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 failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging
单选题
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
参考解析
解析:
暂无解析
相关考题:
SHUTDOWN的()选项在下次启动数据库时需要进行数据库恢复。 A.SHUTDOWN IMMEDIATEB.SHUTDOWN TRANSACTIONALC.SHUTDOWN NORMALD.SHUTDOWN ABORT
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
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
假设用户正在执行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
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 upB、Serial 0 is up, line protocol is downC、Serial 0 is down, line protocol is downD、Serial 0 is down, line protocol is upE、Serial 0 is administratively down, line protocol is downF、Serial 0 is administratively down, line protocol is up
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
SHUTDOWN的()选项在下次启动数据库时需要进行实例恢复。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
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.
假设用户正在执行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
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 immediateE、shutdown halt
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: RMANBACKUP 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 DBIDD、 Issue the RECOVER DATABASE command.
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
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 DISKGROUD、 Retrieve the disk from the Recycle Bin after the operation completes.
SHUTDOWN的()选项会等待用户完成他们没有提交的事务。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
SHUTDOWN的()选项在下次启动数据库时需要进行数据库恢复。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
单选题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.
单选题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?()Arollback 0Bload activeCreset configDclear candidate config
单选题假设用户正在执行UPDATE操作,此时用以下哪种方法可以关闭数据库()ASHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORTBSHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONALCSHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATEDSHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONALESHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
单选题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 DISKGROUD Retrieve the disk from the Recycle Bin after the operation completes.
单选题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?()AAll the instances, including the ASM instance, are shut down in the ABORT modeBThe ASM instance is shut down, but the other instances are still running CThe ASM instance is still functional, but the other instances are shut down DAll the instances, including the ASM instance, are shut down in the IMMEDIATE mode. EHRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode FHRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
单选题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?()ASerial 0 is up, line protocol is upBSerial 0 is up, line protocol is downCSerial 0 is down, line protocol is downDSerial 0 is down, line protocol is upESerial 0 is administratively down, line protocol is downFSerial 0 is administratively down, line protocol is up
单选题If you()a conflict prior to the meeting, discuss the issue with participants in advance.AanticipateBparticipateCpreserveDannounce
单选题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.
单选题What happens if you shutdown abort ASM instance?()AThe RDBMSs connected will shutdown abort tooBCLUSTER SERVICE will shutdownCASM wil do instance recovery after startup
单选题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.
单选题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.
单选题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.
单选题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 failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging