多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe valu

题目
多选题
Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）
A

the size of an undo block

B

the size of the redo log files

C

undo blocks generated per second

D

the size of the database buffer cache

E

the value of the UNDO_RETENTION parameter

相似考题

1.You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）A、guarantee undo retentionB、add one more redo log groupC、size the redo log files appropriatelyD、size the UNDO tablespace appropriatelyE、size the SYSTEM tablespace appropriatelyF、configure an appropriate undo retention intervalG、change automatic undo management to manual

2. Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance

3. You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）

4. Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance

更多“多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe valu”相关问题

  • 第1题：

    Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

    • A、increase the undo retention
    • B、create more undo segments
    • C、create another undo tablespace
    • D、increase the size of the undo tablespace

    正确答案:D

  • 第2题：

    A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）

    • A、increase the size of redo log files
    • B、increase the size of the undo tablespace
    • C、increase the size of the Database Buffer Cache
    • D、increase the size of the default temporary tablespace
    • E、enable the retention guarantee for the undo tablespace

    正确答案:B,E

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

    • A、 Enable Flashback Data Archive for the tables.
    • B、 Specify undo retention guarantee for the database.
    • C、 Enable supplemental logging for the database.
    • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
    • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

    正确答案:A

  • 第6题：

    In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

    • A、average row size
    • B、last analyzed date
    • C、size of table in bytes
    • D、size of table in database blocks
    • E、number of free blocks in the free list
    • F、number of extents present in the table

    正确答案:A,B,D

  • 第7题：

    单选题
    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）
    A

     Enable Flashback Data Archive for the tables.

    B

     Specify undo retention guarantee for the database.

    C

     Enable supplemental logging for the database.

    D

     Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.

    E

     Create Flashback Data Archive on the tablespace on which the tables are stored.


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

  • 第8题：

    多选题
    You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions resolve the issue（）
    A

    Disable automatic checkpoint tuning.

    B

    Check the size of the redo log file size and increase the size if it is small.

    C

    Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

    D

    Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.


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

  • 第9题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    the retention period to support flashback

    B

    the expected length of the longest-running query

    C

    the number of undo tablespaces in the database

    D

    the size of the Flash Recovery Area for the database instance


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

  • 第10题：

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

  • 第11题：

    多选题
    You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）
    A

    Disable automatic checkpoint tuning.

    B

    Check the size of the redo log file size and increase the size if it is small.

    C

    Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

    D

    Decrease the number of redo log members if there are more than one redo log members available in each redo log group.


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

  • 第12题：

    多选题
    A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）
    A

    increase the size of redo log files

    B

    increase the size of the undo tablespace

    C

    increase the size of the Database Buffer Cache

    D

    increase the size of the default temporary tablespace

    E

    enable the retention guarantee for the undo tablespace


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

  • 第13题：

    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

    • A、Average row size
    • B、Last analyzed date
    • C、Size of table in bytes
    • D、Size of table in database blocks
    • E、Number of free blocks in the free list
    • F、Number of extents present in the table.

    正确答案:A,B,D

  • 第14题：

    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

  • 第15题：

    You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）

    • A、Disable automatic checkpoint tuning.
    • B、Check the size of the redo log file size and increase the size if it is small.
    • C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. 
    • D、Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

    正确答案:B,C

  • 第16题：

    You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions resolve the issue（）

    • A、Disable automatic checkpoint tuning.
    • B、Check the size of the redo log file size and increase the size if it is small.
    • C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
    • D、Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.

    正确答案:B,C

  • 第17题：

    You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero.  What would you do to overcome this problem？（）

    • A、Increase the undo return
    • B、Create more undo segments
    • C、Create another undotablespace
    • D、Increase the size of the undo tablespace

    正确答案:D

  • 第18题：

    Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）

    • A、 The parameter DB_CACHE_SIZE must be a multiple of 8.
    • B、 The value of the parameter SGA_MAX_SIZE must be increased.
    • C、 The tablespace must be created with a uniform extent size of 8 KB
    • D、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

    正确答案:D

  • 第19题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第20题：

    单选题
    You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

    多选题
    Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）
    A

    the size of an undo block

    B

    the size of the redo log files

    C

    undo blocks generated per second

    D

    the size of the database buffer cache

    E

    the value of the UNDO_RETENTION parameter


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

  • 第24题：

    单选题
    Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）
    A

     The parameter DB_CACHE_SIZE must be a multiple of 8.

    B

     The value of the parameter SGA_MAX_SIZE must be increased.

    C

     The tablespace must be created with a uniform extent size of 8 KB

    D

     The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.


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

相关内容