Multiple choice technology databases

How can you prevent someone from using an all-numeric password?

  1. Set the initialization parameter PASSWORD_COMPLEXITY to ALPHANUM.

  2. Alter that user’s profile setting PASSWORD_COMPLEXITY to ALPHNANUM.

  3. Alter the user’s profile to use a password verify function that performs REGEX comparisons to validate the password.

  4. There is no mechanism that lets you prevent an all-numeric password
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle profiles don't have a PASSWORD_COMPLEXITY parameter. To enforce password rules like preventing all-numeric passwords, you must create a password verification function (PL/SQL) that uses REGEX to validate password format. This function is then assigned to the user's profile.

Keep practicing — related questions