UNIT 3

Question 1

All changes in the table structure are made by using the ________ command

Answer 1

ALTER TABLE

Question 2

The ALTER TABLE command can also be used to add table constraints

Answer 2

ADD

Question 3

You could also use the ALTER TABLE command to remove a column or table constraint.

Answer 3

DROP

Question 4

You can alter an existing table by adding one or more columns.

Answer 4

Adding Column

Question 5

We can change a column definition as long as there is either no data or the existing column fits into the new column definition.

Answer 5

Altering/Changing a Column

Question 6

Occasionally, you might want to modify a table by deleting a column.

Answer 6

Dropping a Column

Question 7

A table can be deleted from the database using the DROP TABLE command.

Answer 7

Deleting Table from Database

Question 8

The ORDER BY clause is especially useful when the listing order is important to you.

Answer 8

ORDER BY

Question 9

SQL’s DISTINCT clause produces a list of only those values that are different from one another.

Answer 9

DISTINCT