Which command will delete a user account from Oracle12c?
A) DELETE USER username;
B) DELETE USER username IDENTIFIED BY password;
C) DROP USER username IDENTIFIED BY password;
D) DROP USER username;

Question

Which command will delete a user account from Oracle12c?​
A) ​DELETE USER username;
B) ​DELETE USER username IDENTIFIED BY password;
C) ​DROP USER username IDENTIFIED BY password;
D) ​DROP USER username;

Quizplus · Accepted Answer

The correct syntax for deleting a user account from Oracle12c is to use the DROP USER command followed by the username. The IDENTIFIED BY password clause is not needed as it is used to specify a password for a new user. Therefore, option D is the best choice.

Which Command Will Delete a User Account from Oracle12c?​

Which Command Will Delete a User Account from Oracle12c?