Some Database Questions For Exams

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