Which of the following SQL statements will remove user RTHOMAS from the database?
A) DELETE rthomas;
B) DELETE USER rthomas;
C) DROP USER rthomas;
D) DROP rthomas;

Question

Which of the following SQL statements will remove user RTHOMAS from the database?​
A) ​DELETE rthomas;
B) ​DELETE USER rthomas;
C) ​DROP USER rthomas;
D) ​DROP rthomas;

Quizplus · Accepted Answer

The correct SQL statement to remove a user from a database is DROP USER followed by the username, in this case, rthomas. Therefore, the correct statement is DROP USER rthomas. The other options are incorrect as they either do not specify that the command is for deleting a user or use incorrect syntax.

Which of the Following SQL Statements Will Remove User RTHOMAS