Hyperion Drm Interview Questions and Answers - 1
What is DRM?
DRM offers a component based approach to resource allocation management.
It allows you to create resource plans, which specify resource allocation to various consumer groups. You can group users based on the resource requirement.
DRM offers an easy to use and flexible system by defining distinct independent components.
What are the components or elements of DRM?
The three main components or elements of DRM are given as follows:
Resource consumer groups
Resource plan directives
What is a resource allocation method?
This parameter is used to define the method used to allocate database resource.
There can be many different resource allocation methods, such as CPU method, idle time, and active session pool.
These are also called parameters to resource plan directive.
List some of the benefits of DRM?
Following are the benefits of the DRM:
Enables you to limit the length of time a user session can stay idle and automatically terminates long running SQL statements and user sessions.
Sets the initial login priorities for various consumer groups
Uses the concept of active session pool to specify the maximum number of concurrent active sessions for a consumer group.
The database resource manager will automatically queue all the subsequent requests until the currently running sessions complete.
What is a sub plan?
A resource sub plan is a plan, which gets the resource to allocate from a higher level plan.
It is created in a similar manner as a plan. However, a top level plan gets to allocate 100% of the resource while a sub plan can allocate only the resources allocated to it by the top level plan.
Top 1000+ Bank Exams Question Papers with Answers Pdf More
1000+ SBI Computer Awareness Study Material More
Top 1000+ Preposition Questions for SSC Exams More
Preposition Quiz Questions and Answers for Bank Exams More
Computer Awareness Questions Asked in IBPS RRB PO Mains 2021-2022 More
Java Servlet Interview Questions for Freshers Pdf More
100+ Reasoning Word Formation Questions for Bank Exams More
TNPSC Group 1, 2, 2a, 4 Indian Geography Gk Quiz Questions & Answers More
C# Tutorials for Beginners Pdf | Methods, Operator Interview Questions More
Multimedia Quiz Questions and Answers Pdf More