单选题What is the proper procedure to recover a lost tempfile？（）ARestore the backup copy of the tempfile from the backup media.BRe-create the tempfile with the create tempfile command.CCopy an existing tempfile from another database.DRe-create the tempfile w

题目
单选题
What is the proper procedure to recover a lost tempfile？（）
A

 Restore the backup copy of the tempfile from the backup media.

B

 Re-create the tempfile with the create tempfile command.

C

 Copy an existing tempfile from another database.

D

 Re-create the tempfile with the create tablespace command.

E

 Re-create the tempfile with the alter tablespace command.

相似考题

1.What methods are available to recover lost control files？（） A、 Backup control file.B、 Emergency control file.C、 The create controlfile command.D、 The restore controlfile SQL*Plus command.E、 No backup is required. The database will re-create the control file when it is discovered to be lost.

2. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

3. You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. A、a， b， f， gB、c， f， gC、a， d， f， gD、a， f， gE、a， e， g

4. You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.

更多“单选题What is the proper procedure to recover a lost tempfile？（）A  Restore the backup copy of the tempfile from the backup media.B  Re-create the tempfile with the create tempfile command.C  Copy an existing tempfile from another database.D  Re-create the te”相关问题

  • 第1题：

    The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted.  What steps should you take to recover from this tempfile loss in an efficient manner？（）  

    • A、 Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfiles
    • B、 Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGS
    • C、 Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfile
    • D、 Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted

    正确答案:D

  • 第2题：

    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 database
    • B、perform point-in-time recovery
    • C、perform a full database recovery
    • D、drop and re-create the tablespace
    • E、use Recovery Manager （RMAN） to recover the database

    正确答案:D

  • 第3题：

    The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）

    • A、The data file cannot be recovered.
    • B、The date file can be restored from theSYSTEMauto backup.
    • C、Take thetablespaceoffline，drop，kand re-create it.
    • D、Recovery Manager （RMAN） is used to recover the data file.
    • E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

    正确答案:A

  • 第4题：

    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

    • A、Take the USERS tablespace offline and re-create the lost data file.
    • B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
    • C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
    • D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

    正确答案:C

  • 第5题：

    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

  • 第6题：

    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

    正确答案:D

  • 第7题：

    单选题
    You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）
    A

    A text copy of the control file.

    B

    A binary copy of the control file.

    C

    A file containing a SQL statement which will re-create the database.

    D

    A file containing a SQL statement which will re-create the control file.


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

  • 第8题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.


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

  • 第9题：

    多选题
    What methods are available to recover lost control files？（）
    A

    Backup control file.

    B

    Emergency control file.

    C

    The create controlfile command.

    D

    The restore controlfile SQL*Plus command.

    E

    No backup is required. The database will re-create the control file when it is discovered to be lost.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
    A

    Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

    B

    Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

    C

    Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

    D

    Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.


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

  • 第12题：

    单选题
    You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message：   CREATE TABLESPACE tbsl；  ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199  02199， 00000， “missing DATAFILE/TEMPFILE clause”  *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.  *Action： specify DATAFILE/TEMPFILE clause.   What is the corrective action to create the OMF based tablespace？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第13题：

    In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

    • A、 import the database from the last export
    • B、 restore all the members in the group from the last backup
    • C、 drop the lost member from the database and then add a new member to the group
    • D、 restore all the database files from the backup and then perform a complete recovery
    • E、 restore all the database files from the backup and then perform an incomplete recovery

    正确答案:C

  • 第14题：

    What is the proper procedure to recover a lost tempfile？（）  

    • A、 Restore the backup copy of the tempfile from the backup media.
    • B、 Re-create the tempfile with the create tempfile command.
    • C、 Copy an existing tempfile from another database.
    • D、 Re-create the tempfile with the create tablespace command.
    • E、 Re-create the tempfile with the alter tablespace command.

    正确答案:E

  • 第15题：

    If a backup is expired， which of the following is true？（）  

    • A、 It can never be used for a restore/recover operation.
    • B、 Oracle will remove the backup set pieces from the flash recovery area.
    • C、 The backup has been used at least once to restore and recover the database.
    • D、 The backup is no longer valid because of a resetlogs operation.
    • E、 The physical backup set pieces are missing from the media.

    正确答案:E

  • 第16题：

    What is the proper procedure to recover a lost tempfile?（）

    • A、Restore the backup copy of the tempfile from the backup media. 
    • B、Re-create the tempfile with the create tempfile command. 
    • C、Copy an existing tempfile from another database. 
    • D、Re-create the tempfile with the create tablespace command. 
    • E、Re-create the tempfile with the alter tablespace command.

    正确答案:E

  • 第17题：

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

    • A、 Restore the lost data file from the backup， and then flash back the database.
    • B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
    • C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
    • D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
    • E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

    正确答案:B,E

  • 第18题：

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

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第19题：

    单选题
    What is the proper procedure to recover a lost tempfile?（）
    A

    Restore the backup copy of the tempfile from the backup media. 

    B

    Re-create the tempfile with the create tempfile command. 

    C

    Copy an existing tempfile from another database. 

    D

    Re-create the tempfile with the create tablespace command. 

    E

    Re-create the tempfile with the alter tablespace command.


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

  • 第20题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第21题：

    单选题
    You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database.
    A

    a， b， f， g

    B

    c， f， g

    C

    a， d， f， g

    D

    a， f， g

    E

    a， e， g


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

  • 第22题：

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


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

  • 第23题：

    单选题
    If a backup is expired， which of the following is true？（）
    A

     It can never be used for a restore/recover operation.

    B

     Oracle will remove the backup set pieces from the flash recovery area.

    C

     The backup has been used at least once to restore and recover the database.

    D

     The backup is no longer valid because of a resetlogs operation.

    E

     The physical backup set pieces are missing from the media.


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

相关内容