单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A until the last commitB canno

题目
单选题
Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
A

until the last commit

B

cannot be recovered

C

until the last offline backup

D

until the beginning of the last transaction

相似考题

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

2.Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A、until the last commitB、cannot be recoveredC、until the last offline backupD、until the beginning of the last transaction

3. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

4.You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A、 until Thursday morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening

更多“单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A until the last commitB canno”相关问题

  • 第1题：

    Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第2题：

    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第3题：

    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第4题：

    Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

    • A、The data files can be recovered till the last committed transaction.
    • B、The data files can be recovered without shutting down the database.
    • C、The data file is taken offline automatically； the database remains open.
    • D、The data files can be recovered to the time of the most recent backup.

    正确答案:A

  • 第5题：

    单选题
    Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
    A

    until the last commit

    B

    cannot be recovered

    C

    until the last offline backup

    D

    until the beginning of the last transaction


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

  • 第6题：

    单选题
    Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）
    A

    The data files can be recovered till the last committed transaction.

    B

    The data files can be recovered without shutting down the database.

    C

    The data file is taken offline automatically; the database remains open.

    D

    The data files can be recovered to the time of the most recent backup.


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

  • 第7题：

    单选题
    Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）
    A

    Until last commit

    B

    Until the time you perform recovery

    C

    Until the time the date file got corrupted

    D

    Until the point where the last transaction begun

    E

    You cannot recover the SYSTEMtablespaceand must re-create the database.


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

  • 第8题：

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

  • 第9题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第10题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


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

  • 第11题：

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged.  With reference to this scenario， up to what point in time can the data be recovered？（）
    A

    until Thursday morning

    B

    until last Sunday’s backup

    C

    until Wednesday evening

    D

    until that point in time when the database is opened

    E

    until that point in time when the recovery is performed

    F

    until that point in time when the table is dropped and purged


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

  • 第12题：

    单选题
    Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）
    A

    The data files can be recovered till the last committed transaction.

    B

    The data files can be recovered without shutting down the database.

    C

    The data file is taken offline automatically； the database remains open.

    D

    The data files can be recovered to the time of the most recent backup.


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

  • 第13题：

    Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）

    • A、The data files can be recovered till the last committed transaction.
    • B、The data files can be recovered without shutting down the database.
    • C、The data file is taken offline automatically; the database remains open.
    • D、The data files can be recovered to the time of the most recent backup.

    正确答案:A

  • 第14题：

    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

  • 第15题：

    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

    • A、Restore the data file and perform incomplete recovery.
    • B、Restore the data file and perform point-in-time recover.
    • C、Drop the tablespace and lose all data in the tablespace.
    • D、Restore the database and lose all data since the last backup.

    正确答案:C,D

  • 第16题：

    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

  • 第17题：

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


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

  • 第18题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第19题：

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

  • 第20题：

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

  • 第21题：

    单选题
    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）
    A

    Until last commit

    B

    Until the time you perform recovery

    C

    Until the time the date file got corrupted

    D

    Until the point where the last transaction begun

    E

    You cannot recover the SYSTEMtablespaceand must re-create the database.


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

  • 第22题：

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）
    A

     until Thursday morning

    B

     until that point in time when the database is opened

    C

     until that point in time when the recovery is performed

    D

     until last Sunday’s backup

    E

     until that point in time when the table is dropped and purged

    F

     until Wednesday evening


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

  • 第23题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


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

  • 第24题：

    单选题
    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
    A

     Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.

    B

     Just back up the database datafiles without shutting down the database.

    C

     You will have to wait until you can shut down the database to perform the backup.

    D

     Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.

    E

     Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup


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

相关内容