SQL Views are also known as:

Question

Accepted Answer

The correct option is (2):
A view in SQL is precisely known as a **Virtual Table** because, unlike a standard or base table, it does not physically store its own set of data on the disk. Instead, a view is a stored query definition (a `SELECT` statement) that exists only in the database's data dictionary. When a user queries a view, the underlying query is executed dynamically, and the resulting dataset is generated in real-time, making it appear to the user exactly like a traditional table. The term 'virtual' is perfect because it conveys that the view is a logical window or custom-tailored perspective on the data, not a permanent, physical container of that data. Views are invaluable for enforcing security, simplifying complex multi-table joins, and customizing the data presentation for different classes of users.

The incorrect option is (1):
The classification of a view as a "Simple Table" is inaccurate and too restrictive. While some views, known as simple views, are derived from a single table and do not use joins or aggregate functions, this is not the definition of a view as a whole. Many views, referred to as complex views, involve multiple tables, intricate joins, and aggregation logic to serve their purpose. More importantly, calling it a "table" fails to distinguish a view from a base table, fundamentally ignoring the crucial fact that a view is a non-physical, dynamic construct.

The incorrect option is (3):
The term "Complex Tables" is not the correct technical or conceptual name for a view in a database system. Although a view's definition can incorporate complexity to hide it from the user, the resulting object itself is still a **virtual** structure. The primary role of a view is to present a simpler, cleaner interface for the users. Therefore, referring to the view as a "table" is fundamentally flawed because it suggests physical data storage, and the descriptive term "complex" misses the point that the view's value lies in its abstraction of complexity.

The incorrect option is (4):
A view is explicitly *not* an "Actual Table." The phrase "Actual Table" is synonymous with a base table or physical table, which is the primary object in the database that stores data persistently and physically on the storage device. A view is defined by the data contained in one or more Actual Tables; it is a derivative entity that holds no data itself, only the definition required to retrieve it. Thus, using the term "Actual Tables" for a view is incorrect because it is the antithesis of a view's nature as a logical, non-materialized structure.