CMS专题
单选题In which situation are you NOT required to perform an incomplete recovery？（）Awhen all the control files are lostBwhen all the members of a redo log group are lostCwhen a table is dropped and purged from the Recycle BinDwhen a temporary file of the defa
题目
when all the control files are lost
when all the members of a redo log group are lost
when a table is dropped and purged from the Recycle Bin
when a temporary file of the default temporary tablespace is lost
相似问题和答案
第1题：
As an experienced technician, you are required to configure and verify SRM with SSO redundancy. In such a situation, you have to issue several commands in proper orders. Which of the following is correct?（）
A. show redundancy states, redundancy, mode sso
B. show redundancy states, mode sso, redundancy
C. redundancy, mode sso, show redundancy states
D. mode sso, redundancy, show redundancy states
第2题：
As a network administrator, you are required to configure a switch port for a private Virtual LAN. In such a situation, which three of the following connection modes will be available during the configuration process? （）(Choose three.)
- A、isolated mode
- B、modular mode
- C、community mode
- D、promiscuous mode
- E、non-isolated
- F、permanent
正确答案:A,C,D
第3题：
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
第4题：
Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）
- A、 The target database must be in NOARCHIVELOG mode.
- B、 No backup is required of the database before you perform a TSPITR.
- C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
- D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
- E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
正确答案:A,B
第5题：
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
- A、The online redo log files and archived redo log files are required to accomplish the recovery.
- B、The uncommitted transaction will be committed at the next startup of the database instance.
- C、The uncommitted transaction is rolled back automatically at the next opening of the database.
- D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
正确答案:C
第6题：
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
- A、 Only the Flashback Table
- B、 Both the Flashback Transaction Query and the Flashback Version Query
- C、 Only the Flashback Drop
- D、 Only the Flashback Version
正确答案:B
第7题：
As an experienced Network Engineer, you are required to characterize an existing CIS network. In such a situation, what is the last step to take?（）
- A、Perform a network audit.
- B、Form an impression about the network.
- C、Use traffic analysis to augment organizational input.
- D、Prepare and add to the network description.
正确答案:C
第8题：
As a network administrator, you are required to configure a switch port for a private Virtual LAN. In such a situation, which three of the following connection modes will be available during the configuration process? （）(Choose three.)
A. isolated mode
B. modular mode
C. community mode
D. promiscuous mode
E. non-isolated
F. permanent
第9题：
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
第10题：
In which scenario will you perform a user-managed incomplete recovery？（）
- A、 when a table is dropped and stored in the Recycle Bin
- B、when a table is dropped and purged from the Recycle Bin
- C、 when you are required to recover an existing table to its previous state
- D、 when you are required to view all the versions of a row of an existing table between a specific time period
正确答案:B