Humanities/Arts Exam  >  Humanities/Arts Questions  >  Which among the following SQL commands does n... Start Learning for Free
Which among the following SQL commands does not fall under the category of data manipulation language?
  • a)
    DELETE
  • b)
    SELECT
  • c)
    UPDATE
  • d)
    CREATE
Correct answer is option 'D'. Can you explain this answer?
Most Upvoted Answer
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.
Free Test
Community Answer
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.
Explore Courses for Humanities/Arts exam

Top Courses for Humanities/Arts

Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer?
Question Description
Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? for Humanities/Arts 2024 is part of Humanities/Arts preparation. The Question and answers have been prepared according to the Humanities/Arts exam syllabus. Information about Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? covers all topics & solutions for Humanities/Arts 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer?.
Solutions for Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Humanities/Arts. Download more important topics, notes, lectures and mock test series for Humanities/Arts Exam by signing up for free.
Here you can find the meaning of Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer?, a detailed solution for Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? has been provided alongside types of Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Which among the following SQL commands does not fall under the category of data manipulation language?a)DELETEb)SELECTc)UPDATEd)CREATECorrect answer is option 'D'. Can you explain this answer? tests, examples and also practice Humanities/Arts tests.
Explore Courses for Humanities/Arts exam

Top Courses for Humanities/Arts

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev