Another DBA issues a shutdown abort command on a database on

第1题：

第2题：

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.

第3题：

第4题：

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.

第5题：

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.

第6题：

第7题：

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

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

第8题：

第9题：

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、 TRANSACTIONAL
• B、 IMMEDIATE
• C、 ABORT
• D、 NORMAL

第10题：

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.