SQL Quiz: What is a view in SQL?

Task 154:

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

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

Views stores data like a tables.

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.

Views are faster than tables

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.

Mark all correct answers and click the "Check!" button

Login

Register