Multiple choice database

What statement do you use to remove a schema and its related objects from your relational database?

  1. DROP SCHEMA CASCADE

  2. DROP SCHEMA RESTRICT

  3. DROP SCHEMA ALL

  4. DROP SCHEMA CLEAR

  5. DROP SCHEMA OPTS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The CASCADE option in a DROP SCHEMA statement instructs the database to remove the schema along with all of its contained objects (tables, views, etc.) in one operation. RESTRICT would prevent the deletion if any objects still existed within that schema.

Keep practicing — related questions