Oracle OCP 1Z0-050（34题）解析

Oracle OCP 1Z0-050（34题）解析

QUESTION 34:

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

解析：

参考Oracle官方文档：

https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams226.htm#REFRN10274

SEC_MAX_FAILED_LOGIN_ATTEMPTS

Property	Description
Parameter type	Integer
Default value	10
Modifiable	No
Range of values	1 or higher. In this context, "higher" means any integer value higher than 1, not the string "higher."
Basic	No

 

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.