1Z0-062 · Question #318
Which statement is true about profiles?
The correct answer is D. Password management using profiles is always enabled. In Oracle Database, password management features defined within a profile, such as password expiry and complexity, are always active for users assigned that profile.
Question
Which statement is true about profiles?
Options
- AResource limits specified in a profile assigned to a user are always enabled.
- BA user can exist without any profile.
- CA profile can be assigned only to one user.
- DPassword management using profiles is always enabled.
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- D93% (27)
Why each option
In Oracle Database, password management features defined within a profile, such as password expiry and complexity, are always active for users assigned that profile.
Resource limits specified in a profile are only enabled if the RESOURCE_LIMIT parameter is set to TRUE at the database level using ALTER SYSTEM.
Every user in an Oracle database must be assigned a profile; if not explicitly assigned, the DEFAULT profile is automatically used.
A profile can be assigned to multiple users, allowing administrators to efficiently manage resource limits and password policies for groups of users.
Password management features (e.g., PASSWORD_LIFE_TIME, PASSWORD_GRACE_TIME, PASSWORD_VERIFY_FUNCTION) defined within a profile are always enforced for users associated with that profile, provided the feature is configured. This is a core function of profiles to enhance database security by default.
Concept tested: Oracle database profiles and password management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-security-for-oracle-database.html#GUID-C3398D5E-CE4B-4813-A337-E773FEE5B348
Topics
Community Discussion
No community discussion yet for this question.