Organizational Research By

Surprising Reserch Topic

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
41 views



Related Hot Questions



Government Jobs Opening


...