itgle.com

多选题Which three statements correctly describe the features of the I/O calibration process?()AOnly one I/O calibration process can run at a time.BIt automates the resource allocation for the Automated Maintenance Tasks.CIt improves the performance of the pe

题目
多选题
Which three statements correctly describe the features of the I/O calibration process?()
A

Only one I/O calibration process can run at a time.

B

It automates the resource allocation for the Automated Maintenance Tasks.

C

It improves the performance of the performance-critical sessions while running.

D

It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

E

The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.


相似考题
更多“多选题Which three statements correctly describe the features of the I/O calibration process?()AOnly one I/O calibration process can run at a time.BIt automates the resource allocation for the Automated Maintenance Tasks.CIt improves the performance of the pe”相关问题
  • 第1题:

    Which three statements are true about windows? ()(Choose three.)

    A. Only one window can be open at any given time

    B. Consumer groups are associated with windows

    C. Windows work with job classes to control resource allocation

    D. The database service name must be provided during windows creation

    E. Windows can automatically start job or change resource allocation among jobs for various time periods.


    参考答案:A, C, E

  • 第2题:

    When the length of the run queues, process or thread dispatches interrupts, and lock contention metrics and statistics are analyzed for performance, which of the following resources is being analyzed?()

    • A、 CPU
    • B、 Memory
    • C、 Disk I/O
    • D、 Network I/O

    正确答案:A

  • 第3题:

    A Power 770 customer needs to add additional I/O adapters.  There is no room for the cards, so an I/O drawer must be added. What resource will help identify supported I/O drawers and the maximum number of drawers permitted per loop?()

    • A、I/O Planning Guide
    • B、Power Systems data sheet
    • C、Power Systems Facts and Features
    • D、Run FLRT to recommend I/O features

    正确答案:C

  • 第4题:

    Which statement can be an inference from the output?()

    • A、The FRA disk group has an asynchronous I/O bottleneck
    • B、The least number of I/Os are performed on the last data file in the list
    • C、The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list
    • D、The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group

    正确答案:A

  • 第5题:

    Which three statements are true about windows?() 

    • A、 Only one window can be open at any given time
    • B、 Consumer groups are associated with windows
    • C、 Windows work with job classes to control resource allocation
    • D、 The database service name must be provided during windows creation
    • E、 Windows can automatically start job or change resource allocation among jobs for various time periods.

    正确答案:A,C,E

  • 第6题:

    You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()

    • A、 CPU usage
    • B、 degree of parallelism
    • C、 number of open cursors
    • D、 number of sorts performed
    • E、 idle time for blocking sessions
    • F、 number of disk I/O operations performed
    • G、 number of memory I/O operations performed

    正确答案:A,B,E

  • 第7题:

    In your production database, you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()

    • A、CPU usage
    • B、degree of parallelism
    • C、number of open cursors
    • D、number of sorts performed
    • E、idle time for blocking sessions
    • F、number of disk I/O operations performed
    • G、number of memory I/O operations performed

    正确答案:A,B,E

  • 第8题:

    多选题
    Which three statements are true about windows?()
    A

    Only one window can be open at any given time

    B

    Consumer groups are associated with windows

    C

    Windows work with job classes to control resource allocation

    D

    The database service name must be provided during windows creation

    E

    Windows can automatically start job or change resource allocation among jobs for various time periods.


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

  • 第9题:

    多选题
    You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


    正确答案: G,D
    解析: 暂无解析

  • 第10题:

    多选题
    Which two statements are true with respect to the maintenance window?() .
    A

    A DBA can enable or disable an individual task in all maintenance windows.

    B

    A DBA cannot change the duration of the maintenance window after it is created.

    C

    In case of a long maintenance window,all Automated Maintenance Tasks are restarted every four hours.

    D

    A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window


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

  • 第11题:

    单选题
    Which statement can be an inference from the output?()
    A

    The FRA disk group has an asynchronous I/O bottleneck

    B

    The least number of I/Os are performed on the last data file in the list

    C

    The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list

    D

    The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group


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

  • 第12题:

    多选题
    In your production database, you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager?()
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


    正确答案: D,G
    解析: 暂无解析

  • 第13题:

    Which of the following statements is mot correct about mirroring?()

    A.Mirroring, with the write-verify option turned on, can be used to increase performance.

    B.Mirroring is a better choice that disk-striping, for large sequential-access file system when one is looking for performance.

    C.Mirroring, with a parallel-scheduling policy, may improve I/O read-operation performance.

    D.Mirroring, with maximum inter-disk allocation policy, is used to enhance availability.


    参考答案:C

  • 第14题:

    Which of the following phrases is TRUE regarding monitoring disk I/O with iostat?()

    • A、 The iostat can only be run as the root user
    • B、 There could be zero percent I/O wait and still be an I/O bottleneck
    • C、 Any I/O wait time displayed in output of "iostat" is an indication of severe I/O bottlenecks 
    • D、 Running "iostat" without any arguments/parameters is sufficient for resolving I/O bottlenecks

    正确答案:B

  • 第15题:

    Which of the following statements is mot correct about mirroring?()

    • A、Mirroring, with the write-verify option turned on, can be used to increase performance.
    • B、Mirroring is a better choice that disk-striping, for large sequential-access file system when one is looking for performance.
    • C、Mirroring, with a parallel-scheduling policy, may improve I/O read-operation performance.
    • D、Mirroring, with maximum inter-disk allocation policy, is used to enhance availability.

    正确答案:C

  • 第16题:

    Which three statements are true about windows? ()(Choose three.)

    • A、Only one window can be open at any given time
    • B、Consumer groups are associated with windows
    • C、Windows work with job classes to control resource allocation
    • D、The database service name must be provided during windows creation
    • E、Windows can automatically start job or change resource allocation among jobs for various time periods.

    正确答案:A,C,E

  • 第17题:

    Which two statements are true with respect to the maintenance window?() .

    • A、 A DBA can enable or disable an individual task in all maintenance windows.
    • B、 A DBA cannot change the duration of the maintenance window after it is created.
    • C、 In case of a long maintenance window,all Automated Maintenance Tasks are restarted every four hours.
    • D、 A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

    正确答案:A,D

  • 第18题:

    Which two statements are true with respect to the maintenance window? ()

    • A、A DBA can enable or disable an individual task in all maintenance windows.
    • B、A DBA cannot change the duration of the maintenance window after it is created.
    • C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
    • D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

    正确答案:A,D

  • 第19题:

    Which three statements correctly describe the features of the I/O calibration process?()

    • A、 Only one I/O calibration process can run at a time
    • B、 It automates the resource allocation for the Automated Maintenance Tasks
    • C、 It improves the performance of the performance-critical sessions while running
    • D、 It can be used to estimate the maximum number of I/Os and maximum latency time for the system
    • E、 The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE

    正确答案:A,D,E

  • 第20题:

    单选题
    When the length of the run queues, process or thread dispatches interrupts, and lock contention metrics and statistics are analyzed for performance, which of the following resources is being analyzed?()
    A

     CPU

    B

     Memory

    C

     Disk I/O

    D

     Network I/O


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

  • 第21题:

    多选题
    Which three statements are true about windows? ()(Choose three.)
    A

    Only one window can be open at any given time

    B

    Consumer groups are associated with windows

    C

    Windows work with job classes to control resource allocation

    D

    The database service name must be provided during windows creation

    E

    Windows can automatically start job or change resource allocation among jobs for various time periods.


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

  • 第22题:

    单选题
    Which of the following phrases is TRUE regarding monitoring disk I/O with iostat?()
    A

     The iostat can only be run as the root user

    B

     There could be zero percent I/O wait and still be an I/O bottleneck

    C

     Any I/O wait time displayed in output of iostat is an indication of severe I/O bottlenecks 

    D

     Running iostat without any arguments/parameters is sufficient for resolving I/O bottlenecks


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

  • 第23题:

    多选题
    Which three statements correctly describe the features of the I/O calibration process?()
    A

    Only one I/O calibration process can run at a time

    B

    It automates the resource allocation for the Automated Maintenance Tasks

    C

    It improves the performance of the performance-critical sessions while running

    D

    It can be used to estimate the maximum number of I/Os and maximum latency time for the system

    E

    The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE


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