网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
SHUTDOWN的()选项在下次启动数据库时需要进行数据库恢复。
A.SHUTDOWN IMMEDIATEB.SHUTDOWN TRANSACTIONALC.SHUTDOWN NORMALD.SHUTDOWN ABORT
考题
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL shutdown immediate;What is the result of executing this command?（）A. The ASM instance is shut down, but the other instances are still running.B. It results in an error because other database instances are connected to it.C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
考题
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
考题
假设用户正在执行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 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.
考题
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.
考题
When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）A、 TRANSACTIONALB、 IMMEDIATEC、 ABORTD、 NORMAL
考题
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
考题
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A、The standby database is protected against write operations. B、The primary database is protected against write operations. C、The primary database is protected against data loss and data divergence. D、The standby database is protected against data loss and data divergence.
考题
假设用户正在执行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
考题
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user
考题
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
考题
SHUTDOWN的（）选项会等待用户完成他们没有提交的事务。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
考题
SHUTDOWN的（）选项在下次启动数据库时需要进行数据库恢复。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
考题
单选题What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A
The standby database is protected against write operations. B
The primary database is protected against write operations. C
The primary database is protected against data loss and data divergence. D
The standby database is protected against data loss and data divergence.
考题
单选题The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）A
no privilegesB
only the SELECT privilegeC
only the CONNECT privilegeD
all the privileges of a default user
考题
单选题假设用户正在执行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
考题
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A
Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B
The restore command will fail.C
The recover command will fail.D
The alter database open resetlogs command will fail.E
All these commands will fail because they must be in the confines of a run block.
考题
单选题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
考题
单选题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.
考题
多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not written to the disk.EThe database undergoes automatic media recovery during the next startup.
考题
单选题To allocate another role to a user, which command is most appropriate?（）A
ALTER USER B
ALTER DATABASE C
ALTER SYSTEM D
GRANT
考题
单选题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
考题
单选题When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）A
TRANSACTIONALB
IMMEDIATEC
ABORTD
NORMAL
热门标签
最新试卷
