Multiple choice database

What statement do you use to remove a schema and ensure that the removal takes place only if the schema is empty?

  1. DROP SCHEMA RESTRICT

  2. DROP SCHEMA OPTS

  3. DROP SCHEMA CASCADE

  4. DROP SCHEMA CLEAR
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The RESTRICT keyword in a DROP SCHEMA statement ensures that the schema is only deleted if it contains no objects. If the schema is not empty, the command will fail. In contrast, CASCADE would delete the schema and all objects within it automatically.

Keep practicing — related questions