Class 12: SQL Question Set 2

16.
Using which keyword of Alter table command we can modify the data definition of any data in an existing table?

a) Change
b) Modify
c) update
d) None

 

17.
Which keyword of Alter table command is used to change the name of any column of an existing table?

a) Change
b) Modify
c) Drop
d) Clear

 

18.
To remove or delete a column from an existing table we use

a) remove
b) Drop
c) Delete
d) Clear

 

19.
To delete an entire table from the database we use

a) Delete Table
b) Drop Table
c) Remove Table
d) None

 

20.
By defualt Order by clause lists the results in ______ order.

a) Descending
b) Any
c) Ascending
d) Same