Q39
Which of these is also known as a virtual table?
A.
SCHEMA
B.
DATABASE
C.
JOIN
D.
VIEW
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
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.