OCP 1Z0 052 161

161. In your database instance, the user sessions are connected to the database server from the remote 
machines. You want to achieve the following for these users: 
1: The user account must be locked after four unsuccessful login attempts. 
2: The user must be prompted to change the password at regular intervals. 
3: The user may not have more than three simultaneous sessions. 
4: The user session must automatically be logged off if more than 10 minutes elapsed time used.  
How would you accomplish the above? 
A.by assigning profiles for the users 
B.by implementing Fine-Grained Auditing (FGA) 
C.by granting a secure application role to the users 
D.by implementing the Database Resource Manager plan 
Answer: A

SQL> SELECT resource_name, resource_type, LIMIT  2    FROM dba_profiles  3   WHERE profile = 'DEFAULT';RESOURCE_NAME                    RESOURCE_TYPE LIMIT-------------------------------- ------------- ----------------------------------------COMPOSITE_LIMIT                  KERNEL        UNLIMITEDSESSIONS_PER_USER                KERNEL        UNLIMITEDCPU_PER_SESSION                  KERNEL        UNLIMITEDCPU_PER_CALL                     KERNEL        UNLIMITEDLOGICAL_READS_PER_SESSION        KERNEL        UNLIMITEDLOGICAL_READS_PER_CALL           KERNEL        UNLIMITEDIDLE_TIME                        KERNEL        UNLIMITEDCONNECT_TIME                     KERNEL        UNLIMITEDPRIVATE_SGA                      KERNEL        UNLIMITEDFAILED_LOGIN_ATTEMPTS            PASSWORD      10PASSWORD_LIFE_TIME               PASSWORD      180PASSWORD_REUSE_TIME              PASSWORD      UNLIMITEDPASSWORD_REUSE_MAX               PASSWORD      UNLIMITEDPASSWORD_VERIFY_FUNCTION         PASSWORD      NULLPASSWORD_LOCK_TIME               PASSWORD      1PASSWORD_GRACE_TIME              PASSWORD      716 rows selected