VIEWS

📝 VIEWS

Total Questions: 4
Click an answer to select it, then click "Check Answers" to see your results.

Question 1

What is the primary function of a **view** in SQL?

A) To act as a virtual table from a saved SELECT query

**Explanation:** Views function like virtual tables created from SELECT queries, allowing reuse without storing data separately.

B) To physically store data from multiple tables

C) To permanently delete rows from a base table

D) To create indexes on frequently queried columns

Question 2

How does a **view** ensure data security compared to direct table access?

A) By encrypting all columns in the view

B) By restricting access to only defined columns and rows

**Explanation:** Views limit users to specific columns and rows defined in the view, preventing full access to the underlying table.

C) By automatically backing up the base table data

D) By requiring a password for every query

Question 3

A **complex view** is best defined as a view that

A. References only one base table

B. Limits access to individual rows only

C. Stores data physically like a table

D. Joins multiple tables and uses **GROUP BY** with aggregates

Explanation: Complex views involve multi-table joins, **GROUP BY**, and aggregate functions like **SUM()** and **COUNT()** to create summary data.

Question 4

What distinguishes a **materialized view** from a regular view?

A. It executes the query only once during creation

Explanation: **Materialized views** store query results physically, providing faster access for infrequently changing data.

B. It always uses **NATURAL JOIN** exclusively

C. It requires frequent data updates

D. It simplifies single-table queries

Quiz Complete!

Score: 0 / 4