A user establishes a connection to a database instance by using an Oracle Net.
You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
Which two would you do to implement this?
A.
by alerting the appropriate user attributes with an ALTER USER command
B.
by using appropriate PASSWORD parameters set in the profile assigned to the user
C.
by implementing Database Resource Manager and assign it a profile for the user
D.
by implementing Database Resource Manager and assign it a role for the user
E.
by using appropriate KERNEL parameters set in the profile assigned to the user
I would suggest B and E because you can accomplish all 4 resource limit restrictions by changing the PASSWORD and the KERNEL parameters set in the profile assigned to the user. LOGICAL_READS_PER_CALL and SESSIONS_PER_USER are examples of KERNEL parameters in a profile.