1. A database consists of various components called:
a. Tools
b. Properties
c. Entities
d. Objects
2. Which of the following object of database is used to retrieve data from database?
a. Queries
b. Forms
c. Reports
d. Tables
3. The output of the query is in the form of a:
a. Table
b. Form
c. Report
d. Tables
4. Which object is used to retrieve data from database and present in formatted way?
a. Report
b. Form
c. Table
d. Query
5. Microsoft Access saves the database with the extension:
a. mdb
b. msdb
c. .madb
d. None
6. A report is a complete set of ………….field:
a. Distinct
b. Related
c. Designed
d. All
7. An MS Access table contains:
a. Records but no field’s
b. Fields but no records
c. Both records and fields
d. None of these.
8. Which option in MS Access is used to create a new database from scratch?
a. Access template
b. Blank Database
c. Existing Database
d. New Folder
9. What is displayed in Title bar of an open database?
a. Program name
b. Database name
c. Object type
d. All of these
10. Which of the following is NOT a database object?
a. Table
b. Query
c. Report
d. MS World
11. Which object is used to store data and define structure for the data in a database?
a. Table
b. Macro
c. Form
d. Query
12. Which of the following are objects in an MS Access database?
a. Tables, forms, queries, and reports
b. Database, Datasheet, and Form views
c. Folders
d. All of these
13. The columns of a table correspond to:
a. Table
b. Record
c. Field
d. Cell
14. A database may contain:
a. Only one table
b. At most two tables
c. At most three tables
d. None
15. An example of a query is:
a. Selection of all records that match a set of criteria.
b. Importing of a spreadsheet file into the database.
c. Search for a specific record.
d. Both a and c are correct
16. A report may be based on a:
a. Table
b. Query
c. Both a and b
d. None
17. Each separate piece of information stored in a record is called a(n):
a. Form
b. Field
c. Table
d. Cell
18. Each set of related items in a table is called:
a. Table
b. Record
c. Field
d. Query
19. The smallest meaningful unit of data in a database is called:
a. Byte.
B. Record
c. Character
d. Field
20. A collection of data that consists of name, address and email of a person is called
a. Byte.
b. Record
c. character
d. Field
21. Which of the following is the correct association?
a. File = column
b. Record = row
c. Field = row
d. Record = table
Answers:
