（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.

答案：（A）

解析：

SEC_MAX_FAILED_LOGIN_ATTEMPTS,指定了客户端连接到服务器进程的最大尝试次数,

在失败了指定的次数后,连接会被服务器进程自动删除. SQL*Plus登录不受此参数的影响。

ITPub博客

Oracle 11G OCP 1Z0-053 112