单选题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 

题目
单选题
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 read­only tablespace and re­create the tablespace after recovery

B

take data files from the read­only 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

相似考题

1.A: Which of these newspapers have you read?B: I’ve read _____them.A. bothB. both ofC. any of

2.--Remember the first time we met, John --Exactly. You ______ in the library.A.were reading B.had read C.have read D.read

3.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

4.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

参考答案和解析
正确答案： B
解析： 暂无解析
更多“You have a read/x7fonly tablespace on read/x7fonly media. Yo”相关问题

  • 第1题：

    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错


    错
    略

  • 第2题：

    A:Do you have any suggestions about it? B:（）

    • A、No, I have no idea
    • B、Let me give you a hand
    • C、After I read it in detail, will tell you my opinion

    正确答案:C

  • 第3题：

    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 tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第4题：

    判断题
    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

    错


    正确答案： 错
    解析： 暂无解析

  • 第5题：

    填空题
    If you have some basic knowledge of card catalogue and computer skills, you will be able to read a book for pleasure.____

    正确答案： D
    解析：
    由题干中“card catalogue and computer skills”提示可定位至D段首句。本句讲到，如果你到图书馆为了娱乐而读书（read a book for pleasure），只要知道基本的卡片目录和计算机技术，就可以应付了；但要找一些特定的信息的话，那就不足够了。故匹配段落为D段。

  • 第6题：

    单选题
    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 recovery

    B

     recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

    C

     drop the read-only tablespace and re-create the tablespace after recovery

    D

     perform a recovery； status of the tablespace in control file will be changed automatically


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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 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


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    问答题
    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?

    正确答案： k-h+1
    解析：
    从h页到k页一共是k-h页，但不要忘了加上一页，就是k-h+1页。

  • 第11题：

    单选题
    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 re­create the read­only tablespaces

    B

    rename the read­only data files to their correct file names

    C

    change the tablespace status from read/write to read­only

    D

    re­create the read­only tablespace because it is automatically removed


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    Which operations require undo data（）
    A

    Committing a transaction

    B

    Flashing back a transaction

    C

    Recovering a failed transaction

    D

    Running a read-consistent query

    E

    Changing a tablespace status from READ ONLY to READ WRITE


    正确答案： D,A
    解析： 暂无解析

  • 第13题：

    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.（）


    正确答案:错误

  • 第14题：

    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 recovery
    • B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
    • C、 drop the read-only tablespace and re-create the tablespace after recovery
    • D、 perform a recovery； status of the tablespace in control file will be changed automatically

    正确答案:A

  • 第15题：

    In which of the following scenarios is a tablespace recovery required？（）

    • A、 when recovering a lost read-only tablespace from a read-only tablespace backup
    • B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
    • C、 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 overwritten
    • D、 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

    正确答案:B

  • 第16题：

    问答题
    If you think that you can't have a good time without spending a lot of money, read on.

    正确答案：
    解析：

  • 第17题：

    单选题
    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 recovery

    B

     restore the tablespace from the backup， and then apply all the redo information

    C

     restore all the data files in the database， and then perform an incomplete recovery

    D

     restore the tablespace from the backup


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    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 read­only tablespace and re­create the tablespace after recovery

    B

    take data files from the read­only 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


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    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 tablespaces

    B

     rename the read-only data files to their correct file names

    C

     change the tablespace status from read/write to read-only

    D

     re-create the read-only tablespace because it is automatically removed


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    You have to read the manual carefully first, otherwise you ______ have difficulty using the cell phone.
    A

    should

    B

    will

    C

    might

    D

    may


    正确答案： A
    解析：
    should 作为情态动词，可以用来表示有较大可能实现的猜测、推论，通常译为“可能”、“总该…吧”，相当于 be expected to。

  • 第21题：

    单选题
    If you read this book, you will have a better _____ of the causes of trouble.
    A

    understanding

    B

    learning

    C

    knowledge

    D

    explanation


    正确答案： D
    解析：
    句意：如果你读了这本书，你就会对麻烦的起因了解得更多一些了。knowledge意为“知识，学问，了解”；understanding意为“理解，领会”；learning意为“知识，学问”；explanation意为“解释，说明”。

  • 第22题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    A:Do you have any suggestions about it? B:（）
    A

    No, I have no idea

    B

    Let me give you a hand

    C

    After I read it in detail, will tell you my opinion


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    I hope you will read all the material before you make the final decision.
    A

    will be read

    B

    will have read

    C

    will be reading

    D

    would have read


    正确答案： C
    解析：
    句意：我希望你在做最后决定之前读完所有的材料。will have done为将来完成时态，表示在将来某时间之前将会已经发生的动作。

相关内容