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

第1题：

In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）

• A、By assigning profiles for the users
• B、By implementing Fine-Grained Auditing （FGA）
• C、By granting a secure application role to the users
• D、By implementing the Database Resource Manager plan

第2题：

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）

第3题：

Using a policy with the policy-rematch flag enabled， what happens to the existing and newsessions when you change the policy action from permit to deny？（）

• A、The new sessions matching the policy are denied. The existing sessions are dropped.
• B、The new sessions matching the policy are denied. The existing sessions， not being allowed to carry any traffic， simply timeout.
• C、The new sessions matching the policy might be allowed through if they match another policy. The existing sessions are dropped.
• D、The new sessions matching the policy are denied. The existing sessions continue until they are completed or their timeout is reached.

第4题：

In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users：  1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME  2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME  3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER  4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME  How would you accomplish the above（）

• A、by assigning profiles for the users
• B、by implementing Fine-Grained Auditing （FGA）
• C、by granting a secure application role to the users
• D、by implementing the Database Resource Manager plan

第5题：

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

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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)

第14题：

Using a policy with the policy-rematch flag enabled, what happens to the existing and new sessions when you change the policy action from permit to deny?（）

• A、The new sessions matching the policy are denied. The existing sessions are dropped.
• B、The new sessions matching the policy are denied. The existingsessions, not being allowed tocarry any traffic, simply timeout.
• C、The new sessions matching the policy might be allowed through if they match another policy. The existing sessions are dropped.
• D、The new sessions matching the policy are denied. The existing sessions continue until they are completed or their time.

第15题：

You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future（）

• A、Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
• B、Use Database Resource Manager to automatically log out sessions that block others and are idle.
• C、Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
• D、Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction

第16题：

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.

第17题：

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.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：