Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?
A.
It drops the connection after the specified number of login attempts fail for any user.
B.
It is enforced only if the password profile is enabled for the user.
C.
It locks the user account after the specified number of attempts.
D.
It drops the connection after the specified number of login attempts fail only for users who
have the SYSDBA privilege.
A is correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams212.htm
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. After the specified number of failure attempts, the connection will be automatically dropped by the server process.