Which of the following is not good primary key?
a) NIC number
b) order number
c) post code
d) student ID
How many primary keys can a table have?
a) One
b) At least one, but not more than two
c) Between 1 and 5
d) No limit
Which of the following should be primary key?
a) A persons last name
b) An employee salary
c) A customer`s ID number
d) A salesperson’s region
Which field listed below is the most appropriate primary key?
a) A person`s name
b) A person`s street address
c) A person`s birth date
d) A person social security number
How many types of users in database environments?
a) one
b) two
c) three
d) four
end user, data developer, data administrator
Checking that the person`s age between 0 and 150 is a…………
a) Range check
b) Numeric check
c) Consistency check
d) Completeness check
