Question

In today's digitized world with a need to store data electronically, it is very important to store the data in the databases. SQL is used to interact with the Database Management System.

I. Classify the following commands according to their type :(DDL/DML)

(i) INSERT INTO

(ii) ALTER TABLE

II. Which clause would you use with Select to achieve the following:

(i) To select the values that match with any value in a list of specified values.

(ii) Used to display unrepeated values of a column from a table.

III. Chhavi has created a table named Orders, she has been asked to increase the value of a column named salesamount by 20. She has written the following query for the same' Alter table Orders Add salesamount =  salesamount+20;

Is it the correct query? Justify.

Answer 1

I.

(i) INSERT INTO : DML command

(ii) ALTERTABLE: DDL command

II.

(i) IN

(ii) Distinct

III.

No, Alter command is used to make changes to the structure of the table, but Chhavi has to make changes in the data stored in the table. Hence, she should write the following query: Update Orders set salesamount = salesamount + 20;