Database Fundamentals — Question 49

You need to enable a new employee to authenticate to your database.
Which command should you use?

Answer options

• A. ALLOW USER
• B. CREATE USER
• C. ADD USER
• D. INSERT USER
• E. ALTER USER

Correct answer: B

Explanation

The correct command to create a new user in a database is 'CREATE USER', which establishes a new authentication identity. The other options do not perform this function; 'ALLOW USER' and 'ADD USER' are not valid commands, while 'INSERT USER' implies adding data rather than creating a user, and 'ALTER USER' is for modifying existing users.