1. Identify the best data type to use to store the following data in Oracle, in SQL Server, and in Access:

a. The month, day, and year that an employee was hired

b. An employee's Social Security number

c. The department in which an employee works

d. An employee's hourly pay rate

2. Identify the following column name as valid or invalid in Oracle:

a. COMMISSIONRATE

b. POSTAL_CODE_5CHAR

c. SHIP TO ADDRESS

d. INVOICE-NUMBER