Oracle Database 12c: Installation and Administration — Question 144

Which statement is true about profiles?

Answer options

• A. Resource limits specified in a profile assigned to a user are always enabled.
• B. A user can exist without any profile.
• C. A profile can be assigned only to one user.
• D. Password management using profiles is always enabled.

Correct answer: D

Explanation

The correct answer is D because password management through profiles is a fundamental feature that is always enforced. Option A is incorrect as resource limits might not always be active depending on the user's assignment. Option B is wrong since users typically need profiles for permissions. Option C is false because a single profile can be assigned to multiple users.