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) 

Get Real time Doubt solving from 8pm to 12 am!


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 - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.