DBMS Important Questions and Answers Set - 7
21. This DBMS feature allows users to easily interrogate a database. Select
the best fit for answer
A. Data base management approach
B. DBMS uses
C. Database administrator
D. Query language
Ans- C.Database administrator
22. The ……… presents data in a way similar to an excel spreadsheet
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Ans- C.Print preview
23. It is used to build and modify database objects and also to create new
queries
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Ans- C.Print preview
24. It shows the appearance and layout of a report , table or form in order to
confirm what will be printed .
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Ans- B.Design view
25. It examines a small portion or sample of your data in a report before printing it .
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview
Ans- D. Layout preview
26. A report form
A. Appears on the computer monitor during data entry
B. Is used during report generation to format data
C. Both A and B
D. All of the above
Ans- B. Is used during report generation to format data
27. Which of the following columns can not be found in the macro design
window ?
A. Arguments column
B. Comment column
C. Conditions column
D. Actions column
Ans - B. Comment column
28. The ascending order of data hierarchy ios:
A. Bit , byte , field , record , file . database
B. Bit , byte , record , field , file , database
C. Byte , bit , field , record , file , database
D. Byte , bit , record , field , file , record
Ans- D. Byte , bit , record , field , file , record
29. A good query system
A. Can accept English language commands
B. Allows non - programmers to access information stored in a database
C. Can be accessed only by data pressing professionals
D. Both A and B
Ans- B. Allows non - programmers to access information stored in a database
30. How do you freeze a field a column or field in Microsoft Access ?
A. Click anywhere in the column and select Edit > freeze column from the
menu
B. Place an ice cube in the column
C. Click anywhere in the column and click the freeze button on the toolbar
D. Right click the column and select freeze columns from the shortcut menu
Ans- D.Right click the column and select freeze columns from the
shortcut menu
