Views are not updatable.
A. True
B. False
Answer: Option B
Solution (By Examveda Team)
This question is about Views in MySQL.A View is like a saved query that acts as a virtual table. It doesn't store actual data but instead displays data from one or more real tables.
The question asks if Views are updatable. This means can you directly change data within the View like you can in a real table.
The answer is Option B: False
While Views are not real tables, they can sometimes be updated. However, it depends on how the view is defined.
For example, if the view is created using simple SELECT statements and doesn't involve complex functions or aggregations, it can be updated.
But, if the view involves things like `GROUP BY`, `DISTINCT`, or other complex functions, it can't be updated directly.
So, while not all views are updatable, some can be.
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