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

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

相似考题

1. A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error：  SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal；  SELECT ename FROM emp WHERE deptno=10 ORDER BY sal  ERROR at line 1：  ORA-01157： cannot identify/lock data file  201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’  What is a possible reason？（）A、 The tempfile belonging to the default temporary tablespace is missing.B、 The database is opened in restricted mode， so queries are not allowedC、 The default temporary tablespace required to execute the query is offline.D、 The default temporary tablespace required to execute the query is dropped.E、 The default temporary tablespace required to execute the query is read-only.

2. 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 tempfilesB、 Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGSC、 Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfileD、 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

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

4.You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

更多“单选题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 ru”相关问题

  • 第1题：

    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）

    • A、It will create the tablespace TEMP1 in group G1.
    • B、It will create the tablespace TEMP1 in group G3.
    • C、It will not add the tablespace TEMP1 to any group.
    • D、It will create the tablespace TEMP1 in the default group.

    正确答案:C

  • 第2题：

    Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）

    • A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
    • B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
    • C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
    • D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

    正确答案:C

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows：   CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ；   Which statement regarding the above command is correct？（）  

    • A、 It will create the tablespace TEMP1 in group G1.
    • B、 It will create the tablespace TEMP1 in group G3.
    • C、 It will not add the tablespace TEMP1 to any group.
    • D、 It will create the tablespace TEMP1 in the default group.

    正确答案:C

  • 第5题：

    单选题
    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
    解析： 暂无解析

  • 第6题：

    单选题
    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）
    A

    the CREATE TABLE .. command

    B

    sorting of the SYSTEM tablespace’s data

    C

    sorting of data required by recursive SQL statements

    D

    the CREATE TABLE .. ORGANIZATION EXTERNAL .. command

    E

    sorting of data if the users have not been allocated temporary tablespace explicitly

    F

    sorting of data if the users have been allocated temporary tablespace explicitly


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

  • 第7题：

    单选题
    A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error：  SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal；  SELECT ename FROM emp WHERE deptno=10 ORDER BY sal  ERROR at line 1：  ORA-01157： cannot identify/lock data file  201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’  What is a possible reason？（）
    A

     The tempfile belonging to the default temporary tablespace is missing.

    B

     The database is opened in restricted mode， so queries are not allowed

    C

     The default temporary tablespace required to execute the query is offline.

    D

     The default temporary tablespace required to execute the query is dropped.

    E

     The default temporary tablespace required to execute the query is read-only.


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

  • 第8题：

    单选题
    Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）
    A

     Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.

    B

     Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

    C

     Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.

    D

     Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.


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

  • 第9题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE /u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1

    B

    It will create the tablespace TEMP1 in group G3 

    C

    It will not add the tablespace TEMP1 to any group

    D

    It will create the tablespace TEMP1 in the default group

    E

    It will throw an error with message 'specified group is not available

    F

    It will create a new group with a system-generated name and add the tablespace TEMP1 to it.


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

  • 第10题：

    单选题
    You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）
    A

     flash back the database

    B

     import the temporary tablespace from the last export

    C

     restore all the data files and temporary files from the last full database backup and perform a recovery

    D

     not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace


    正确答案： 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题：

    单选题
    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）
    A

     DROP TABLESPACE temp1；

    B

     DROP TABLESPACE temp1 INCLUDING CONTENTS；

    C

     DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；

    D

     DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；


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

  • 第13题：

    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

  • 第14题：

    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

    • A、 DROP TABLESPACE temp1；
    • B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
    • C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
    • D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

    正确答案:C

  • 第15题：

    Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）

    • A、Restore the data file for the SYSTEM tablespace then open the database. 
    • B、Restore all redo logs form last night's backup, then restart the database. 
    • C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 
    • D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 

    正确答案:C

  • 第16题：

    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）

    • A、a， b， e， c
    • B、b， e， d
    • C、a， b， d， c
    • D、b， g， c， f
    • E、a， b， d， f

    正确答案:A

  • 第17题：

    单选题
    You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows：   CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ；   Which statement regarding the above command is correct？（）
    A

     It will create the tablespace TEMP1 in group G1.

    B

     It will create the tablespace TEMP1 in group G3.

    C

     It will not add the tablespace TEMP1 to any group.

    D

     It will create the tablespace TEMP1 in the default group.


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

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）
    A

    Restore the data file for the SYSTEM tablespace then open the database. 

    B

    Restore all redo logs form last night's backup, then restart the database. 

    C

    Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 

    D

    Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 


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

  • 第20题：

    单选题
    You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）
    A

    It will create the tablespace TEMP1 in group G1.

    B

    It will create the tablespace TEMP1 in group G3.

    C

    It will not add the tablespace TEMP1 to any group.

    D

    It will create the tablespace TEMP1 in the default group.


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

  • 第21题：

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


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

  • 第22题：

    单选题
    You have lost datafiles 1 and 3 from your database，and the database has crashed.  In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline.  2. startup mount the database  3. Issue the alter database open command. 4. Restore the datafiles that were lost  5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online.  7. Recover the database with the recover database command.
    A

     2，1，3，4，5，6

    B

     2，4，5，3

    C

     4，7，3

    D

     2，4，7，3

    E

     2，7，3


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

  • 第23题：

    单选题
    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）
    A

    a， b， e， c

    B

    b， e， d

    C

    a， b， d， c

    D

    b， g， c， f

    E

    a， b， d， f


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

  • 第24题：

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


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

相关内容