多选题Which three statements correctly describe the features of the I/O calibration process?()AOnly one I/O calibration process can run at a timeBIt automates the resource allocation for the Automated Maintenance TasksCIt improves the performance of the performance-critical sessions while runningDIt can be used to estimate the maximum number of I/Os and maximum latency time for the systemEThe 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?()
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
参考解析
解析:
暂无解析
相关考题:
(c) Discuss the ways in which budgets and the budgeting process can be used to motivate managers toendeavour to meet the objectives of the company. Your answer should refer to:(i) setting targets for financial performance;(ii) participation in the budget-setting process. (12 marks)
View the exhibit and examine the output.Which statement can be an inference from the output?() A. The FRA disk group has an asynchronous I/O bottleneckB. The least number of I/Os are performed on the last data file in the listC. 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 listD. 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
View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:Which statement describes the consequence?()A. The command produces an error.B. The calibration process runs successfully and populates all the bind variables.C. The calibration process runs successfully but the latency time is not computed.D. The calibration process runs successfully but only the latency time is computed.Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles.
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 are true about windows? ()(Choose three.) A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. Windows can automatically start job or change resource allocation among jobs for various time periods.
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.
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、 CPUB、 MemoryC、 Disk I/OD、 Network I/O
Which of the following phrases is TRUE regarding monitoring disk I/O with iostat?()A、 The iostat can only be run as the root userB、 There could be zero percent I/O wait and still be an I/O bottleneckC、 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
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 GuideB、Power Systems data sheetC、Power Systems Facts and FeaturesD、Run FLRT to recommend I/O features
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.
Which statement can be an inference from the output?()A、The FRA disk group has an asynchronous I/O bottleneckB、The least number of I/Os are performed on the last data file in the listC、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 listD、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
Which three statements are true about windows? ()(Choose three.)A、Only one window can be open at any given timeB、Consumer groups are associated with windowsC、Windows work with job classes to control resource allocationD、The database service name must be provided during windows creationE、Windows can automatically start job or change resource allocation among jobs for various time periods.
Which three statements are true about windows?() A、 Only one window can be open at any given timeB、 Consumer groups are associated with windowsC、 Windows work with job classes to control resource allocationD、 The database service name must be provided during windows creationE、 Windows can automatically start job or change resource allocation among jobs for various time periods.
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
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 usageB、 degree of parallelismC、 number of open cursorsD、 number of sorts performedE、 idle time for blocking sessionsF、 number of disk I/O operations performedG、 number of memory I/O operations performed
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.
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 usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed
Which three statements correctly describe the features of the I/O calibration process?()A、 Only one I/O calibration process can run at a timeB、 It automates the resource allocation for the Automated Maintenance TasksC、 It improves the performance of the performance-critical sessions while runningD、 It can be used to estimate the maximum number of I/Os and maximum latency time for the systemE、 The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE
多选题Which three statements are true about windows?()AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during windows creationEWindows can automatically start job or change resource allocation among jobs for various time periods.
单选题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 CPUB MemoryC Disk I/OD Network I/O
多选题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? ()ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed
多选题Which three statements are true about windows? ()(Choose three.)AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during windows creationEWindows can automatically start job or change resource allocation among jobs for various time periods.
多选题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 performance-critical sessions while running.DIt can be used to estimate the maximum number of I/Os and maximum latency time for the system.EThe latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
多选题Which two statements are true with respect to the maintenance window?() .AA DBA can enable or disable an individual task in all maintenance windows.BA DBA cannot change the duration of the maintenance window after it is created.CIn case of a long maintenance window,all Automated Maintenance Tasks are restarted every four hours.DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
单选题Which of the following phrases is TRUE regarding monitoring disk I/O with iostat?()A The iostat can only be run as the root userB There could be zero percent I/O wait and still be an I/O bottleneckC 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
单选题Which statement can be an inference from the output?()AThe FRA disk group has an asynchronous I/O bottleneckBThe least number of I/Os are performed on the last data file in the listCThe 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 listDThe 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
多选题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?()ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed