問題文
An operator deleted the rows of one table by mistake and committed the change ten minutes ago. The rest of the database is healthy and busy. Which statement describes the recovery technology that suits this failure?
選択肢
- A technology that reads the past image of that table alone is used, because the failure touched one object while every other file and every other transaction in the database remained correct at the time of the deletion.
- A technology that recreates the database from the parameter file is used, because the failure changed the contents of one object and the structure has to be rebuilt before the rows can be loaded again.
- A technology that restores the data files of that tablespace from backup is used, because the failure touched one object and the file that holds it has to be brought back to the state before the deletion.
- A technology that applies crash recovery at the next startup is used, because the failure left uncommitted changes in the online logs that have to be rolled back before the table can be read again.