DBMS Important Questions and Answers Set - 5
1. Different levels of access are assigned to personnel records in the health
and fitness gym . Only the system manager is able to create delete or edit
records . Certain other personnel are allowed to view allowed to view all the
records , whereas others are not permitted to view complete records . The
levels of access are controlled by
A. Password
B. User id’s
C. Status
D. None of the above
Ans- A. Password
2. You can switch back and forth between design and datasheet view by
clicking the
A. Queries object tab
B. Switch command on the view menu
C. View button
D. Select query title bar
Ans- C.View button
3. The table wizard
A. Quickly creates a default report
B. Displays a subset of the data in a database
C. Contains sample tables and fields you can use to create a table
D. Automatically edits your data as you enter it
Ans- D. Automatically edits your data as you enter it
4. The names , address and account balance of all of your customers . Select
the best fit for answer
A. Record
B. File
C. Database
D. Key field
Ans- D.Key field
5. An integrated collection of all of the data about your customers . Select the
best fit for answer
A. Record
B. File
C. Database
D. Key field
Ans- B. File
6. An identification field in a record . Select the best fit for answer
A. Record
B. File
C. Database
D. Key field
Ans- C. Database
7. What is part of database that holds all of the information about one item or
subject ?
A. Record
B. File
C. Query
D. Chart
Ans- A.Record
8. What is a stored question about information in a database ?
A. Record
B. Field
C. Report
D. Query
Ans- D.Query
9. RDBMS stands for
A. Relational database management system
B. Relation data module system
C. Right data base management system
D. None of the above
Ans- A.Relational database management system
10. Pack command is used to
A. Remove records permanently
B. Remove records temporarily
C. Restore records permanently
D. Restore records temporarily
Ans- A. Remove records permanently
