网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
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.
参考答案
参考解析
解析:
暂无解析
更多 “多选题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.” 相关考题
考题
When performing password recovery, which command should be entered at the boot prompt?()
A.boot -sB.boot -rC.boot singleD.boot recovery
考题
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
考题
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
考题
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.
考题
In which situation would you use the Oracle Shared Server configuration?()A、when performing export and import using Oracle Data PumpB、when performing backup and recovery operations using Oracle Recovery ManagerC、when performing batch processing and bulk loading operation in a data warehouse environment D、in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time
考题
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
考题
单选题When performing password recovery, which command should be entered at the boot prompt?()A
boot -sB
boot -rC
boot singleD
boot recovery
考题
单选题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?()A
drop the readonly tablespace and recreate the tablespace after recoveryB
take data files from the readonly tablespace offline before performing a recoveryC
perform a recovery; status of the tablespace in control file will be changed automaticallyD
recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open 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
考题
单选题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
考题
单选题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
考题
单选题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.
考题
单选题Which command is used to begin a tablespace point-in-time recovery?()A
Restore tablespaceB
Recover tablespaceC
Tablespace recoverD
Recover to timeE
recover datafile
考题
单选题What RMAN command is used to execute a tablespace point-in-time recovery?()A
recoverB
duplicateC
restoreD
copyE
None of the above
热门标签
最新试卷