单项选择题
You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）
A. restore the tablespace from the backup， and then perform an incomplete recovery
B. restore the tablespace from the backup， and then apply all the redo information
C. restore all the data files in the database， and then perform an incomplete recovery
D. restore the tablespace from the backup
相关考题
-
多项选择题
WhichtwostatementsregardingcompressedbackupsinRecoveryManager（RMAN）aretrue？（）
A. Backup compression is disabled by default.
B. Backup compression can be used with both backup sets and image copies.
C. Backup compression cannot be enabled using the CONFIGURE command.
D. Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
E. Backup compression applies to only backup sets.
F. Backup compression applies to only image copies. -
多项选择题
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？（）
A. the materialized views based on the TRANS table
B. the materialized views log of the TRANS table
C. the TRANS table
D. the B*Tree indexes on the TRANS table
E. the large object （LOB） segments of the TRANS table -
多项选择题
YourdatabaseoperatesinARCHIVELOGmodeandallthetablespacesareonline.Duetoausererror，youdecidedtoperformanincompleterecovery.Whichtwotaskswouldyouberequiredtoperformintherecoveryprocess？（）
A. open the database with the RESTRICTED option
B. open the database with the RESETLOGS option
C. recover to the required SCN only that data file in which the error occurred
D. recover all the data files to the same system change number （SCN）
