单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A Nothing happensB Oracle will automatically switch redo logs when detected C Oracle eventually won'

题目
单选题
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）
A

Nothing happens

B

Oracle will automatically switch redo logs when detected 

C

Oracle eventually won't allow new records to be added to the database 

D

The instance crashes

相似考题

1. You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

2.The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.A、large poolB、shared poolC、data buffer cacheD、redo log bufferE、data dictionary cache

3.Archived redo logs can be copied to more than one destination by Oracle.（）A、 TrueB、 False

4. You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

更多“单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A Nothing happensB Oracle will automatically switch redo logs when detected C Oracle eventually won'”相关问题

  • 第1题：

    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  

    • A、the value of the UNDO_RETENTION initialization parameter
    • B、the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
    • C、the online redo log files size
    • D、the number of redo log members in a group

    正确答案:C

  • 第2题：

    As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

    • A、 Shut down the database
    • B、 Clear the online redo log
    • C、 Back up the database
    • D、 Checkpoint the database
    • E、 Call Oracle support

    正确答案:D

  • 第3题：

    Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）

    • A、current redo log and inactive redo log
    • B、checkpoint position to end of redo log
    • C、beginning of redo log to end of redo log
    • D、all redo logs before the point of last commit
    • E、beginning of redo log to checkpoint position

    正确答案:B

  • 第4题：

    In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

    • A、Nothing happens
    • B、Oracle will automatically switch redo logs when detected 
    • C、Oracle eventually won't allow new records to be added to the database 
    • D、The instance crashes

    正确答案:C

  • 第5题：

    One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）

    • A、uses undo data for roll forward
    • B、uses Flashback Log for recovery
    • C、uses online redo logs to roll back
    • D、uses undo data to roll back the transaction
    • E、uses Recovery Manager （RMAN） to roll back
    • F、uses the System Monitor （SMON） background process to perform instance recovery

    正确答案:D

  • 第6题：

    You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.

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

    正确答案:E

  • 第7题：

    多选题
    You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）
    A

    This operation resets the SCN for the database.

    B

    This operation creates a new incarnation of the database.

    C

    This operation moves all the redo log files to a different location.

    D

    This operation deletes the old redo log files and creates new redo log files.

    E

    This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


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

  • 第8题：

    单选题
    You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）
    A

    Shared pool 

    B

    Control file 

    C

    SGA 

    D

    PGA


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

  • 第9题：

    单选题
    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）
    A

    until SCN

    B

    until time

    C

    until cancel

    D

    using backup control file


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

  • 第10题：

    单选题
    In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）
    A

    Nothing happens

    B

    Oracle will automatically switch redo logs when detected 

    C

    Oracle eventually won't allow new records to be added to the database 

    D

    The instance crashes


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

  • 第11题：

    单选题
    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
    A

     The archived redo logs are stored in an operating system-dependent location.

    B

     The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

    C

     The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

    D

     The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.


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

  • 第12题：

    单选题
    You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.
    A

    b， a， f

    B

    e， b， a， f

    C

    e， b， a， g

    D

    b， a， g

    E

    c， e， b， d， f


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

  • 第13题：

    You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

    • A、Oracle Flashback uses undo information to construct consistent data. 
    • B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
    • C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
    • D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

    正确答案:A,B

  • 第14题：

    You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

    • A、Shared pool 
    • B、Control file 
    • C、SGA 
    • D、PGA

    正确答案:B

  • 第15题：

    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

    • A、 multiplexed control files
    • B、 RMAN obsolete backups
    • C、 multiplexed online redo log files
    • D、 archived redo logs that have not been copied to tape

    正确答案:B

  • 第16题：

    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第17题：

    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

    • A、 The archived redo logs are stored in an operating system-dependent location.
    • B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
    • C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
    • D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

    正确答案:C

  • 第18题：

    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

  • 第19题：

    单选题
    One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
    A

    uses undo data for roll forward

    B

    uses Flashback Log for recovery

    C

    uses online redo logs to roll back

    D

    uses undo data to roll back the transaction

    E

    uses Recovery Manager （RMAN） to roll back

    F

    uses the System Monitor （SMON） background process to perform instance recovery


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

  • 第20题：

    单选题
    Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）
    A

    current redo log and inactive redo log

    B

    checkpoint position to end of redo log

    C

    beginning of redo log to end of redo log

    D

    all redo logs before the point of last commit

    E

    beginning of redo log to checkpoint position


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）
    A

     Oracle Enterprise Manager

    B

     The V$LOG view

    C

     The V$LOGFILE view

    D

     The V$FLASHBACK_DATABASE_LOGS view


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

  • 第22题：

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

  • 第23题：

    单选题
    You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）
    A

    the value of the UNDO_RETENTION initialization parameter

    B

    the value of the optimal redo log file size provided by the Redo Logfile Size Advisor

    C

    the online redo log files size

    D

    the number of redo log members in a group


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

  • 第24题：

    单选题
    What will be the result of the following configuration？（）   Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydb
    A

     An error will occur during database startup because the second parameter is not valid.

    B

     An error will occur during database startup since you are trying to create archived redo logs in two different locations.

    C

     Archived redo logs will be created in two different locations by the ARCH process.

    D

     Archived redo logs will be created in two different locations by the LGWR process.

    E

     Neither parameter setting is valid， so the database will not start up.


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

相关内容