1Z0-040 Oracle Database 10g: New Features for Administrators
Note 2: 1Z0-040 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 4.
Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (choose three)
A. SWITCH_TIME
B. SWITCH_GROUP
C. MAX_SESS_POOL
D. SWITCH_ESTIMATE
Display Answer
Purchase Full Version:
1Z0-040 Printable PDF Prep Guide $49.95 BUY NOW!
1Z0-040 Test Simulation Engine $69.95 BUY NOW!
1Z0-040 PDF & Test Simulation Engine $99.95 BUY NOW!
Answer: A,B,D
The SWITCH_CONSUMMER_GROUP_FOR_SESS causes the specified session to
immediately be moved into the specified resource consumer group. In effect, this
statement can raise or lower priority.
SWITCH_GROUP : Specifies consumer group to which this session is switched if other
switch criteria are met. If the group name is 'CANCEL_SQL', then the current call will be
canceled when other switch criteria are met. If the group name is 'KILL_SESSION', then
the session will be killed when other switch criteria are met. Default is NULL.
SWITCH_TIME : Specifies time (in seconds) that a session can execute before an
action is taken. Default in UNLIMITED. You cannot specify both SWITCH_TIME and
SWITCH_TIME_IN_CALL.
SWITCH_ESTIMATE : If TRUE, tells the database to use its execution time estimate
to automatically switch the
consumer group of an operation prior to beginning its execution. Default is FALSE.
REF. : Oracle(r) 10g Administrator Guide, 24-17
Explanation:
- Based on the latest 1Z0-040 exam objectives!
- Designed like actual 1Z0-040 exam questions!
- 100% Verified Realistic 1Z0-040 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation 1Z0-040 Questions Included!
- Constantly Updated Guide to Reflect the Current 1Z0-040 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
England
Demark
London, UK
Keyword
