nerdexam
Oracle

1Z0-060 · Question #75

You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user…

The correct answer is C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS. SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication attempts that can be made by a client on a connection to the server process. These login attempts can be for multiple user accounts in the same connection. After the specified number of failure attempts, the…

New Features for Security

Question

You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

Options

  • Aby granting a secure application role to the users
  • Bby creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter
  • CBy creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS
  • DBy Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE
  • EBy implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS

How the community answered

(38 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    71% (27)
  • D
    3% (1)
  • E
    16% (6)

Explanation

SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication attempts that can be made by a client on a connection to the server process. These login attempts can be for multiple user accounts in the same connection. After the specified number of failure attempts, the connection will be automatically dropped by the server process.

Topics

#user profile#failed login attempts#password expiry#resource limits

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice