单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins

题目
单选题
You can control instance recover performance by setting parameters to define targets for（）
A

The size of the redo buffer in SGA. 

B

The instance that will perform recovery in Real Application Cluster database. 

C

The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 

D

The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

相似考题

1.Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

2. 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 switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery

3. Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost.  Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database.  What are three other characteristics of Trial Recovery（）A、Speeds up subsequent media recover actions.B、Writes any uncorrupted block to disk during the test recovery.C、Can be invoked by adding the TEST option to any RECOVER command.D、Allows the Administrator to determine how many blocks are affected by corruption.E、Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.

4.You can control instance recover performance by setting parameters to define targets for（）A、The size of the redo buffer in SGA. B、The instance that will perform recovery in Real Application Cluster database. C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

更多“单选题You can control instance recover performance by setting parameters to define targets for（）A The size of the redo buffer in SGA. B The instance that will perform recovery in Real Application Cluster database. C The number of blocks to be read during ins”相关问题

  • 第1题：

    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

    • A、to enable the ASM instance to identify the alert log file
    • B、to enable the ASM instance to identify the server parameter file
    • C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
    • D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

    正确答案:D

  • 第2题：

    What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）

    • A、It can contain parameters with distinct values for each distance.
    • B、It can contain only parameters with identical values for each instance.
    • C、It must contain an IFILE parameter for each instance’s individual parameter file.
    • D、It must be located in the default location for the primary instance’s parameter file.

    正确答案:A

  • 第3题：

    Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）

    • A、Data blocks have to be written more frequently by DBWR. 
    • B、Redo blocks have to be written more frequently by LGWR. 
    • C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
    • D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

    正确答案:A

  • 第4题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第5题：

    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）

    • A、Start the instance and open the database, instance recovery automatically recovers control files 
    • B、Create a file based on the contents of the trace file and save it to the control file locations and start the database 
    • C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 
    • D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 
    • E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    正确答案:D

  • 第6题：

    多选题
    You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
    A

    By multiplexing the control files

    B

    By multiplexing the redo log files

    C

    By decreasing the size of redo log files

    D

    By configuring mean time to recover （MTTR） to a lower value

    E

    By setting the UNDO_RETENTION parameter to a higher value


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

  • 第7题：

    单选题
    You can control instance recover performance by setting parameters to define targets for（）
    A

    The size of the redo buffer in SGA. 

    B

    The instance that will perform recovery in Real Application Cluster database. 

    C

    The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 

    D

    The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.


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

  • 第8题：

    多选题
    Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost.  Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database.  What are three other characteristics of Trial Recovery（）
    A

    Speeds up subsequent media recover actions.

    B

    Writes any uncorrupted block to disk during the test recovery.

    C

    Can be invoked by adding the TEST option to any RECOVER command.

    D

    Allows the Administrator to determine how many blocks are affected by corruption.

    E

    Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.


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

  • 第9题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）
    A

    restore the tablespace from the backup; there is no need to apply the redo information 

    B

    restore the full database to recover the data up to the point when you performed the backup 

    C

    restore the tablespace from the backup， and then perform a recovery using the backup control file

    D

    restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied


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

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
    A

    Start the instance and open the database， instance recovery automatically recoverscontrol files

    B

    Create a file based on the contents of the trace file and save it to the control file locations and start the database

    C

    Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）

    D

    Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    E

    Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.


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

  • 第11题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


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

  • 第12题：

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


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

  • 第13题：

    Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）

    • A、 increase the number of checkpoint processes
    • B、 define the POWER option while adding or removing the disks
    • C、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
    • D、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
    • E、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

    正确答案:B,E

  • 第14题：

    You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

    • A、Start the instance and open the database， instance recovery automatically recoverscontrol files
    • B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
    • C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
    • D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
    • E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    正确答案:D

  • 第15题：

    You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）

    • A、By multiplexing the control files
    • B、By multiplexing the redo log files
    • C、By decreasing the size of redo log files
    • D、By configuring mean time to recover （MTTR） to a lower value
    • E、By setting the UNDO_RETENTION parameter to a higher value

    正确答案:C,D

  • 第16题：

    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 log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

    • A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • B、 the column of the V$INSTANCE_RECOVERY view
    • C、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • D、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

    正确答案:C

  • 第17题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

    • A、 restore the tablespace from the backup； there is no need to apply the redo information
    • B、 restore the full database to recover the data up to the point when you performed the backup
    • C、 restore the tablespace from the backup and then perform a recovery using the backup control file
    • D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第18题：

    单选题
    You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
    A

    Shut down the instance， copy the control file to the third location and open the database.

    B

    Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    C

    Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.

    D

    Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    E

    Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.


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

  • 第19题：

    单选题
    What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）
    A

    It can contain parameters with distinct values for each distance.

    B

    It can contain only parameters with identical values for each instance.

    C

    It must contain an IFILE parameter for each instance’s individual parameter file.

    D

    It must be located in the default location for the primary instance’s parameter file.


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

  • 第20题：

    单选题
    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 log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）
    A

     the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    B

     the column of the V$INSTANCE_RECOVERY view

    C

     the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    D

     the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view


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

  • 第21题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）
    A

    to enable the ASM instance to identify the alert log file

    B

    to enable the ASM instance to identify the server parameter file

    C

    to enable the ASM instance to define the locations for Oracle Managed Files （OMF）

    D

    to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory


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

  • 第22题：

    单选题
    You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database？（）
    A

    Start the instance and open the database, instance recovery automatically recovers control files 

    B

    Create a file based on the contents of the trace file and save it to the control file locations and start the database 

    C

    Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) 

    D

    Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. 

    E

    Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.


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

  • 第23题：

    单选题
    Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）
    A

    The minimum memory size for the database buffer cache is set to 100 mb.

    B

    The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb

    C

    The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.

    D

    The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb


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

  • 第24题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

相关内容