DBMS Important Questions and Answers Set - 14
11. Auto forms allows you to
A. View a subset of your data
B. Create a simple report
C. create a data entry form
D. Enter records
Ans- B. Create a simple report
12. The asterisk (*) is sometimes used in database queries . This character is
then called a
A. Wildcard
B. Dummy
C. Ditto
D. All of the above
Ans- A.Wildcard
13. When performing a look -up operation using a form
A. You enter the search value into the form
B. You look at each form sequentially until you see the one you want
C. You type the key in an entry line , and the correct form is displayed
D. All of the above
Ans-D. All of the above
14. Which custom date format displays the numeric day of the year when a
date is entered ?
A. YY
B. YYYY
C. Y
D. All of the above
Ans- C. Y
15. When you save an Access project , what file format do you use ?
A. .adp
B. .xm. C. .mdb
D. All of the above
Ans- A. .adp
16. Which of the following criterion would find records whose personality field does not equal “Nice” ?
A. <> Nice
B. NOT Nice
C. <>”Nice” D. IS NOT Nice
Ans- C. <>”Nice”
17. What is the maximum character filed size you can set for a field that has
a text data type ?
A. 64
B. 255
C. 512
D. All of the above
Ans-B. 255
18. Which of the following fields would not make a suitable primary key ?
A. A data field
B. An invoice number
C. An auto number field
D. A customer’s social security number
Ans- A. A data field
19. Auto reports can contain each of the following elements except
A. A detail section
B. A page footer
C. A group header
D. All of the above
Ans- D. A detail section
20. What is the abbreviation used for a software package that permits the
user to create , retrieve and maintain records in a database ?
A. DASD
B. FMS
C. EMMS
D. DBMS
Ans- D. DBMS
