Oracle
1Z0-034 · Question #88
1Z0-034 Question #88: Real Exam Question with Answer & Explanation
The correct answer is C. The database will be mounted, and data files in the USERS tablespace must be taken out of the. See the full explanation below for the reasoning.
Question
To accomplish user-managed backup for the USERS tabespace, you issued the following command to put the tablespace in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the userstablespace?
Options
- AThe database will open, and the tablespace automatically comes out of the backup mode.
- BThe database will be mounted, and recovery must be performed on the USERS tablespace.
- CThe database will be mounted, and data files in the USERS tablespace must be taken out of the
- DThe database will not be mounted, and you must restore all the data files for the USERS
Community Discussion
No community discussion yet for this question.