Multiple choice technology programming languages

Which of the following options will allow you to drop the user david and all objects in the schema that are associated with that user?

  1. DROP USER david all

  2. DROP USER david schema

  3. DROP USER david cascade

  4. DROP USER david cascade schema
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The CASCADE option in DROP USER (DROP USER david CASCADE) removes the user and all objects owned by that user. Without CASCADE, the command would fail if the user owned any database objects. CASCADE ensures clean removal by automatically dropping dependent objects.

Keep practicing — related questions