Which of these is also known as a virtual table?
A. SCHEMA
B. DATABASE
C. JOIN
D. VIEW
Answer: Option D
Solution(By Examveda Team)
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.Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion