Q1173
What cannot be done on a view?
A.
display
B.
filter
C.
index
AnswerD.
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.