Q1066
A view can be deleted using the command . . . . . . . .
A.
REMOVE
B.
DELETE
C.
CLEAR
D.
DROP
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
This question asks about how to remove a view in MySQL. A view is like a saved query that gives you a specific way to look at data in your database. Think of it like a shortcut or a special lens. To delete a view, you use the DROP command.
Here's why the other options are incorrect:
* REMOVE is not a valid command in MySQL for deleting views.
* DELETE is used for deleting data from tables, not views.
* CLEAR is used to clear the contents of tables, not for removing views.
So the answer is D: DROP