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
题目
when all the online redo log groups are multiplexed and one of the members of a group is missing
when all the online redo log groups are not multiplexed and one log group is missing
when all the control files are missing
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
第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
第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. 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
第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题：
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
第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