Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  Which of the following is not a DDL command?a... Start Learning for Free
Which of the following is not a DDL command?
  • a)
    TRUNCATE
  • b)
    ALTER
  • c)
    CREATE
  • d)
    UPDATE
Correct answer is option 'D'. Can you explain this answer?
Most Upvoted Answer
Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd...
Explanation:
DDL stands for Data Definition Language, which is a set of SQL commands used to create, modify, and delete database structures. These commands are used to define the database schema, including tables, views, indexes, and constraints. DDL commands are not used to manipulate or modify data within the tables.

DDL Commands:
1. CREATE: The CREATE command is used to create a new database object, such as a table, view, or index. It is used to define the structure of the object and any associated constraints.

2. ALTER: The ALTER command is used to modify the structure of an existing database object. It can be used to add or remove columns, change data types, modify constraints, or rename objects.

3. TRUNCATE: The TRUNCATE command is used to remove all data from a table, while keeping the structure intact. It is similar to the DELETE command, but it is faster because it does not generate any transaction logs.

4. UPDATE: The UPDATE command is used to modify the data within a table. It is used to change the values of one or more columns in one or more rows.

Reason for D not being a DDL command:
The UPDATE command is used to modify the data within a table, which makes it a Data Manipulation Language (DML) command, not a Data Definition Language (DDL) command. DML commands are used to manipulate data within the tables, while DDL commands are used to define the structure of the database objects.

Conclusion:
In summary, the DDL commands are used to create, modify, and delete database structures, while the DML commands are used to manipulate data within the tables. The UPDATE command is an example of a DML command, not a DDL command.
Free Test
Community Answer
Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd...
DDL commands are used to define the structure of the database, table, schemas, etc. It enables us to perform the operations like CREATE, DROP, ALTER, RENAME, and TRUNCATE schema objects.
An UPDATE command is used for managing the data stored in a database. It is an example of a DML command that also includes the INSERT and DELETE commands.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer?
Question Description
Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer?.
Solutions for Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer?, a detailed solution for Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? has been provided alongside types of Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Which of the following is not a DDL command?a)TRUNCATEb)ALTERc)CREATEd)UPDATECorrect answer is option 'D'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

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