单选题What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（）   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter datab

题目
单选题
What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（）   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter database datafile 4 offline’ e. startup  f. shutdown
A

 a， c， b， d

B

 d， b， c， a

C

 f， d， b， c， a， e

D

 c， a， b， d， f

E

 a， b， d， e

相似考题

1.Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）1.Shut down the database.2.Take the users_01.dbf datafile offline with the alter database command.3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.4.Restore all users tablespace-related datafiles from backup media.5.Issue the recover tablespace users command.6.Issue the recover datafile users_01.dbf command.7.Start up the database.8.Bring the users_01.dbf datafile online with the alter database command.A.1，3，6，7B.2，3，6，8C.1，2，3，6，7D.1，2，3，6，，7，8E.2，3，6，5，7

2.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A、Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B、Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C、Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D、Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

3.You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.

4.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:Which is the recommended sequence of operations you need to perform for the query successfully?（）A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

更多“单选题What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（）   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter datab”相关问题

  • 第1题：

    A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）

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

    正确答案:A

  • 第2题：

    Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.

    • A、1，3，6，7
    • B、2，3，6，8
    • C、1，2，3，6，7
    • D、1，2，3，6，，7，8
    • E、2，3，6，5，7

    正确答案:B

  • 第3题：

    Which of the following commands cannot be executed when the database open？（）

    • A、RECOVER DATABASE
    • B、RECOVER TABLESPACE
    • C、RECOVER DATAFILE
    • D、ALTER DATABASE RECOVER DATAFILE

    正确答案:B

  • 第4题：

    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

    • A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
    • B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
    • C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
    • D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

    正确答案:C

  • 第5题：

    What will be the end result of this set of RMAN commands？（）   shutdown abort startup mount  restore datafile 4 until time ，，09/30/2008：15：00：00；  recover datafile 4 until time ，，09/29/2008：15：00：00；  alter database open resetlogs；

    • A、 Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.
    • B、 The restore command will fail.
    • C、 The recover command will fail.
    • D、 The alter database open resetlogs command will fail.
    • E、 All these commands will fail because they must be in the confines of a run block.

    正确答案:D

  • 第6题：

    单选题
    A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）
    A

    Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 

    B

    Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 

    C

    Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.

    D

    Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 


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

  • 第7题：

    单选题
    A user sends you an email with the following error message： create table idtable（id number） * ERROR at line  1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error：  2： No such file or directory Additional information：  3 You can choose from the following steps： a. Restore the missing database datafiles.  b. Take the missing datafile offline.  c. Shut down the database.  d. Issue the recover tablespace USERS command.  e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online.  g. Issue the alter database open command.  Which is the correct order of these steps in this case？（）
    A

    b， a， d， f

    B

    c， a， e， b， d， f， g

    C

    c， e， d， g

    D

    b， d， f 

    E

    e， d， g


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

  • 第8题：

    单选题
    Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.
    A

    1，3，6，7

    B

    2，3，6，8

    C

    1，2，3，6，7

    D

    1，2，3，6，，7，8

    E

    2，3，6，5，7


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

  • 第9题：

    单选题
    Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）
    A

     shutdown restore datafile 4； recover datafile 4； alter database open；

    B

     Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；

    C

     Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；

    D

     Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；

    E

     Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；


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

  • 第10题：

    单选题
    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
    A

     The USERS.DBF datafile is corrupted and cannot be restored by RMAN.

    B

     The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.

    C

     The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.

    D

     The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.


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

  • 第11题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
    A

     Restore and recover the datafile.

    B

     Restore and recover the tablespace.

    C

     Restore and recover the database.

    D

     Restore and recover the control file.

    E

     Restore and recover the parameter file.


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

  • 第12题：

    单选题
    What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（）   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter database datafile 4 offline’ e. startup  f. shutdown
    A

     a， c， b， d

    B

     d， b， c， a

    C

     f， d， b， c， a， e

    D

     c， a， b， d， f

    E

     a， b， d， e


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

  • 第13题：

    You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed.  What would be the appropriate order of operations to correct the situation？（）   a. Mount the database with the startup mount command.  b. Take the SYSTEM datafile offline with the alter database command.  c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command.  f. Issue the recover datafile SYSTEM_01.dbf command.  g. Open the database with the alter database open command.  h. Open the database with the alter database open resetlogs command.

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

    正确答案:D

  • 第14题：

    Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）  

    • A、 shutdown restore datafile 4； recover datafile 4； alter database open；
    • B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
    • C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
    • D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
    • E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；

    正确答案:E

  • 第15题：

    What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（）   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter database datafile 4 offline’ e. startup  f. shutdown

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

    正确答案:B

  • 第16题：

    Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command. 

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

    正确答案:B

  • 第17题：

    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

  • 第18题：

    单选题
    Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS.  The database is still running.  Which answer properly describes the rder of the steps that you would use to recover from this error？（）   a. Shut down the database.  b. Take the users_01.dbf datafile offline with the alter database command.  c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database.  h. Bring the users_01.dbf datafile online with the alter database command.
    A

    a， c， f， g

    B

    b， c， f， h

    C

    a， b， c， f， g

    D

    a， b， c， f， g， h

    E

    b， c， f， e， g


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

  • 第19题：

    单选题
    You have lost all your SYSTEM tablespace datafiles （system_01.dbf and system_02.dbf） nd the database has crashed.  What would be the appropriate order of operations to correct the situation？（）   a. Mount the database with the startup mount command.  b. Take the SYSTEM datafile offline with the alter database command.  c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.  d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command.  f. Issue the recover datafile SYSTEM_01.dbf command.  g. Open the database with the alter database open command.  h. Open the database with the alter database open resetlogs command.
    A

    a， c， f， g

    B

    b， d， e， h

    C

    a， b， c， f， g

    D

    d， a， e， g

    E

    b， c， f， e， g


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

  • 第20题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
    A

    Restore and recover the datafile. 

    B

    Restore and recover the tablespace. 

    C

    Restore and recover the database. 

    D

    Restore and recover the control file. 

    E

    Restore and recover the parameter file.


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

  • 第21题：

    单选题
    What will be the end result of this set of RMAN commands？（）   shutdown abort startup mount  restore datafile 4 until time ，，09/30/2008：15：00：00；  recover datafile 4 until time ，，09/29/2008：15：00：00；  alter database open resetlogs；
    A

     Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.

    B

     The restore command will fail.

    C

     The recover command will fail.

    D

     The alter database open resetlogs command will fail.

    E

     All these commands will fail because they must be in the confines of a run block.


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

  • 第22题：

    单选题
    A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）
    A

     Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.

    B

     Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.

    C

     Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.

    D

     Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.


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

  • 第23题：

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

  • 第24题：

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

相关内容