1Z0-062 · Question #354
Which statement is true regarding the DEFAULT profile?
The correct answer is A. The values assigned to the resource limits and password parameters in the default profile can. The DEFAULT profile in an Oracle database allows administrators to configure and modify its resource limits and password parameters.
Question
Which statement is true regarding the DEFAULT profile?
Options
- AThe values assigned to the resource limits and password parameters in the default profile can
- BA different DEFAULT profile can be created before each user in a database.
- CIt can be dropped and recreated.
- Dit must be explicitly assigned to the user.
How the community answered
(45 responses)- A89% (40)
- B7% (3)
- C2% (1)
- D2% (1)
Why each option
The `DEFAULT` profile in an Oracle database allows administrators to configure and modify its resource limits and password parameters.
The `DEFAULT` profile is a standard Oracle database profile whose assigned resource limits (e.g., CPU, sessions) and password parameters (e.g., password lifetime, complexity) can be altered using the `ALTER PROFILE DEFAULT ...` command. This flexibility allows administrators to enforce specific security and resource management policies for users implicitly assigned to this profile.
Only one `DEFAULT` profile can exist in an Oracle database; you cannot create multiple `DEFAULT` profiles.
The `DEFAULT` profile cannot be dropped because it is a mandatory system profile that is implicitly assigned to all users not explicitly assigned another profile.
The `DEFAULT` profile is implicitly assigned to users if no other profile is explicitly specified, so it does not need to be explicitly assigned to a user.
Concept tested: Oracle DEFAULT profile characteristics
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PROFILE.html#GUID-BEE3B200-9118-4903-875F-BFD87F25D185
Topics
Community Discussion
No community discussion yet for this question.