What is a view in RDBMS?

Question

Select all correct facts about SQL Views from the options below:

Answer 1

A view acts as a virtual table with columns and rows, but it does not itself store data. It defines a pre-written query that retrieves data from the underlying tables.

Answer 2

Views stores data like a tables.

Answer 3

Views can be used to restrict access to certain data in underlying tables. You can grant permissions on views instead of base tables.

Answer 4

The view simplifies complex queries by hiding the complexity of joining multiple tables or applying filters. Users can query the view as if it were a regular table.

Answer 5

Views are faster than tables