Hyperion Drm Interview Questions and Answers - 2
Question: 6
What is an execution time limit?
Execution time limit is a type of resource allocation method. It can be set using the MAX_EST_EXEC_TIME parameter.
If this parameter is specified, Oracle estimates the execution time of the operation before starting the operation.
If the estimated time exceeds the parameter value, the operation is not started.
The default value for this parameter is null which indicates no estimated limit is imposed.
Question: 7
What is a resource plan?
A resource plan is used to define resources distribution among different consumer groups or other resource plans.
Resource plan prioritize the resource allocation through the use of 1 to 8 levels, in order of priority highest to lowest.
Question: 8
What is a resource plan directive?
Resource plan directive is the key element in creating complex resource plans. It assigns consumer groups to resource plans and defines the resource allocation for each.
It can also allocate resources to sub plans.
Question: 9
What is an undo pool allocation method?
It is a resource plan directive parameter, which controls the total amount of undo (in KB) that can be generated by a consumer group or sub plan.
It can be set using the UNDO_POOL parameter.
The default value for this parameter is null which indicates that no limit is imposed
Question: 10
How can you manage operating system resources from the database?
You can use Database Resource Manager (DRM) to manage operating system resources.
DC Generator Questions and Answers Pdf More
Electromagnetic Induction Quiz Questions and Answers More
Basic Electronics Quiz Questions with Answers Pdf More
Wireless Communication MCQ Questions with Answers More
Digital Communication Quiz Questions and Answers Pdf More
1000+ Floor Based Puzzle for Bank Exams More
Sentence Completion Exercises with Answers More
GA Questions asked in IBPS PO Mains 2024 | 2025 More
Latest 10,000+ Internet Quiz More
Computer Science Engineering Quiz Questions with Answers More