网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 recovery
B
take data files from the readonly tablespace offline before performing a recovery
C
perform a recovery; status of the tablespace in control file will be changed automatically
D
recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
A: Which of these newspapers have you read?B: I’ve read _____them.A. bothB. both ofC. any of
考题
Do you have any suggestions about it?()A. No, I have no ideaB. Let me give you a handC. After I read it in detail, I will tell you my opinion
考题
--Remember the first time we met, John
--Exactly. You ______ in the library.A.were reading
B.had read
C.have read
D.read
考题
A:Do you have any suggestions about it? B:（）ANo, I have no ideaBLet me give you a handCAfter I read it in detail, will tell you my opinion
考题
To understand a word, you have to read all the letters in it; to understand a sentence you have to read all the words in it.（）A对B错
考题
To understand a word, you have to read all the letters in it; to understand a sentence you have to read all the words in it.（）
考题
A:Do you have any suggestions about it? B:（）A、No, I have no ideaB、Let me give you a handC、After I read it in detail, will tell you my opinion
考题
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
考题
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
考题
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
考题
判断题To understand a word, you have to read all the letters in it; to understand a sentence you have to read all the words in it.（）A
对B
错
考题
填空题If you have some basic knowledge of card catalogue and computer skills, you will be able to read a book for pleasure.____
考题
单选题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
考题
单选题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 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
考题
单选题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？（）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 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 have to read the manual carefully first, otherwise you ______ have difficulty using the cell phone.A
shouldB
willC
mightD
may
考题
单选题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.
考题
单选题If you read this book, you will have a better _____ of the causes of trouble.A
understandingB
learningC
knowledgeD
explanation
考题
问答题Suppose you begin reading a book on page h and end on page k . If the pages are numbered and read consecutively, then how many pages have you read?
考题
单选题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.
考题
单选题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？（）A
drop and recreate the readonly tablespacesB
rename the readonly data files to their correct file namesC
change the tablespace status from read/write to readonlyD
recreate the readonly tablespace because it is automatically removed
考题
单选题A:Do you have any suggestions about it? B:（）A
No, I have no ideaB
Let me give you a handC
After I read it in detail, will tell you my opinion
考题
多选题Which operations require undo data（）ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE
考题
单选题I hope you will read all the material before you make the final decision.A
will be readB
will have readC
will be readingD
would have read
热门标签
最新试卷
