Oracle Database 11g: Administration I — Question 9

Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.
✑ PASSWORD_REUSE_MAX IS 5
✑ PASSWORD_REUSE_TIME IS 10
✑ PASSWORD_GARCE_TIME IS 15
Which two conditions must be met for USER1 to reuse oracle_4U? (Choose two.)

Answer options

• A. At least 10 days must have passed since oracle_4U was last used
• B. The password must have changed 5 times since oracle_4U was last used
• C. At least 15 days must have passed since oracle_4U was last used
• D. At least 5 days must have passed since oracle_4U was last used
• E. The password must have changed 10 times since oracle_4U was last used

Correct answer: C, E

Explanation

For USER1 to reuse the password oracle_4U, at least 15 days must have passed since its last use, as indicated by the PASSWORD_REUSE_TIME setting. Additionally, the PASSWORD_REUSE_MAX value requires that the password must have changed 10 times since its last use, which is why option E is also correct. The other options do not meet the specified criteria.