SQLtest.online

Question

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

Answer 1

Views are faster than tables

Answer 2

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

Answer 3

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 4

Views stores data like a 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.

SQLtest.online

Practice

Lessons

Test

Login

Register