Multiple choice

In database theory, what is a virtual table called?

  1. Abstraction layer

  2. View

  3. Database engine

  4. Database trigger

  5. Relation
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A view is the result set of a stored query — or map-and-reduce functions — on the data, which the database users can query just as they would a persistent database collection object. This pre-established query command is kept in the database dictionary. Unlike ordinary base tables in a relational database, a view does not form part of the physical schema: as a result set, it is a virtual table computed or collated from data in the database, dynamically when access to that view is requested.

Keep practicing — related questions