Question 6 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query Language

Last updated at April 16, 2024 by

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) 

Go Ad-free

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 14 years. He provides courses for Maths, Science and Computer Science at Teachoo