Vidyalelo
MySQL · Q102

MySQL

Programming · MySQL · question 102

Q102

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

Answer: Option D

Solution

Answer: Option D
Solution:
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.