Database Management Systems Set 4
What is allowed the input mark symbol # in Access?
(A) Letter or digit
(B) Letter A through Z
(C) A digit 0 - 9 with +/- sign
(D) A digit 0 - 9 without +/- sign
A digit 0 - 9 with +/- sign
Which validation rule allows exactly digits for number fields in Access?
(A) Is Null or Between 100000 and 99999
(B) Is Null or Like ??????
(C) Is Null or >= 0 AND< = 99999
(D) Is Null or < = 99999
Is Null or >= 0 AND< = 99999
What is the output when the data '1678.95' is set to the number format '###0.00' in
(A) 1670
(B) 1670.95
(C) 1678
(D) 1678.95
1678.95
Which of the following is a valid time format is Access?
(A) hh:mm:ss AM/PM
(B) hh.mm.ss AM/PM
(C) hh-mm-ss AM/PM
(D) hh/mm/ss AM/PM
hh:mm:ss AM/PM
Write the output when the data 'Primary Key' is set to the text < in Access?
(A) Primary key
(B) primary key
(C) PRIMARY KEY
(D) Primary Key
primary key