Oracle Database 12c: Installation and Administration — Question 239

A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this? (Choose two.)

Answer options

• A. by alerting the appropriate user attributes with an ALTER USER command
• B. by using appropriate PASSWORD parameters set in the profile assigned to the user
• C. by implementing Database Resource Manager and assign it a profile for the user
• D. by implementing Database Resource Manager and assign it a role for the user
• E. by using appropriate KERNEL parameters set in the profile assigned to the user

Correct answer: A, D

Explanation

The correct answer is A and D. Option A allows you to modify user attributes directly, which is necessary for setting limits on login attempts and session idle time. Option D involves using Database Resource Manager to manage resources, which can enforce session limits. Options B, C, and E do not address all the required conditions effectively.