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

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

相似考题

1.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG

2.Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer

3.If you create your database using Oracle Managed Files （OMF）， what is true？（）A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

4. In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

更多“You have only two redo log groups and these groups get overw”相关问题

  • 第1题：

    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

    • A、 ALTER DATABASE DROP LOGFILE GROUP 1
    • B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
    • C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
    • D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

    正确答案:C

  • 第2题：

    You have the following online redo log configuration：    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）

    • A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；
    • B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；
    • C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；
    • D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；
    • E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；
    • F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；

    正确答案:A,C

  • 第3题：

    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）

    • A、any control file
    • B、any archive log file
    • C、one of the redo log members
    • D、loss of the initialization parameter file
    • E、any data file belonging to the default permanent tablespac

    正确答案:A

  • 第4题：

    Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）

    • A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；
    • B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；
    • C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；
    • D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

    正确答案:C

  • 第5题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
    A

    You should perform a log switch

    B

    You should make a backup of the database

    C

    You should switch the database to the NONARCHIVELOG mode

    D

    You should shut down the database instance and perform a complete database recovery


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

  • 第6题：

    单选题
    Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）
    A

     The database will operate normally without generating any redo.

    B

     The database will hang， and you must shut down and restart the instance.

    C

     The database will crash， and you must recover the database from the point of failure.

    D

     The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.


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

  • 第7题：

    单选题
    You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）
    A

     The online redo log file Is not allowed to be overwritten.

    B

     The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.

    C

     The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

    D

     The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.


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

  • 第8题：

    多选题
    You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
    A

    Increase the size of redo log files

    B

    Increase the size of redo log buffer

    C

    Increase the number of redo log files

    D

    Place the redo log files on a separate disk

    E

    Decrease the number of redo log groups to two

    F

    Increate the number Log Writer （LGWR） process


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

  • 第9题：

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

  • 第10题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting？（）
    A

    When a new log group is added， it would have one member in each disk group.

    B

    When a new log group is added， it would have two members in each disk group.

    C

    When a new tablespace is added， it would have one data file in each disk group.

    D

    When a new log file is added， it would have one member spread across the disk groups.


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

  • 第11题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）
    A

     You should perform a log switch

    B

     You should make a backup of the database

    C

     You should switch the database to the NONARCHIVELOG mode

    D

     You should shut down the database instance and perform a complete database recovery


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

  • 第12题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors：   ORA-00313： open failed for members of log group 1 of thread 1   ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’   You discover that the online redo log file of the current redo group is corrupted.  Which statement should you use to resolve this issue？（）
    A

     SQL>ALTER DATABASE DROP LOGFILE GROUP 1；

    B

     SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；

    C

     SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；

    D

     SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；


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

  • 第13题：

    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

    • A、You should perform a log switch
    • B、You should make a backup of the database
    • C、You should switch the database to the NONARCHIVELOG mode
    • D、You should shut down the database instance and perform a complete database recovery

    正确答案:B

  • 第14题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第15题：

    In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

    • A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
    • B、 when all the online redo log groups are not multiplexed and one log group is missing
    • C、 when all the control files are missing
    • D、 when some important tables are deleted from the database and purged from the Recycle Bin

    正确答案:A

  • 第16题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）
    A

     ALTER DATABASE DROP LOGFILE GROUP 1

    B

     ALTER DATABASE CLEAR LOGFILE GROUP 1

    C

     ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1

    D

     ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’


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

  • 第17题：

    单选题
    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
    A

     The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.

    B

     Before the instance starts， you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens， but every attempt to write to redo log files fails with an error.


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

  • 第18题：

    多选题
    In your production database， you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation， you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members.  Which two actions would you take to improve the performance of the database server？（）
    A

    increase the size of the redo log buffer

    B

    increase the number of redo log groups

    C

    increase the number of log writer processes

    D

    increase the number of ARCn processes

    E

    change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


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

  • 第19题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）
    A

    ALTER DATABASE DROP LOGFILE GROUP 1;

    B

    ALTER DATABASE CLEAR LOGFILE GROUP 1;

    C

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

    D

    ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG


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

  • 第20题：

    单选题
    Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）
    A

    any control file

    B

    any archive log file

    C

    one of the redo log members

    D

    loss of the initialization parameter file

    E

    any data file belonging to the default permanent tablespac


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

  • 第21题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with one device each. In the parameter file of the production database， the following parameters have been specified：  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting？（）
    A

     When a new log group is added， it would have one member in each disk group.

    B

     When a new log group is added， it would have two members in each disk group.

    C

     When a new tablespace is added， it would have one data file in each disk group.

    D

     When a new log file is added， it would have one member spread across the disk groups.


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

  • 第22题：

    多选题
    Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）
    A

    archival

    B

    log writer

    C

    database writer

    D

    system monitor

    E

    process monitor

    F

    change tracking writer


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

  • 第23题：

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


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

相关内容