Question 1

In a database table we need to represent a quantity for a particular item in our inventory (ie, how many do we have "on hand"

A)int

B)float

C)varchar(4) (0000-9999)

D)char

Question 2

We collect names for our customers and we'd like to ensure we have their "title" (Dr. Matthew Ganis - where "Dr." is a title)

A)int

b)varchar(10)

C)varchar(3)

D)varchar(50)

Question 3

Birthday. Say "December 23, 1991"

A)varchar(17)

B)date

C)int (calculate the number of days since a specific starting point)

D)No answer text provided.

Question 4

We need to keep track of the number of pets in the household

A)smallint

B)bit

C)int

D)tinyint

Question 5

we need to track if the customer is "over 18"

A)tinyint

B)int

C)char(1) "y" or "n"

D)bit