Exam 1z0-062 topic 1 question 87 discussion

but C only satisfies 1 requirement

Answer: C

ALTER ROLE role_name PROFILE 4_requirement;

Not C: 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. we need to apply on an user attemp not a client attemp.

A seems onnly viable option. The SEC_MAX_FAILED_LOGIN_ATTEMPTS is not a profile parameter option.

Please refer to Question 2 in https://www.examtopics.com/exams/oracle/1z0-062/view/. It is similar question and answer was assigning profile. So, I will go for C.

I think C

Answer should be A Because: You can design your applications to automatically grant a role to the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package that contains multiple procedures). The procedure validates the user: if the user fails the validation, then the user cannot log in. If the user passes the validation, then the procedure grants the user a role so that he orshe can use the application. The user has this role only as long as he or she is logged in to the application. When the user logs out, the role is revoked. Incorrect: Not B: REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter. Not C, not E: 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. Not D: REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.

Correct answer is C, not A