Question

What is a view?

(a) An brief description of the schema diagram.

(b) A relation that is not a part of the schema but is a virtual relation

(c) Any relation that is a part of the schema

(d) A relation that is a part of the schema but which needs to be specified in every operation made on that particular relation.

The question was posed to me in an online interview.

This intriguing question originated from Views and Transactions topic in portion Intermediate and Advanced Sql of RDBMS

Answer 1

Correct option is (b) A relation that is not a part of the schema but is a virtual relation

Explanation: A relation that is not a part of the schema but is a virtual relation is called as view. Views improve writability as viewing the entire logical model is not feasible.