单项选择题
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
A.restore the tablespace from the backup; there is no need to apply the redo information
B.restore the full database to recover the data up to the point when you performed the backup
C.restore the tablespace from the backup, and then perform a recovery using the backup control file
D.restore the tablespace from the backup, and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
相关考题
-
多项选择题
Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However,insteadofperformingamediarecovery,youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes?()
A.ONLINE
B.REVERSE
C.PARALLEL
D.COMPRESS
E.NOLOGGING
F.COMPUTE STATISTICS -
多项选择题
You lost the index tablespace in your database. You decided to recreate the index tablespace and the indexes in the tablespace. What methods can you use to recreate the indexes?()
A.Data Pump
B.SQL scripts
C.SQL*Loader
D.Flashback database
E.Recovery Manager (RMAN) script -
单项选择题
Youlosttheindextablespaceinyourdatabase.Youarenotabletousetablespacepointintimerecoveryontheindextablespace.Whatcouldbethereasonforthis?()
A.The index tablespace contains bitmap indexes.
B.The index tablespace contains more than one data file.
C.The index tablespace supports only complete recovery.
D.The index tablespace is not a dictionarymanaged tablespace.
E.There is a dependency relationship between a table and its indexes.
