CMS专题

单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）Awhen all the online redo log groups are multiplexed and one of the members of a group is missingBwhen all the online redo log groups are not multiplexed and

题目
单选题
In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）
A

 when all the online redo log groups are multiplexed and one of the members of a group is missing

B

 when all the online redo log groups are not multiplexed and one log group is missing

C

 when all the control files are missing

D

 when some important tables are deleted from the database and purged from the Recycle Bin

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

第1题：

Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）

A. It contains data till the last backup

B. It contains all data from target database until the current time

C. It contains all data from only the committed transactions in the target database

D. It contains all data except that which is used by the transactions in the current online redo file of target database


参考答案：D

第2题：

An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）

  • A、odmget
  • B、odmadd
  • C、odmshow
  • D、odmcreate

正确答案:A

第3题：

Which of the following is not responsibility of DBA(Data Base Administrator)?

A．Database management system design

B．Database schema definition

C．Database schema modification

D．Integrity constraint specification


正确答案：A

第4题：

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）

  • A、The operation would fail if tbs_1 were a read-only tablespace.
  • B、The operation would fail if tbs_1 were a read/write tablespace.
  • C、The operation would fail if tbs_1 were the default tablespace for the database.
  • D、If the above operation were successful， media recovery would be required to bring the tablespace online.
  • E、If the above operation were successful， instance recovery would be required to bring the tablespace online.

正确答案:D

第5题：

A route-based VPN is required for which scenario？（）

  • A、when the remote VPN peer is behind a NAT device
  • B、when multiple networks need to be reached across the tunnel and GRE cannot be used
  • C、when the remote VPN peer is a dialup or remote access client
  • D、when a dynamic routing protocol is required across the VPN and GRE cannot be used

正确答案:D

第6题：

A route－based VPN is required for which scenario? ()

A. when the remote VPN peer is behind a NAT device

B. when multiple networks need to be reached across the tunnel

C. when the remote VPN peer is a dialup or remote access client

D. when a dynamic routing protocol such as OSPF is required across the VPN


参考答案：D

第7题：

An administrator is setting up a security camera that will send the same feed to twelve of the twenty workstations on the network. Which of the following addressing schemes was designed for this scenario?（）

  • A、Multicast
  • B、Unicast
  • C、Broadcast
  • D、Peer-to-peer

正确答案:A

第8题：

Which three actions are required to configure the Flashback Database? ()

A. set Flash Recovery Area

B. enable Flashback logging

C. create FLASHBACK tablespace

D. start the database in the ARCHIVELOG mode

E. start the database in the NOARCHIVELOG mode


参考答案：A, B, D

第9题：

You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

  • A、The instance would hang.
  • B、The instance needs to be shut down.
  • C、The instance would be in the open state.
  • D、The instance would abort in such cases.
  • E、The instance would be in the open and invalid state.
  • F、The instance would in the open state， but all the background processes will be restarted.

正确答案:D

第10题：

In which scenario will you perform a cancel-based recovery？（）

  • A、 when a tablespace is dropped and you have only RMAN-based backup of the database
  • B、 when a table is dropped and stored in the Recycle Bin
  • C、 when you are required to recover an existing table to its previous state
  • D、 when a tablespace is dropped and you have only a user-managed full backup of the database

正确答案:D

更多相关问题
相关内容