Multiple choice technology databases

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

The correct syntax for creating a user in Oracle is CREATE USER username IDENTIFIED BY password. Option D shows this exact syntax. Options A and B are incomplete (missing IDENTIFIED BY clause). Options C and E incorrectly use CREATE NEW USER which is not valid Oracle syntax. Option F incorrectly uses CREATE OR REPLACE USER which is not a valid command for users (that syntax applies to objects like views or procedures).

Keep practicing — related questions