You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45, which is needed to perform complete recovery, is invalid. You then begin incomplete recovery-You receive this prompt: ORA-00279:change 309012...03/09/01 11:33:56 needed for thread ORA-00289: suggestion : /disk1/archive/arch_45.rdo ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log: {=suggested | filename | AUTO | CANCEL} What is the correct response?()
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?()
You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation?()