Multiple choice technology web technology

Which statement creates a new user?

  1. CREATE USER Susan;

  2. CREATE OR REPLACE USER Susan;

  3. CREATE NEW USER Susan DEFAULT;

  4. CREATE USER Susan IDENTIFIED BY blue;

  5. CREATE NEW USER Susan IDENTIFIED by blue;

  6. CREATE OR REPLACE USER Susan IDENTIFIED BY blue;
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Option D shows the correct SQL syntax for creating a user with password authentication: CREATE USER username IDENTIFIED BY password. Options A and B are incomplete (no password). Options C, E, and F use invalid syntax (NEW/OR REPLACE don't apply to CREATE USER).

Keep practicing — related questions