Multiple choice technology databases

Which of the following prevents a user from reusing a password when they change their password?

  1. Setting the initialization parameter NO_PASSWORD_REUSE to TRUE

  2. Altering that user’s profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_REUSE_MAX

  3. Altering that user’s profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

  4. Using a password verify function to record the new password and compare the new passwords to those recorded previously

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To prevent password reuse, set PASSWORD_REUSE_TIME to UNLIMITED and PASSWORD_REUSE_MAX to 1. This combination ensures a password can never be reused. Setting both to UNLIMITED allows immediate reuse. Option A mentions a non-existent parameter. Password verify functions validate complexity, not reuse history.