DATABASE MANAGEMENT SYSTEMS - Quiz

1) What is allowed the input mark symbol # in Access?

Letter or digit Letter A through Z A digit 0 - 9 with +/- sign A digit 0 - 9 without +/- sign

2) Which validation rule allows exactly digits for number fields in Access?

Is Null or Between 100000 and 99999 Is Null or Like ?????? Is Null or >= 0 AND< = 99999 Is Null or < = 99999

3) What is the output when the data '1678.95' is set to the number format '###0.00' in

1670 1670.95 1678 1678.95

4) Which of the following is a valid time format is Access?

hh:mm:ss AM/PM hh.mm.ss AM/PM hh-mm-ss AM/PM hh/mm/ss AM/PM

5) Write the output when the data 'Primary Key' is set to the text < in Access?

Primary key primary key PRIMARY KEY Primary Key