Organizational Research By

Surprising Reserch Topic questions - 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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.