In a relational database, a logical view ____.
A) is a physical duplicate of part of a table
B) is a physical duplicate of all of a table
C) is created with the SQL CREATE TABLE command
D) must be built over a single table, i.e. it cannot involve joined tables
E) None of the above.

Question

Quizplus · Accepted Answer

A logical view is a virtual table that does not actually exist in the database but is created on the fly when a user requests some specific data from the database. It is not a physical duplicate of any table or created with the CREATE TABLE command. Also, it can involve joined tables, as the purpose of a logical view is to provide a customized view of data from one or multiple tables.

In a Relational Database, a Logical View ____