You work as a Database Administrator for Blue-Well Inc. The company uses an Oracle database. The database contains a resource consumer group named QUERY_USERS. You want to specify the maximum number of active sessions allowed in the QUERY_USERS resource consumer group as twenty. Which of the following Database Resource Manager parameters will you use to accomplish this?

Answer: C

Explanation: Answer option C is correct. The ACTIVE_SESS_POOL_P1 parameter is used to specify the maximum number of active sessions that are allowed in a resource consumer group. D and A are incorrect. There is no such parameter as ACTIVE_SESS_P1 or ACTIVE_SESSION_QUEUE in Oracle B is incorrect. The PARALLEL_DEGREE_LIMIT parameter specifies the degree of parallelism allowed for a query.