CBSE Class 12 Informatics Practices Question 65 of 79

MySQL SQL Revision Tour — Question 8

Back to all questions
8
Question

Question 8

Which of the following is a DDL command ?

  1. SELECT
  2. ALTER
  3. INSERT
  4. UPDATE
Answer

ALTER

Reason — DDL (Data Definition Language) commands in SQL are used to create and define tables and other database objects. Examples of DDL commands include ALTER, which is used to modify objects like tables, indexes, views, and constraints. On the other hand, SELECT, INSERT, and UPDATE commands are part of DML (Data Manipulation Language), used for retrieving, inserting, and updating data within the database.