单项选择题
A.drop the readonly tablespace and recreate the tablespace after recovery
B.take data files from the readonly tablespace offline before performing a recovery
C.perform a recovery; status of the tablespace in control file will be changed automatically
D.recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
单项选择题 One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()
单项选择题 YoulostthePRODSTDtablespace,whichwasread/write.Thetablespacewasreadonlywhenthelastbackupwasperformed.Howwouldyourecoverthetablespace?()
多项选择题 Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However,insteadofperformingamediarecovery,youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes?()