Question

What is the use of “VIEW” in Mysql?

(a) To hide columns from the users

(b) To hide the complexity of the database

(c) To simplify complexity of database design

(d) All of the mentioned

The question was posed to me by my school principal while I was bunking the class.

My doubt stems from The from Clauses in portion Select Statement of MySQL

Answer 1

Right answer is (d) All of the mentioned

For explanation I would say: None.