Which of the following commands is used to establish a user account?
A) CREATE NEW USER username IDENTIFIED BY password;
B) CREATE USERNAME username IDENTITY password;
C) CREATE USER username PASSWORD password;
D) CREATE USER username IDENTIFIED BY password;

Question

Which of the following commands is used to establish a user account?​
A) ​CREATE NEW USER username IDENTIFIED BY password;
B) ​CREATE USERNAME username IDENTITY password;
C) ​CREATE USER username PASSWORD password;
D) ​CREATE USER username IDENTIFIED BY password;

Quizplus · Accepted Answer

The correct syntax for creating a user account in most database management systems is "CREATE USER username IDENTIFIED BY password". Option D is the only choice that uses this correct syntax, so it is the best choice.

Which of the Following Commands Is Used to Establish a User