In SQL terminology a _______ is a single table that is derived from other tables.

Question

Accepted Answer

The correct option is (2):
A View is a virtual table whose content is defined by a stored SQL query that may reference one or more other tables or views. This is why it is accurately described as a single table *derived* from other tables; it is not a physical structure that stores data. Instead, a view is a logical abstraction that presents the result set of its underlying query whenever it is called. This mechanism allows database designers to simplify complex joins and calculations, customize the data visible to different users, and enforce a layer of security without granting direct access to the source tables. The View dynamically generates its rows and columns based on the most current data in the base tables from which it is derived.

The incorrect option is (1):
A Table is the fundamental, physical object in a database used to store actual, permanent data in rows and columns. Unlike a view, a table is not derived from other structures; it is the original container that holds the data. Data manipulation language (DML) commands like INSERT, UPDATE, and DELETE directly operate on tables to physically alter the stored records. Therefore, a table serves as the base data source, not an entity derived from other tables.

The incorrect option is (3):
A Base Table is a term used to explicitly denote a standard, persistent table in the database that physically holds the data. It is often used to contrast with a derived structure, such as a view. Since a base table is the independent source of data that exists on its own, it cannot be defined as a table that is *derived* from other tables. It is the primary component from which all other derived objects, like views, draw their data.

The incorrect option is (4):
A Form is a user interface element within a database management system (or an application) that is used for convenient viewing, entering, and modifying of data. It is an end-user tool focused on presentation and data interaction, not a relational object in the database schema itself. While a form is connected to a table or view to manage data, the form itself is not considered an SQL-level table derived from others.