Which of the following statements is/are correct with respect to "VIEW"?
A. "VIEW" is a query that stored in the data dictionary
B. There is no data associated with "VIEW"
C. "VIEW" creates virtual tables in Database
D. All of the mentioned
Answer: Option D
Solution (By Examveda Team)
In the world of databases, a VIEW is like a special window into your data. It's not a table itself, but a saved query that lets you see data in a specific way.Let's break down the options:
Option A: "VIEW" is a query that stored in the data dictionary
This is TRUE. The data dictionary holds all the definitions about your database, and a VIEW is essentially a saved query stored within it.
Option B: There is no data associated with "VIEW"
This is TRUE as well. A VIEW doesn't store data itself. It just provides a customized way to access data from real tables.
Option C: "VIEW" creates virtual tables in Database
This is also TRUE. You can think of a VIEW as a temporary, virtual table that presents data based on your query.
Option D: All of the mentioned
Since options A, B, and C are all correct, option D is also TRUE.
So, the answer is Option D.
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