Fourth Chapter Solved Exercise MCQs Of ICS Second Year Computer Science

Fourth 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.

Fourth chapter solved MCQs with explanation

1. In 3NF, which form of dependency is removed?
Options:
a) functional
b) non-functional
c) associative
d) transitive

Explanation: In 3NF (Third Normal Form), transitive dependencies are removed to ensure that non-key attributes are only dependent on the primary key.

2. In a relational database, a table is also called a:
Options:
a) tuple
b) relation
c) file
d) schema

Explanation: A table in a relational database is technically referred to as a relation, which is a set of tuples (rows).

3. In 3NF, a non-key attribute must not depend on a(n):
Options:
a) non-key attribute
b) key attribute
c) composite key
d) sort key

Explanation: In 3NF, non-key attributes must be dependent on the primary key, ensuring no dependency on other non-key attributes.

4. Different attributes in two different tables having the same name are referred to as:
Options:
a) synonym
b) homonym
c) acronym
d) mutually exclusive

Explanation: Attributes with the same name in different tables are mutually exclusive, meaning they are separate and independent.

5. Every relation must have a:
Options:
a) primary key
b) candidate key
c) secondary key
d) composite key

Explanation: Every relation (table) in a database must have a primary key, which uniquely identifies each record in the table.

6. What does SQL stand for?
Options:
a) Structured Query List
b) Structured Query Language
c) Simple Query Language
d) Standard Query Language

Explanation: SQL stands for Structured Query Language, which is used to manage and manipulate relational databases.

7. Which SQL statement is used to fetch data from a database?
Options:
a) GET
b) SELECT
c) RETRIEVE
d) FETCH

Explanation: The SELECT statement is used in SQL to fetch data from a database.

8. Which of the following is a valid SQL statement?
Options:
a) SELECT * FROM table_name;
b) FIND * IN table_name;
c) EXTRACT * FROM table_name;
d) CHOOSE * FROM table_name;

Explanation: SELECT * FROM table_name; is the correct syntax to retrieve all records from a specified table.

9. In a database, what is a foreign key?
Options:
a) A key that is stored in a foreign country
b) A key that uniquely identifies a record in a table
c) A key that links records between two tables
d) A key that is used only for sorting data

Explanation: A foreign key is used to link records in one table to records in another, maintaining referential integrity.

10. What is the main purpose of normalization in a database?
Options:
a) To reduce data redundancy
b) To increase data duplication
c) To speed up queries
d) To create more tables

Explanation: Normalization reduces data redundancy by organizing data into related tables, making the database more efficient.