restore the tablespace from the backup; there is no need to apply the redo information
restore the full database to recover the data up to the point when you performed the backup
restore the tablespace from the backup, and then perform a recovery using the backup control file
restore the tablespace from the backup, and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
第1题:
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem? ()
第2题:
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?()
第3题:
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file()
第4题:
You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()
第5题:
You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider?()
第6题:
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()
第7题:
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file()
第8题:
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()
第9题:
Adam is working as a Database Administrator (DBA) for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup, he discovers that one of the disks crashed, resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details, he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure, what should Adam do to recover the USERS tablespace?()
第10题:
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()