What is a view in MySQL?
- A A stored result set that is refreshed nightly
- B A named virtual table defined by a stored query
- C A backup copy of a table
- D A graphical interface to the database
Answer
A named virtual table defined by a stored query
A view stores the query, not the data, and is evaluated when referenced. MySQL does not support materialised views natively.





