2nd Year Computer Chapter 5 MCQs with Answers

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