违法和不良信息举报 联系客服
免费注册 登录

You have issued a SHUTDOWN ABORT command to bring down your 

题目
单选题
You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database：  1：SGA is allocated.  2：Control file is read.  3：Redo log files are read.  4：Instance recovery is started.  5：Background processes are started.  6：Data files are checked for consistency.  7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）
A

7，1，5，2，3，6，4

B

1，2，3，7，5，6，4

C

7，1，4，5，2，3，6

D

1，7，5，4，2，3，6

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

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

第3题：

When you see your untidy handwriting, you wish that you ___ everything down a bit more clearly.

A、wrote

B、had written

C、write

D、have written


正确答案:B

第4题：

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

第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.

正确答案:C

第6题：

You have just issued the command commit confirmed and your network continues to be operational with no further changes required. You issue a commit and-quit. A short time later, users start complaining about network problems. Which commands (in order) need to be entered to resolve this issue?（）

A.A

B.B

C.C

D.D


参考答案：B

第7题：

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

第8题：

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.


参考答案：B

第9题：

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.

正确答案:A

第10题：

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

  • A、You should perform a log switch
  • B、You should make a backup of the database
  • C、You should switch the database to the NONARCHIVELOG mode
  • D、You should shut down the database instance and perform a complete database recovery

正确答案:B

更多相关问题
相关内容