PS Exam

  • Full Screen
  • Wide Screen
  • Narrow Screen
  • Increase font size
  • Default font size
  • Decrease font size

Database Management System Multiple Choice Questions And Answers

E-mail Print PDF

MS Access is one of the popular database management system and PSC includes it as an important chapter in its syllabus. I have already published some multiple choice questions (MCQ), but, because of the new version of MS Office package and the update in PSC syllabus, we need to learn and prepare with Microsoft Access 2007 and 2010. Thus here are some questions and answers from Access database management system.

Multiple Choice Questions from Database Management System

 

1. Mechanism developed to enforce users to enter data in required format is:
a. Data validation
b. Input mask
c. Criteria
d. Data verification
 
2. The raw facts and figures are:
a. Data
b. Information
c. Snapshot
d. Reports
 
3. The feature that database allows to access only certain records in database is:
a. Forms
b. Reports
c. Queries
d. Tables
 
4. Which filter method lets you filter the records that match the selected field?
a. Filter by form
b. Filter by selection
c. Auto filter
d. Advanced filter
 
5. Which filter method lets you filter records based on criterion you specify?
a. Filter by form
b. Filter by selection
c. Auto filter
d. Advanced filter
 
6. You can find Sort & Filter group of commands in
a. Home ribbon
b. Create ribbon
c. Database tools ribbon
d. Fields ribbon
 
7. Which of the following filter method is not available in Access?
a. Filter by selection
b. Filter by form
c. Advanced filter
d. None of above
 
8. By Grouped Report you understand
a. Type of report generated by the Report Wizard
b. Type of report that present records sorted in ascending or descending order as you specify
c. Type of report that displays data grouped by fields you specified
d. None of above
 
9. The text you typed in Description column  in Table Design View is displayed on
a. Description bar in forms
b. Report Footer when printed
c. Title bar of MS Access while entering data
d. Status bar while entering data
 
10. What is the maximum allowed field size for Boolean (Yes/No) fields?
a. 1
b. 8
c. 50
d. 255
 
11. What is the size of Data & Time field type?
a. 1
b. 8
c. 255
d. 50
 
12. Which of the following field type can store maximum data?
a. Yes/No fields
b. Date/Time fields
c. Text fields
d. Memo fields
 
13. To display associated record from related table in datasheet view, you can
a. Double click the record
b. Apply filter by form command
c. Single click on expand indicator (+) next to the record
d. Double click on expand indicator (+) next to the record
 
14. Arrange according to the size
a. Record, field, byte, bit
b. Bit, field, byte, record
c. Field, byte, record, bit
d. Byte, bit, record, field
 
15. What type of relationship exists between a Student table and Fees table?
a. One to one
b. One to many
c. Many to many
d. One to many and many to many
 
16. Identify the relationship between a Movie table and Stars table:
a. One to one
b. One to many
c. Many to many
d. None of above
 
17. What type of relationship exists between a Teacher table and Class table?
a. One to many
b. Many to many
c. One to one
d. Two to two
 
18. Which of following relationship type is not possible to realize in Access Database directly?
a. One to one
b. One to many
c. Many to many
d. None of above
 
19. For which kind of relationship you need a junction table to reflect real world situation?
a. One to one
b. One to many
c. Many to many
d. None of above
 
20. What do you need if you should enforce many-to-many relationship between two tables?
a. Parent table
b. Child table
c. Junction table
d. Many-to-many relationship can't be created in database
 
21. You can display data from multiple tables by using
a. Page break
b. Sub form
c. Columnar form
d. Tabular form
 
22. What is the best data type for a field that stores mobile numbers?
a. Text
b. Number
c. Date/Time
d. Memo
 
23. What field type is best to store serial numbers?
a. Number
b. AutoNumber
c. Text
d. Memo
 
24. Which of the following field type is used to store photograph of employees?
a. Memo
b. Picture
c. OLE
d. Photo
 
25. Which of the following method can be used to add more tables in a database?
a. Design View
b. Table Wizard
c. By Entering Data
d. All of above
 
26. From which version Microsoft introduced Backstage View for Access Interface?
a. Access 2003
b. Access 2007
c. Access 2010
d. Access does not have Backstage View
 
27. You can display Backstage View by clicking on
a. File menu
b. Home tab
c. Control box
d. Quick Access Toolbar
 
28. Why do you pin an item in list?
a. To mark it to delete from list
b. To move it up and make it always available
c. To make it default database when you open Access
d. None of above
 
29. The options like Save, Open Database, Print are available in
a. Home tab
b. Backstage View tab
c. File menu
d. Database Tools tab
 
30. What is relational database?
a. A place to store relational information
b. A database that is related to other databases
c. A database to store human relations
d. None of above
 
31. The advantage of computerized database over manual database is
a. We can get the information our quick
b. We can put in information quick
c. Solve the repeated information and consistency problem
d. All of above
 
32. Circular button with Office icon in it is
a. Control box
b. Office box
c. Company box
d. Control menu box
 
33. Group names in ribbon can be helpful to
a. Group the commands so that when you move one, you can move all of them together
b. Give a name for buttons on ribbon
c. Find the required option by inspecting through them
d. All of above
 
34. The options like Relationship, SQL Server etc. are found in
a. External data tab
b. Database tools tab
c. Create tab
d. Home tab
 
35. Navigation pane is placed on
a. The left of Access workspace
b. The right of Access workspace
c. Just below the Access workspace
d. Just above the status bar
 
36. You can filter the display of different Access objects in navigation pane from
a. View tab in ribbon
b. Drop down menu at the top of navigation pane
c. Sort & Filter group in Home menu
d. Database tab
 

Answers to Multiple Choice Questions

1.         Mechanism developed to enforce users to enter data in required format is:
b. Input mask
 
2.         The raw facts and figures are:
a. Data
 
3.         The feature that database allows to access only certain records in database is:
c. Queries
 
4.         Which filter method lets you filter the records that match the selected field?
b. Filter by selection
 
5.         Which filter method lets you filter records based on criterion you specify?
a. Filter by form
 
6.         You can find Sort & Filter group of commands in
a. Home ribbon
 
7.         Which of the following filter method is not available in Access?
c. Advanced filter
 
8.         By Grouped Report you understand
c. Type of report that displays data grouped by fields you specified
 
9.         The text you typed in Description column  in Table Design View is displayed on
d. Status bar while entering data
 
10.     What is the maximum allowed field size for Boolean (Yes/No) fields?
a. 1
 
11.     What is the size of Data & Time field type?
b. 8
 
12.     Which of the following field type can store maximum data?
d. Memo fields
 
13.     To display associated record from related table in datasheet view, you can
c. Single click on expand indicator (+) next to the record
 
14.     Arrange according to the size
a. Record, field, byte, bit
 
15.     What type of relationship exists between a Student table and Fees table?
b. One to many
 
16.     Identify the relationship between a Movie table and Stars table:
c. Many to many
 
17.     What type of relationship exists between a Teacher table and Class table?
b. Many to many
 
18.     Which of following relationship type is not possible to realize in Access Database directly?
c. Many to many
 
19.     For which kind of relationship you need a junction table to reflect real world situation?
c. Many to many
 
20.     What do you need if you should enforce many-to-many relationship between two tables?
c. Junction table
 
21.     You can display data from multiple tables by using
b. Sub form
 
22.     What is the best data type for a field that stores mobile numbers?
a. Text
 
23.     What field type is best to store serial numbers?
b. AutoNumber
 
24.     Which of the following field type is used to store photograph of employees?
c. OLE
 
25.     Which of the following method can be used to add more tables in a database?
d. All of above
 
26.     From which version Microsoft introduced Backstage View for Access Interface?
b. Access 2007
 
27.     You can display Backstage View by clicking on
a. File menu
 
28.     Why do you pin an item in list?
b. To move it up and make it always available
 
29.     The options like Save, Open Database, Print are available in
c. File menu
 
30.     What is relational database?
a. A place to store relational information
 
31.     The advantage of computerized database over manual database is
d. All of above
 
32.     Circular button with Office icon in it is
b. Office box
 
33.     Group names in ribbon can be helpful to
c. Find the required option by inspecting through them
 
34.     The options like Relationship, SQL Server etc. are found in
b. Database tools tab
 
35.     Navigation pane is placed on
a. The left of Access workspace
 
36.     You can filter the display of different Access objects in navigation pane from
b. Drop down menu at the top of navigation pane

 

Subscribe

Wish to get contents in your Email?

Enter your email address:

Who's Online

We have 39 guests online

Sharing Enriches!

You are here: MCQ Bank MS-Access Database Management System Multiple Choice Questions And Answers