1Z0-062 · Question #383
Examine these statements: Which three are true about the effects of executing these statements? (Choose three.)
The correct answer is B. User HR is permitted to create more than three concurrent sessions. E. The HR account will be locked after three consecutive failed login attempts. F. The password complexity will not enforce on the HR account.. The provided statements configure the HR user's profile to lock the account after three failed login attempts, disable password complexity checking, and allow the user to create more than three concurrent sessions.
Question
Examine these statements:
Which three are true about the effects of executing these statements? (Choose three.)
Exhibit
Options
- AThe HR account will get locked by Oracle after ten consecutive failed login attempts.
- BUser HR is permitted to create more than three concurrent sessions.
- CPassword complexity checking is enforced for user HR.
- DUser HR sessions will terminate after ten minutes of continuous inactivity.
- EThe HR account will be locked after three consecutive failed login attempts.
- FThe password complexity will not enforce on the HR account.
How the community answered
(42 responses)- A10% (4)
- B81% (34)
- C2% (1)
- D7% (3)
Why each option
The provided statements configure the HR user's profile to lock the account after three failed login attempts, disable password complexity checking, and allow the user to create more than three concurrent sessions.
The HR account is configured to lock after three consecutive failed attempts, not ten, based on the specific `FAILED_LOGIN_ATTEMPTS` setting.
The settings for the HR user, either through a profile or direct alteration, specify that the user can create an unlimited number of sessions or a value greater than three, allowing more than three concurrent sessions.
Password complexity checking is not enforced for the HR user because the `PASSWORD_VERIFY_FUNCTION` is explicitly set to NULL.
Unless explicitly configured with an `IDLE_TIME` limit of ten minutes, user sessions would not terminate after this period, as the default `IDLE_TIME` is unlimited.
The `FAILED_LOGIN_ATTEMPTS` parameter for the HR account, likely set in its assigned profile, is configured to 3, resulting in the account being locked after three consecutive failed login attempts.
The `PASSWORD_VERIFY_FUNCTION` parameter for the HR account's profile is set to NULL, which explicitly disables and prevents the enforcement of password complexity rules for that user.
Concept tested: Oracle user profile management and security parameters
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PROFILE.html
Topics
Community Discussion
No community discussion yet for this question.
