What is a view in RDBMS?

Question

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

Answer 1

Views are faster than tables

Answer 2

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 3

Views stores data like a tables.

Answer 4

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

Answer 5

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.

Practice

Lessons

Playground

Test

What is a view in RDBMS?

Login

Register

What is a view in RDBMS?