Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous