Fifth Chapter Solved Exercise MCQs Of ICS Second Year Computer Science

Fifth Chapter Solved Exercise MCQs Of ICS Second Year Computer Science. Each question includes the correct answer and a brief explanation. It’s designed to help you study, prepare for exams, and understand key concepts better. Boost your Computer Science knowledge with these practice exercises.

Fifth chapter solved MCQs with explanation

1. A database consists of various components called the:
a) Tool

b) Properties

c) Entities

d) Object

Explanation: Entities are the key components in a database that represent real-world objects like tables.

2. Which of the following objects of a database is used to retrieve data from the database?
a) Queries

b) Forms

c) Reports

d) Tables

Explanation: Queries are used to retrieve specific data from a database based on certain criteria.

3. The output of a query is in the form of a:
a) Table

b) Form

 c) Report

d) Query

Explanation: When a query is run, it typically produces results in the form of a table.

4. Which of the following objects is used to retrieve data from a database and present it in a formatted way?
a) Report

b) Form

c) Table

d) Query

Explanation: A report is used to present data from a database in a formatted and organized way, suitable for printing or viewing.

5. Microsoft Access saves the database with the extension:
a) .mdb

b) .msdb

c) .madb

d) None of them

Explanation: Microsoft Access saves database files with the .mdb extension, which stands for Microsoft Database.

6. A record is a complete set of _ field.
a) Distinct

b) Related

c) Designed

d) All of them

Explanation: A record is a complete set of related fields that together represent a single data entry.

7. In a relational database, the primary key is used to:
a) Identify unique records

b) Link tables

c) Store large amounts of data

d) Perform calculations

Explanation: The primary key is used to identify unique records in a table, ensuring that each record can be distinctly recognized.

8. Which object in a database allows users to enter and edit data?
a) Report

b) Query

c) Form

d) Table

Explanation: A form allows users to enter and edit data in a database by providing an easy-to-use interface.

9. To create a new table in a database, you would typically use:
a) A query

b) A report

c) A form

d) A table design view

Explanation: To create a new table, you would use the table design view, where you can define fields and their properties.

10. Which SQL statement is used to update existing records in a table?
a) INSERT

b) DELETE

c) UPDATE

d) SELECT

\Explanation: The UPDATE statement is used to modify existing records in a table, allowing you to change data values.