网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）
- A、Set a threshold for the default system-defined moving window baseline.
- B、Add directives to the Automatic Database Diagnostic Monitor (ADDM).
- C、Modify the profile for the targeted users for which control needs to be imposed.
- D、Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
参考答案
更多 “You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A、Set a threshold for the default system-defined moving window baseline.B、Add directives to the Automatic Database Diagnostic Monitor (ADDM).C、Modify the profile for the targeted users for which control needs to be imposed.D、Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.” 相关考题
考题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area (SGA)C. The tape buffer is allocated from the Program Global Area (PGA)D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes
考题
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 metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?()
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
考题
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A. Set a threshold for the default system-defined moving window baseline.B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).C. Modify the profile for the targeted users for which control needs to be imposed.D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
考题
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.
考题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?（）A. Set metric thresholdB. Implement Database Resource ManagerC. Enable resumable timeout for user sessionsD. Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?()
A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500MB of data transfer for queries, but not for data manipulation language (DML) operations.
考题
You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？ （）A、 The DBWn process writes to the datafile.B、 Changes in the background process are recorded.C、 The log file is updated with the current SCN number.D、 The System Change Number （SCN） is recorded in the control file.E、 The changes to the listener configuration in the listener.ora file are recorded.
考题
Which statement correctly describes network security settings in Cisco Network Assistant for the Catalyst Express 500 Switch？（）A、The LOW setting enables broadcast storm control， but has no effect on the number of devices that can connect to a switch portB、The LOW setting enables broadcast storm control and limits the number of devices that can connect to a switch port.C、The LOW setting disables broadcast storm control but limits the number of devices that can connect to a switch portD、The default network setting is "HIGH"
考题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）A、Set metric thresholdB、Implement Database Resource ManagerC、Enable resumable timeout for user sessionsD、Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
What network information do you need when you plan to implement a VLAN-based solution？（）A、default VLAN information for all unused switch portsB、802.1x configuration parameters C、number of IP subnets neededD、IP routing protocol information
考题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（） A、 The tape I/O performed is asynchronousB、 The tape buffer is allocated from the System Global Area （SGA）C、 The tape buffer is allocated from the Program Global Area （PGA）D、 Oracle I/O uses an interrupt mechanism to determine when each I/O completes
考题
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
考题
You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）A、Save the baseline in the databaseB、Save the baseline in the Database Control Home PageC、Create a procedure to read and apply the baseline to disk I/O metricsD、Apply the baseline to the disk I/O metrics in the Mange Metrics pageE、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd
考题
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）A、 Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB、 Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC、 Use compression when performing tape backupsD、 Configure multiple SBT channels
考题
When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）A、Thread number.B、Log Sequence number.C、Control file sequence number.D、Name of the last archived log.
考题
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
考题
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
考题
In which situation would you use the Oracle Shared Server configuration？（）A、when performing export and import using Oracle Data PumpB、when performing backup and recovery operations using Oracle Recovery ManagerC、when performing batch processing and bulk loading operation in a data warehouse environment D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
考题
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
考题
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）A、Use the Database Resource Manager.B、Set the limits in the profiles used by users.C、Modify the SESSIONS initialization parameter.D、Set the warning threshold for the Current Logons Count metric.
考题
The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）A、set the SESSIONS to 1 in the parameter fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
考题
多选题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.
考题
单选题You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A
Set a threshold for the default system-defined moving window baseline.B
Add directives to the Automatic Database Diagnostic Monitor (ADDM).C
Modify the profile for the targeted users for which control needs to be imposed.D
Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
考题
单选题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
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor (ADDM)
考题
单选题Which statement correctly describes network security settings in Cisco Network Assistant for the Catalyst Express 500 Switch？（）A
The LOW setting enables broadcast storm control， but has no effect on the number of devices that can connect to a switch portB
The LOW setting enables broadcast storm control and limits the number of devices that can connect to a switch port.C
The LOW setting disables broadcast storm control but limits the number of devices that can connect to a switch portD
The default network setting is HIGH
热门标签
最新试卷