Unit 3

Question 1

All changes in the table structure are made by using the _______command, followed by a keyword that produces the specific change you want to make

Answer 1

Alter Table

Question 2

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

Answer 2

Adding Column

Question 3

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

Answer 3

Changing a Column

Question 4

modify a table by deleting a column

Answer 4

Dropping a Column

Question 5

clause is especially useful when the listing order is important to you

Answer 5

Order By

Question 6

produces a list of only those values that are different from one another.

Answer 6

Distinct