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

第1题：

第2题：

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 port
• B、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 port
• D、The default network setting is "HIGH"

第3题：

What network information do you need when you plan to implement a VLAN-based solution？（）

• A、default VLAN information for all unused switch ports
• B、802.1x configuration parameters 
• C、number of IP subnets needed
• D、IP routing protocol information

第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

第5题：

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 FALSE
• B、 Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
• C、 Use compression when performing tape backups
• D、 Configure multiple SBT channels

第6题：

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.

第7题：

In which situation would you use the Oracle Shared Server configuration？（）

• A、when performing export and import using Oracle Data Pump
• B、when performing backup and recovery operations using Oracle Recovery Manager
• C、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

第8题：

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.

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

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 threshold
• B、Implement Database Resource Manager
• C、Enable resumable timeout for user sessions
• D、Add directives to Automatic Database Diagnostic Monitor (ADDM)

第15题：

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 asynchronous
• B、 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

第16题：

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 database
• B、Save the baseline in the Database Control Home Page
• C、Create a procedure to read and apply the baseline to disk I/O metrics
• D、Apply the baseline to the disk I/O metrics in the Mange Metrics page
• E、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

第17题：

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

第18题：

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

第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

第20题：

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 file
• B、grant SINGLE SESSION privilege to all of the users
• C、set the SESSIONS_PER_USER to 1 in the users’ profile
• D、grant RESTRICTED SESSION privilege to all of the database users
• E、create a role with SINGLE SESSION privilege and assign the role to the users

第21题：

第22题：

第23题：

第24题：