单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）A Size of typical transactions B Concurrent transactions C Size of rows in table most frequently changed D Number of anticipat

题目
单选题
When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）
A

Size of typical transactions 

B

Concurrent transactions 

C

Size of rows in table most frequently changed 

D

Number of anticipated disk sorts

相似考题

1.A retail customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which questions will provide the information necessary to design the best performing storage solution of the following？（）A、How many web servers will be connected to the database？B、How many concurrent applications will run against the database？C、How many concurrent users will be accessing the database？D、What are the types of transactions run against the database？

2.When analyzing disk I/O performance， which of the following metrics and/or statistics should be included in the study？（）A、 Disk size， stock availability， VHDCIB、 Disk size， distance， temperature， and compatibilityC、 Disk fragmentation， MTBF， and maintenanceD、 Disk configuration， throughput， transactions， queues， and latencies

3.A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution？（）A、How many web servers will be connected to the database？B、Will the database be run on a Windows solution？C、How many concurrent users will be accessing the database？D、What are the types of transactions run against the database？

4.Which important factor is taken into account when determining an estimate for the maximum network bandwidth to be used by a customer？（）A、the size of the hard drives for each PC connected to the client’s networkB、the average size of the wallet based on the number of profiles and accountsC、if any users will use IBM Tivoli Access Manager for Enterprise Single Sign-On during non-work hoursD、the number of users that will be connected using the wireless network， as opposed to a wired connection

更多“单选题When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）A Size of typical transactions B Concurrent transactions C Size of rows in table most frequently changed D Number of anticipat”相关问题

  • 第1题：

    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

    正确答案:A,B

  • 第2题：

    You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

    • A、 It would return information regarding only the last committed transaction.
    • B、 It would return only the active transactions in all the undo segments in the database.
    • C、 It would return only the committed transactions in all the undo segments in the database.
    • D、 It would return both active and committed transactions in all the undo segments in the database.
    • E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

    正确答案:D

  • 第3题：

    You work as a database administrator for Certkiller .com. Users in the Certkiller .com 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 undotablespace

    正确答案:D

  • 第4题：

    You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?（）

    • A、Size of redo logs 
    • B、Number of datafiles 
    • C、LOG_CHECKPOINT_INTERVAL 
    • D、LOG_CHECKPOINT_TIMEOUT

    正确答案:B

  • 第5题：

    When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）

    • A、Size of typical transactions 
    • B、Concurrent transactions 
    • C、Size of rows in table most frequently changed 
    • D、Number of anticipated disk sorts

    正确答案:B

  • 第6题：

    Which three statements are true about database recovery operations？（）

    • A、Damaged or lost data files are restored from backups.
    • B、Redo log file entries are used to roll forward the database.
    • C、Undo segments are used to roll back any uncommitted transactions.
    • D、Transactions that were active when the failure occurred are restarted.
    • E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.

    正确答案:A,B,C

  • 第7题：

    单选题
    A retail customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations. Which questions will provide the information necessary to design the best performing storage solution of the following？（）
    A

    How many web servers will be connected to the database？

    B

    How many concurrent applications will run against the database？

    C

    How many concurrent users will be accessing the database？

    D

    What are the types of transactions run against the database？


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

  • 第8题：

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

  • 第9题：

    多选题
    Which two statements are true regarding transactions in an Oracle database（）
    A

    Multiple transactions can use the same undo segment.

    B

    A transaction is assigned an undo segment when it is started.

    C

    More than one transaction cannot share the same extent in the undo tablespace.

    D

    The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.


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

  • 第10题：

    单选题
    You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query；  Which statement is correct regarding the query output？（）
    A

    It would return information regarding only the last committed transaction.

    B

    It would return only the active transactions in all the undo segments in the database.

    C

    It would return only the committed transactions in all the undo segments in the database.

    D

    It would return both active and committed transactions in all the undo segments in the database.

    E

    It would return information regarding the transactions that began and were committed in the last 30 minutes.


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

  • 第11题：

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

  • 第12题：

    单选题
    You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
    A

     It would return information regarding only the last committed transaction.

    B

     It would return only the active transactions in all the undo segments in the database.

    C

     It would return only the committed transactions in all the undo segments in the database.

    D

     It would return both active and committed transactions in all the undo segments in the database.

    E

     It would return information regarding the transactions that began and were committed in the last 30 minutes.


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    单选题
    You work as a database administrator for Certkiller .com. Users in the Certkiller .com 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 undotablespace


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

  • 第19题：

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


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

  • 第20题：

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


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

  • 第21题：

    单选题
    When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）
    A

    Size of typical transactions 

    B

    Concurrent transactions 

    C

    Size of rows in table most frequently changed 

    D

    Number of anticipated disk sorts


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

  • 第22题：

    单选题
    A customer has a database application that is accessed by a large number of people through a web interface from multiple remote locations.  Which of the following questions will provide the information necessary to design the best performing storage solution？（）
    A

    How many web servers will be connected to the database？

    B

    Will the database be run on a Windows solution？

    C

    How many concurrent users will be accessing the database？

    D

    What are the types of transactions run against the database？


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

  • 第23题：

    单选题
    When analyzing disk I/O performance， which of the following metrics and/or statistics should be included in the study？（）
    A

     Disk size， stock availability， VHDCI

    B

     Disk size， distance， temperature， and compatibility

    C

     Disk fragmentation， MTBF， and maintenance

    D

     Disk configuration， throughput， transactions， queues， and latencies


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

  • 第24题：

    单选题
    Which important factor is taken into account when determining an estimate for the maximum network bandwidth to be used by a customer？（）
    A

    the size of the hard drives for each PC connected to the client’s network

    B

    the average size of the wallet based on the number of profiles and accounts

    C

    if any users will use IBM Tivoli Access Manager for Enterprise Single Sign-On during non-work hours

    D

    the number of users that will be connected using the wireless network， as opposed to a wired connection


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

相关内容