单选题You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()A restore the tablespace from the backup; there is no need to apply the redo informationB restore the full database to recover the data up to the point when you performed the backupC restore the tablespace from the backup and then perform a recovery using the backup control fileD 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

单选题
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()
A

 restore the tablespace from the backup; there is no need to apply the redo information

B

 restore the full database to recover the data up to the point when you performed the backup

C

 restore the tablespace from the backup and then perform a recovery using the backup control file

D

 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


参考解析

解析: 暂无解析

相关考题:

At database startup, you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes?()A、 Start the database in OPEN mode, and create a new index tablespace.B、 Start the database in OPEN mode, and drop the lost index tablespace from the database.C、Start the database in MOUNT mode, create a new index tablespace, and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode, drop the lost index tablespace from the database, open the database, and create a new index tablespace.

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data?()  A、 Complete Recovery with online redo logB、 Complete Recovery with archived redo logC、 Tablespace Point-in-Time Recovery (TSPITR)D、 Incomplete Recovery with system change number (SCN)

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? ()A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario? ()A、The operation would fail if tbs_1 were a read-only tablespace.B、The operation would fail if tbs_1 were a read/write tablespace.C、The operation would fail if tbs_1 were the default tablespace for the database.D、If the above operation were successful, media recovery would be required to bring the tablespace online.E、If the above operation were successful, instance recovery would be required to bring the tablespace online.

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()A、 SQL scriptsB、 Recovery Manager (RMAN) scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database

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?()A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery; status of the tablespace in control file will be changed automatically

You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes?()A、Data PumpB、SQL scriptsC、SQL*LoaderD、Flashback databaseE、Recovery Manager (RMAN) script

Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true?()A、The database remains open.B、The database gets dismounted.C、The database becomes read only.D、The database instance gets aborted.E、The database gets shut down automatically.F、The status of the database depends on the status of the USERS tablespace.

Your database contains a temporary tablespace, index tablespace, undo tablespace, and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces, which tablespace is NOT required for the database to start?()A、 undo tablespaceB、 index tablespaceC、 read-only tablespaceD、 temporary tablespace

When performing an incomplete recover of the whole database, which data files must you restore? ()A、Only the damaged or lost data files.B、All of the data files of the database.C、Only the data files belonging to the SYSTEM tablespace.D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

In which of the following scenarios is a tablespace recovery required?()A、 when recovering a lost read-only tablespace from a read-only tablespace backupB、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG modeC、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenD、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only

In which situation are you NOT required to perform an incomplete recovery?()A、 when all the control files are lostB、 when all the members of a redo log group are lostC、 when a table is dropped and purged from the Recycle BinD、 when a temporary file of the default temporary tablespace is lost

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()A、 You find that one of the redo log members in each redo log group is lost.B、 You find that a data file that belongs to the USERS tablespace is damaged.C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.D、 You find that the current redo log group is damaged and is not available for recovery.E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.

单选题You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?()A restore the tablespace from the backup, and then perform an incomplete recoveryB restore the tablespace from the backup, and then apply all the redo informationC restore all the data files in the database, and then perform an incomplete recoveryD restore the tablespace from the backup

单选题Your database contains a temporary tablespace, index tablespace, undo tablespace, and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces, which tablespace is NOT required for the database to start?()A undo tablespaceB index tablespaceC read-only tablespaceD temporary tablespace

单选题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?()A take data files from the read-only tablespace offline before performing a recoveryB recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the databaseC drop the read-only tablespace and re-create the tablespace after recoveryD perform a recovery; status of the tablespace in control file will be changed automatically

单选题When performing an incomplete recover of the whole database, which data files must you restore? ()AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.

单选题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?()A drop and re-create the read-only tablespacesB rename the read-only data files to their correct file namesC change the tablespace status from read/write to read-onlyD re-create the read-only tablespace because it is automatically removed

单选题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?()Arestore the tablespace from the backup; there is no need to apply the redo information Brestore the full database to recover the data up to the point when you performed the backup Crestore the tablespace from the backup, and then perform a recovery using the backup control fileDrestore 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

多选题You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes?()AData PumpBSQL scriptsCSQL*LoaderDFlashback databaseERecovery Manager (RMAN) script

单选题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?()A The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.

单选题Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the database is true?()AThe database remains open.BThe database gets dismounted.CThe database becomes read only.DThe database instance gets aborted.EThe database gets shut down automatically.FThe status of the database depends on the status of the USERS tablespace.

多选题You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()ASQL scriptsBRecovery Manager (RMAN) scriptCData PumpDSQL*LoaderEFlashback database

单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data?()A Complete Recovery with online redo logB Complete Recovery with archived redo logC Tablespace Point-in-Time Recovery (TSPITR)D Incomplete Recovery with system change number (SCN)

单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure, you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time?()A Restore all the datafiles from the backup.B Restore only the lost datafile from the backup.C Restore all the datafiles for the lost tablespace from the backup.D Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.

多选题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? ()ARestore the lost data file from the backup, and then flash back the database.BRestore the data file pertaining to index tablespace, and then recover the tablespace.CRestore all the data files, and then perform an incomplete recovery to get the tablespace back.DRestore all the data files, and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.

单选题One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database?()Adrop and re­create the read­only tablespacesBrename the read­only data files to their correct file namesCchange the tablespace status from read/write to read­onlyDre­create the read­only tablespace because it is automatically removed