12th class (Fsc) computer unit 5 MCQs
chapter 5 MCQs 12th Class computer
Introduction to Microsoft access:
1. Microsoft access saves the database with the extension:
a. madb
b. .mdb
c. .msdb
d. None of them
2. Which shortcut key is used to open an existing database in MS Access?
a. Ctrl + O
b. Ctrl + N
c. Ctrl + Z
d. Ctrl + S
3. It makes very simple to create a database:
a. Common standard
b. Sample database
c. Easier programming
d. Wizard
4. MS Access saves the database with the extension:
a. .ppt
b. .mbdq
c. .mdb
d. .msdb
5. A set of related files created and managed by a DBMS is called:
a. Database
b. Field
c. Module
d. Record
6. The example of popular DBMS is:
a. MS Excel
b. MS Word
c. MS PowerPoint
d. MS Access
7. In relational dabase, a table is called:
a. Field
b. Tuple
c. Schema
d. Relation
8. It is simple to create database using:
a. Cardinality
b. Attribute
c. Modality
d. Relationship
9. Which option in MS Access is used to create a new database from scratch?
a. Existing database
b. Access template
c. New folder
d. Blank database
10. What is displayed in Title bar of an open database?
a. Object type
b. Program name
c. Database name
d. All of these
11. A database consists of various components called the:
a. Entities
b. Tool
c. Object
d. Properties
12. Which of the following object of database is used to retrieve data from database?
a. Reports
b. Queries
c. Tables
d. Forms
13. The output of a query is in the form of a:
a. Report
b. Table
c. Query
d. Form
14. Which of the following object is used to retrieve data from database and present in a formatted away?
a. Table
b. Report
c. Query
d. Form
15. A record is a complete set of ……… field.
a. Designed
b. Distinct
c. All of them
d. Related
16. In access, the structure of a table is created in ……… view.
a. Design view
b. Datasheet view
c. Both A & B
d. None of them
17. Which object is the output of a database application?
a. Table
b. Form
c. Report
d. Query
18. A database consists of various components called:
a. Entities
b. Tools
c. Objects
d. Properties
19. Which object is used to store data in database?
a. Form
b. Macro
c. Report
d. Table
20. The output of the query is in the form of:
a. Report
b. Table
c. Query
d. Form
21. A request for information form a database in database terminology is called:
a. Table
b. Report
c. Query
d. Letter
22. Which of the following is not a database object?
a. Report
b. Table
c. MS Word
d. Query
23. The graphical query tool is known as:
a. Query form
b. Query grid
c. Design form
d. Design grid
24. The maximum number of tables in a database are:
a. 3
b. 1
c. Many
d. 2
25. An MS Access table contains:
a. Both records and fields
b. Records but no fields
c. Fields but no records
d. None of these