（单选题）
Exhibit， One of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（） 
A You must recover all data files to the required system change number （SCN）.
B You must recover all data files， except those that are offline， to the required SCN.
C You must recover all data files belonging to the USERS tablespace to the required SCN.
D You cannot recover all data files because segment space management is performed manually for the undo tablespace.
正确答案
答案解析
略
相似试题
（单选题）
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces. What happens to the new DML operations in this scenario（）
（多选题）
Exhibit： View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace： SQL> ALTER TABLE trans SHRINK SPACE CASCADE； Which objects would be affected by this command？（）
（单选题）
View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement？（）
（单选题）
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）
（单选题）
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last onehour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed morethan one hour ago. The database has two more undo tablespaces. What happens to the new DML operations in this scenario（）
（单选题）
View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.
（单选题）
Exhibit： View the Exhibit.You have more than one table in the recycle bin having the same original name， DEPT2. You do not have any table with the nameDEPT2 in your schema. You executed the following command：PURGE TABLE dept2； Which statement is correct in this scenario？（）
（单选题）
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）
（单选题）
View the Exhibit and examine the characteristics of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find information about table fragmentation？（）
（单选题）
The database instance is currently using SPFILE. View the Exhibit and examine the error that you receivedwhile running the DB Structure Integrity check. Given below are the steps to recover from the error in randomorder： 1.Shut down the instance， if not already done. 2.Copy one of the remaining control files to a new location. 3.Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of thecontrol files. 4.Start up the database instance to the NOMOUNT stage. 5.Recover the database to the point of failure of the control file. 6.Open the database. Identify the correct sequence of steps（）
