Explanation:
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.
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.