........... SQL command allows to make queries on the database.

Question

Accepted Answer

The correct option is (1):
The SELECT command is the fundamental and most frequently used SQL statement, and it belongs to the category known as Data Query Language (DQL). Its primary and sole purpose is to retrieve, or "query," data from one or more tables in a relational database. When a user or application needs to inspect the current state of the data—whether to find a single value, a list of records, or aggregated results—the SELECT statement is employed. By using clauses like WHERE for filtering and ORDER BY for sorting, SELECT allows for highly customized and effective information retrieval, making it the definitive command for making queries on the database.

The incorrect option is (2):
The CREATE command is a Data Definition Language (DDL) command, meaning its role is to define, or build, new objects within the database schema. For example, a database administrator uses CREATE TABLE to construct a new table structure, CREATE DATABASE to establish a new database instance, or CREATE VIEW to define a virtual table. Its function is purely structural and definitional; it defines *where* data can be stored, but it has no capability to retrieve or query the data that is already present in the database.

The incorrect option is (3):
The DROP command is another command within the Data Definition Language (DDL). Its purpose is highly destructive, as it is used to completely eliminate or remove database objects, such as an entire table, an index, or a database itself. This action permanently deletes the object's definition and all associated data, which is the opposite of querying. While it operates on the database structure, it is not used to look up or retrieve data.

The incorrect option is (4):
The DELETE command is a Data Manipulation Language (DML) command. Its function is to modify the database content by removing *rows* of data from a table. This is a modification operation, not an inquiry or retrieval operation. Although it works with the data stored in a table, its purpose is to change the content (by removing records), not to display or query the existing information for the user.