Check sibling questions

This question asked in CBSE SQP-2021

Which of the following is a DDL command?

(A) SELECT

(B) ALTER

(C) INSERT

(D) UPDATE

 

Answer:

DDL(Data Definition Language) commands are used to create and modify the structure of a database and database objects.

DDL Command

Description

CREATE

Used to create databases and tables

ALTER

Used to add, delete or edit columns and remove or create constraints in a table

DESCRIBE

Used to view the structure of an already created table 

DROP

Used to permanently remove a database or a table from the system 

 

Checking the options

  • (A) SELECT - It is not a DDL command  
  • (B) ALTER - It is a DDL command
  • (C) INSERT - It is not a DDL command   
  • (D) UPDATE - It is not a DDL command  

 

So, the correct answer is (B) 

Are ads bothering you?


Transcript

This question asked in CBSE SQP-2021 Which of the following is a DDL command? (A) SELECT (B) ALTER (C) INSERT (D) UPDATE Answer: DDL(Data Definition Language) commands are used to create and modify the structure of a database and database objects. DDL Command Description CREATE Used to create databases and tables ALTER Used to add, delete or edit columns and remove or create constraints in a table DESCRIBE Used to view the structure of an already created table DROP Used to permanently remove a database or a table from the system Checking the options (A) SELECT - It is not a DDL command (B) ALTER - It is a DDL command (C) INSERT - It is not a DDL command (D) UPDATE - It is not a DDL command So, the correct answer is (B)

Davneet Singh's photo - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.