Answer-first summary for fast verification
Answer: DROP DATABASE retail CASCADE
The correct command is `DROP DATABASE retail CASCADE`. This command drops the specified database and all its tables, as the `CASCADE` option ensures that all associated tables and functions are also dropped. The `RESTRICT` option, which is the default, would prevent the dropping of a non-empty database. The other options listed are either incorrect or not standard SQL commands for this purpose.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is tasked with dropping the 'retail' database, including all its tables, under the condition that all tables within the database are managed tables. Which command should the engineer use to achieve this?
A
DROP DATABASE retail RESTRICT
B
DROP DATABASE retail INCLUDE ALL
C
DROP DATABASE retail CASCADE
D
DROP DATABASE retail
E
DROP DATABASE retail FORCE
No comments yet.