112.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.
Answer: A
答案解析：
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams226.htm#REFRN10274
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.