nerdexam
Oracle

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.

Administering User Security

Question

Examine these statements:

Which three are true about the effects of executing these statements? (Choose three.)

Exhibit

1Z0-062 question #383 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)
  • A
    10% (4)
  • B
    81% (34)
  • C
    2% (1)
  • D
    7% (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.

AThe HR account will get locked by Oracle after ten consecutive failed login attempts.

The HR account is configured to lock after three consecutive failed attempts, not ten, based on the specific `FAILED_LOGIN_ATTEMPTS` setting.

BUser HR is permitted to create more than three concurrent sessions.Correct

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.

CPassword complexity checking is enforced for user HR.

Password complexity checking is not enforced for the HR user because the `PASSWORD_VERIFY_FUNCTION` is explicitly set to NULL.

DUser HR sessions will terminate after ten minutes of continuous inactivity.

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.

EThe HR account will be locked after three consecutive failed login attempts.Correct

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.

FThe password complexity will not enforce on the HR account.Correct

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

#user profiles#password policies#account locking#session limits

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice