Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.
Oracle will automatically take the datafile out of hot backup mode and then open the database.
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.
The database will open with the file in hot backup mode. You can restart the backup at any time.
The datafile in hot backup mode will be corrupted and you will have to recover it.
第1题:
What are the consequences of executing the SHUTDOWN ABORT command? ()
第2题:
Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?()
第3题:
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?()
第4题:
假设用户正在执行UPDATE操作,此时用以下哪种方法可以关闭数据库()
第5题:
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()
第6题:
SHUTDOWN的()选项会等待用户完成他们没有提交的事务。
第7题:
The standby database is protected against write operations.
The primary database is protected against write operations.
The primary database is protected against data loss and data divergence.
The standby database is protected against data loss and data divergence.
第8题:
SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORT
SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONAL
SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATE
SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
第9题:
Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
The restore command will fail.
The recover command will fail.
The alter database open resetlogs command will fail.
All these commands will fail because they must be in the confines of a run block.
第10题:
If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.
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.
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.
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.
第11题:
ALTER USER
ALTER DATABASE
ALTER SYSTEM
GRANT
第12题:
TRANSACTIONAL
IMMEDIATE
ABORT
NORMAL
第13题:
SHUTDOWN的()选项在下次启动数据库时需要进行实例恢复。
第14题:
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?()
第15题:
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()
第16题:
What is the proper command to shut down the database in a consistent manner?()
第17题:
What happens if you shutdown abort ASM instance?()
第18题:
SHUTDOWN的()选项在下次启动数据库时需要进行数据库恢复。
第19题:
no privileges
only the SELECT privilege
only the CONNECT privilege
all the privileges of a default user
第20题:
shutdown abort
shutdown kill
Shutdown nowait
shutdown immediate
shutdown halt
第21题:
The RDBMSs connected will shutdown abort too
CLUSTER SERVICE will shutdown
ASM wil do instance recovery after startup
第22题:
The database files are synchronized.
Uncommitted changes are not rolled back.
The database is closed, but the instance is still started.
Database buffers and redo buffers are not written to the disk.
The database undergoes automatic media recovery during the next startup.
第23题:
The alter database archivelog command will fail
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode
The alter database archivelog command will succeed
The alter database archivelog command will ask if you want to make the database consistent first
There is no alter database archivelog command. The correct command is alter database alterlogging