You can get 2nd Year Computer Chapter 5 MCQs with Answers on this page. Tackle MCQs to test your core concepts from Chapter 5 (Introduction to Microsoft Access) and confidently prepare for your exams! All the correct answers have been bolded.
12th Class Chapter 5 Computer Science MCQS
Here is the 12th computer science chapter 5 mcqs with answers:
1. Which of the following is a relational database management system?
a. Microsoft Access
b. Microsoft Word
c. Microsoft Excel
d. Microsoft PowerPoint
2. In MS Access, it is elementary to create a database using:
a. Query
b. Wizard
c. Toolbar
d.Report
3. MS Access table contains:
a. Fields
b. Records
c. Characters
d. All
4. 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
5. Microsoft Access saves the database with the extension:
a. .mdb
b. .msdb
c. .madb
d. .mxis
6. What is displayed in the title bar of an open database?
a. Program name
b. Database name
c. Object type
d. All of these
7. A database consists of various components called:
a. Tools
b. Properties
c. Entities
d. Objects
8. Which database objects are used to retrieve data from the database?
a. Queries
b. Forms
c. Reports
d. Tables
9. The output of the query is in the form of a:
a. Table
b. Form
c. Report
d. Query
10. Which object is used to retrieve data from the database and present it in a formatted way?
a. Report
b. Form
c. Table
d. Query
11. Which of the following is NOT a database object?
a. Table
b. Query
c. Report
d. Macro
12. Which object is used to store data and define a database data structure?
a. Table
b. Macro
c. Form
d. Query
13. The _________in MS Access organizes all of the objects in the database.
a. Database Window
b. Status Bar
c. Database Wizard
d. Title Bar
14. A is used to perform the same sequence of steps or automate tasks repeatedly.
a. Reports
b. Pages
c. Macro
d. Micros
15. A contains an object that stores VBA code to create database applications using MS Access.
a. Module
b. Function
c. Database Wizard
d. Procedure
16. The columns of a table correspond to:
a. Table
b. Record
c. Field
d. Cell
17. The maximum number of tables in a database can be:
a.1
b. 2
c. 3
d. Any
18. A report may be based on a:
a. Table
b. Query
c. a or b
d. Macro
19. Each separate piece of information stored in a record is called:
a. Form
b. Field
c. Table
d. Cell
20. Each set of related items in a table is called:
a. Table
b. Record
c. Field
d. Query
21. A record is a complete set of ______fields.
a. Distinct
b. Related
c. Designed
d. Al
22. The smallest meaningful unit of data in a database is called:
a. Byte
b. Record
c. Character
d. Field
23. A collection of data that consists of the name, address, and email of a person is called:
a. Byte
b. Record
c. Character
d. Field
24. Which of the following is the correct association?
a. File = column
b. Record = row
c. Field = row
d. Record = table
