In MySQL, a VIEW is a virtual table that does not store any actual data on its own but instead is based on the result set of a SELECT query. It behaves like a regular table in many aspects, allowing users to query, insert, update, and delete data from it, depending on the permissions granted. However, the underlying data of a VIEW is derived dynamically from the tables or other views it references. Therefore, a VIEW is also known as a virtual table. Hence, Option D is the correct answer.
Discusssion
Login to discuss.