Ask a Question
Advertise on boostr.in
Question:The following SQL command was issued to perform an online backup of the USER_DATA tablespace: ALTER TABLESPACE user_data BEGIN BACKUP; Next, an operating system command was issued to back up user user01.dbf, the file that belongs to the USER_DATA tablespace. An instance failure was then experienced. Which of the following statements are true?
a. ¬†¬†¬†¬†¬†¬†¬†The user_data01.dbf file needs to be restored from an earlier backup and recovered
b. ¬†¬†¬†¬†¬†¬†¬†The online backup of the USER_DATA tablespace can be ended with an ALTER DATABASE command
c. ¬†¬†¬†¬†¬†¬†¬†The backup of user data01.bbf is unusable for future recoveries if the operating system copy was not completed before the instance failure
d. ¬†¬†¬†¬†¬†¬†¬†The user_data01.dbf file is corrupt because of the instance failure during the online backup of the data file
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please