In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:
Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)
A. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
B. These users can never reuse a password
C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX
D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile
CORRECT ANSWERS: BD
B answer is correct according to this reference:
https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310
PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX: “If you specify a value for either of these parameters and specify UNLIMITED for the other, then the user can never reuse a password”
D answer is correct according to this reference:
https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310
DEFAULT: Any user who is not explicitly assigned a profile is subject to the limits defined in the DEFAULT profile. Also, if the profile that is explicitly assigned to a user omits limits for some resources or specifies DEFAULT for some limits, then the user is subject to the limits on those resources defined by the DEFAULT profile.
CORRECT ANSWERS: BD
B is correct according to this reference: https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310
PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX: “If you specify a value for either of these parameters and specify UNLIMITED for the other, then the user can never reuse a password.”
D is correct according to this reference: https://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310
Any user who is not explicitly assigned a profile is subject to the limits defined in the DEFAULT profile. Also, if the profile that is explicitly assigned to a user omits limits for some resources or specifies DEFAULT for some limits, then the user is subject to the limits on those resources defined by the DEFAULT profile.