DBMS Important Questions and Answers Set - 9
1. A group of characters used to identify a given low level instruction is
A. File
B. Record
C. Key field
D. Label
Ans-D. Label
2. One or more characters used to identify a data field in a computer program
is
A. File name
B. Database
C. Label
D. Group
Ans- C.Label
3. In form view , which command displays records alphabetically ?
A. Find
B. Advanced filter / Sort
C. Sort
D. All of the above
Ans- C.Sort
4. Where do report and forms get their information form ?
A. Forms
B. Modules
C. Tables
D. Queries
Ans- C. Tables
5. The number of logical records in a physical record is
A. Group
B. Blocking factor
C. Sector
D. Field
Ans- D. Field
6. A top to bottom relationship among the items in a database is established
by a
A. Hierarchical schema
B. Network schema
C. Relational schema
D. All of the above
Ans- A.Hierarchical schema
7. A command that lets you change one or more fields in a record is
A. Insert
B. Modify
C. Look up
D. All of the above
Ans- B.Modify
8. A logical schema
A. Is the entire database
B. Is a standard way or organizing information into accessible parts
C. Describes how data is actually stored on disk
D. All of the above
Ans- B.Is a standard way or organizing information into accessible parts
9. What is the purpose of the page field on a pivot table report ?
A. It creates a new page for a each type of data
B. It allow the data within the pivot table report to be filtered
C. It displays a title for the pivot table report
D. None of the above
Ans- B. It allow the data within the pivot table report to be filtered
10. What does the special effect button on the formatting toolbar do ?
A. It lets you to add animation to your forms and reports to make them more
entertaining and amusing
B. It lets you select a transitional effect for how a form opens and closes
C. It applies a 3d effect to a selected control
D. None of the these
Ans- C. It applies a 3d effect to a selected control
