Vidyalelo
MySQL · Q1066

MySQL

Programming · MySQL · question 1066

Q1066

A view can be deleted using the command . . . . . . . .

A.
REMOVE
B.
DELETE
C.
CLEAR
D.
DROP
Answer

Answer: 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