Multiple choice technology databases

What is a view?

  1. A view is a special stored procedure executed when certain event occurs

  2. A view is a database diagram

  3. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are

  4. All of above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A view is a virtual table created by storing a SELECT query rather than data itself. When you query a view, the database executes the underlying query dynamically. Views simplify complex queries, provide security by hiding columns, and ensure consistent data access but don't physically store data like regular tables.