The INSERT INTO .. VALUES option will insert rows into the _________ of a table.

While you are inserting values into a table with the INSERT INTO .. VALUES option, does the order of the columns in the INSERT statement have to be the same as the order of the columns in the table?

While you are inserting values into a table with the INSERT INTO .. SELECT option, does the order of the columns in the INSERT statement have to be the same as the order of the columns in the table?

When would you use an INSERT INTO .. SELECT option versus an INSERT INTO .. VALUES option? Give an example of each.

What does the UPDATE command do?

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

Will SQL Server allow you to reduce the size of a column?

What integer data types are available in SQL Server ?

What is the default value of an integer data type in SQL Server ?

What decimal data types are available in SQL Server ?

What is the difference between a CHAR and a VARCHAR datatype?

Does Server SQL treat CHAR as a variable-length or fixed-length column? Do other SQL implementations treat it in the same way?

If you are going to have too many nulls in a column, what would be the best data type to use?

When columns are added to existing tables, what do they initially contain?

What command would you use to add a column to a table in SQL Server?

In SQL Server, which data type is used to store large object data types?

If I do not need to store decimal places, what would be a good numeric data type to use?

If I need to store decimal places, but am not worried about rounding errors, what would be a good data type to use?

Should a column be defined as a FLOAT if it is going to be used as a primary key?