Vidyalelo
MySQL · Q1173

MySQL

Programming · MySQL · question 1173

Q1173

What cannot be done on a view?

A.
display
B.
filter
C.
index
Answer
D.
drop

Answer: Option C

Solution

Answer: Option C
Solution:
This question is about views in MySQL. A view is like a saved query that lets you see data from one or more tables in a specific way. Think of it as a shortcut or a custom view of your data.

Now, let's look at the options:

Option A: display - You can definitely display data from a view, that's what it's meant for!
Option B: filter - Views can be used to filter data, showing only the information you want.
Option C: index - This is the trick! You cannot create an index directly on a view. Indexes help speed up data retrieval, but they are created on tables, not views.
Option D: drop - You can definitely drop a view if you no longer need it.

So the answer is Option C: index.