Multiple choice technology databases

In databases, a view is which of the following?

  1. A virtual table that can be accessed via SQL commands

  2. A virtual table that cannot be accessed via SQL commands

  3. There is no difference between a view and a table

  4. None of these

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

A database view is a virtual table representing the result of a pre-defined SQL query. It does not store data physically but can be queried using standard SQL commands just like a normal table. Distractors are incorrect because views can be accessed via SQL, unlike tables which physically store data.