Which among the following SQL commands does not fall under the categor...
CREATE command is a data definition language command but not a data manipulation command. Data manipulation command is used to manipulate the data of those tables that are created by Data definition languages.
Which among the following SQL commands does not fall under the categor...
Explanation:
The correct answer is option 'D' - CREATE.
Data Manipulation Language (DML):
Data Manipulation Language (DML) is a subset of SQL commands that are used to manipulate data stored in the database. The primary purpose of DML is to retrieve, insert, update, and delete data in the database tables.
SQL Commands:
SQL (Structured Query Language) is the standard language for interacting with relational databases. It consists of various commands that can be categorized into different types based on their functionality. The three main categories of SQL commands are:
1. Data Definition Language (DDL): DDL commands are used to define the structure of the database. They include commands like CREATE, ALTER, and DROP.
2. Data Manipulation Language (DML): DML commands are used to manipulate the data stored in the database. They include commands like SELECT, INSERT, UPDATE, and DELETE.
3. Data Control Language (DCL): DCL commands are used to control the access and permissions of the database objects. They include commands like GRANT and REVOKE.
Explanation of Options:
a) DELETE: DELETE is a DML command used to delete one or more rows from a table.
b) SELECT: SELECT is a DML command used to retrieve data from one or more tables in the database.
c) UPDATE: UPDATE is a DML command used to modify the existing data in one or more rows of a table.
d) CREATE: CREATE is a DDL command used to create new database objects like tables, indexes, views, etc. It is not considered a part of DML as it does not manipulate the data stored in the tables.
Conclusion:
Among the given options, the CREATE command does not fall under the category of Data Manipulation Language (DML) as it is a Data Definition Language (DDL) command used to create database objects. The other options (DELETE, SELECT, and UPDATE) are all DML commands used to manipulate data in the database.
To make sure you are not studying endlessly, EduRev has designed Humanities/Arts study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Humanities/Arts.