Multiple choice technology programming languages

ORA-01017 ?

  1. Oracle not available (the database is down)

  2. Invalid Username/Password

  3. Snapshot too old (Rollback has been overwritten)

  4. Unique constraint violated
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ORA-01017 specifically means 'invalid username/password; logon denied' - Oracle cannot authenticate the credentials provided. This occurs when the username doesn't exist, the password is wrong, or the account is locked/expired. Option A would be ORA-03114 (not connected), Option C is ORA-01555 (snapshot too old), and Option D is ORA-00001 (unique constraint).

Keep practicing — related questions