The outcome of a SQL SELECT statement is a:

Question

Accepted Answer

The correct option is (2):
The SELECT statement is the fundamental command in Structured Query Language (SQL) used exclusively for querying and retrieving data from one or more tables in a relational database. Since the relational model organizes data into tables, structured as rows and columns, the most natural and accurate outcome of any successful SELECT query is logically another table. This output is technically known as the result set or result table, which is a dynamic collection of data records that satisfy the criteria specified in the query's clauses, such as WHERE and JOIN. This result set is independent of its source tables and represents a structured, tabular view of the requested information, which can then be further processed by an application.

The incorrect option is (1):
A File, in the context of a database, refers to the physical storage structure on a disk where the actual data and metadata are persistently saved by the Database Management System (DBMS). A table is a high-level logical abstraction, meaning it is how users and applications conceptually view the data, independent of the storage mechanism. The SELECT statement operates on the logical structure and returns the logical result set (a table), not the underlying raw physical data file where the information is physically stored.

The incorrect option is (3):
A Report is a final, formatted presentation of data, designed for optimal human readability, often including calculated summaries, groupings, and complex visual layouts. While a SELECT statement provides the raw, unformatted, tabular data, it is a separate application or reporting tool that must take the query's table-based result set and apply the necessary styling and business logic to generate a polished report. Therefore, a report is the *product* of processing the result set, not the result set itself.

The incorrect option is (4):
A Form is an interactive interface element used within a database application to facilitate the input, viewing, or modification of data, typically focusing on a single record or row at a time. It is a front-end tool designed for user interaction and data manipulation. The SELECT statement, conversely, is a back-end command that retrieves an entire collection of records (the table), which is structurally and functionally distinct from a single-record input/display form.