单选题Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）A You cannot perform the TSPITR with the constraints enabled.B You must perform the TSPITR recovery of both tablespaces for it to be successful.C You can perform TSPITR only on the USERS tablespace.D RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.E The TSPITR will only be successful if the constraint is enabled.
单选题
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true？（）
A
You cannot perform the TSPITR with the constraints enabled.
B
You must perform the TSPITR recovery of both tablespaces for it to be successful.
C
You can perform TSPITR only on the USERS tablespace.
D
RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
E
The TSPITR will only be successful if the constraint is enabled.
参考解析
解析：
暂无解析
相关考题：
When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）A、 The SYSTEM tablespace.B、 The UNDO tablespace.C、 All tablespaces with tables.D、 All tablespaces with indexes.E、 No tablespaces are automatically restored.
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）A、ONLINEB、REVERSEC、PARALLELD、COMPRESSE、NOLOGGINGF、COMPUTE STATISTICS
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the 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
What RMAN command is used to execute a tablespace point-in-time recovery？（）A、 recoverB、 duplicateC、 restoreD、 copyE、 None of the above
Which command is used to begin a tablespace point-in-time recovery？（） A、 Restore tablespaceB、 Recover tablespaceC、 Tablespace recoverD、 Recover to timeE、 recover datafile
Which of the following statement is incorrect regarding RMAN？（）A、It detects corrupt blocks.B、It performs only offline database backups.C、It omits empty blocks during backups.D、It performs tablespace point-in-time recovery （TSPITR）.
What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery？（） A、 TS_CHECKB、 TPITR_CHECKC、 TS_PITR_CHECKD、 CHECK_TSPITRE、 PITR_TS_CHECK
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）A、 ONLINEB、 REVERSEC、 PARALLELD、 COMPRESSE、 NOLOGGINGF、 COMPUTE STATISTICS
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）A、 The index tablespace contains bitmap indexes.B、 The index tablespace contains more than one data file.C、 The index tablespace supports only complete recovery.D、 The index tablespace is not a dictionary-managed tablespace.E、 There is a dependency relationship between a table and its indexes.
Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A、 An SCN is never used to perform a Flashback Table recovery.B、 If a significant number of changes have been made to the table， row movement must be enabled.C、 The tablespace must be offline before performing a Flashback Table recovery.D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
单选题Which of the following statements is true regarding implementing a Flashback Table recovery？ （）A An SCN is never used to perform a Flashback Table recovery.B If a significant number of changes have been made to the table， row movement must be enabled.C The tablespace must be offline before performing a Flashback Table recovery.D Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）A The index tablespace contains bitmap indexes.B The index tablespace contains more than one data file.C The index tablespace supports only complete recovery.D The index tablespace is not a dictionary-managed tablespace.E There is a dependency relationship between a table and its indexes.
单选题What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery？（）A TS_CHECKB TPITR_CHECKC TS_PITR_CHECKD CHECK_TSPITRE PITR_TS_CHECK
单选题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 noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?（）ANew channels for restore and recovery tasksBNew name for the data files of the tablespaceCAuxiliary name for the data files of the tablespaceDAuxiliary destinations for an auxiliary set of data files
单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）Aflash back the databaseBperform point-in-time recoveryCperform a full database recoveryDdrop and re-create the tablespaceEuse Recovery Manager （RMAN） to recover the database
单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）A New channels for restore and recovery tasksB New name for the data files of the tablespaceC Auxiliary name for the data files of the tablespaceD Auxiliary destinations for an auxiliary set of data files
多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
单选题Which of the following statement is incorrect regarding RMAN？（）AIt detects corrupt blocks.BIt performs only offline database backups.CIt omits empty blocks during backups.DIt performs tablespace point-in-time recovery （TSPITR）.
多选题When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）AThe SYSTEM tablespace.BThe UNDO tablespace.CAll tablespaces with tables.DAll tablespaces with indexes.ENo tablespaces are automatically restored.
单选题Which command is used to begin a tablespace point-in-time recovery？（）A Restore tablespaceB Recover tablespaceC Tablespace recoverD Recover to timeE recover datafile
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.
单选题What RMAN command is used to execute a tablespace point-in-time recovery？（）A recoverB duplicateC restoreD copyE None of the above