Multiple choice

Which statement creates a new user?

  1. CREATIVE USER susan;

  2. CREATIVE OR REPLACE USER susan;

  3. CREATE NEW USER susan DEFAULT

  4. CREATE USER sachin IDENTIFIED BY gupta;

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

The CREATE USER statement creates CREATE USER sqluser IDENTIFIED BY 'sqluserpw'.or each account, CREATE USER creates a new row in the mysql.user table and assigns the account no privileges.To assign a password, use IDENTIFIED BY with the literal plaintext password valu

Keep practicing — related questions