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.
DI Pie Chart Questions and Answers for Bank Exams More
100+ Area Aptitude Questions and Answers Pdf More
100+ Data Interpretation Pie Chart Questions and Answers More
True Discount Questions and Answers for Bank Exams More
100+ HCF and LCM Questions and Answers for SSC Exams More
TNPSC Group 2 Question Bank with Answers Free Download More
Top 1000+ Verbal Reasoning Questions for Bank Exams More
100+ Free online Mock Test for IBPS PO, SO, Clerk Prelims More
TRB Model Question Papers with Answer in Economics More
TNPSC Group 2 Mains Question Paper with Answers in Tamil & English More