TU OFFICIAL RESOURCE

TU BCA 4th Semester — 2025, 2024 BOARD EXAM — Database Management System MCQs

SHARE RESOURCE

WhatsApp Instagram Messenger

TRIBHUVAN UNIVERSITY

Bachelor of Computer Application

OFFICE OF THE DEAN

2025, 2024 BOARD EXAM

Faculty: Bachelor of Computer Application (BCA)

Course Title: Database Management System (MCQs)

Code No: CACS255

Semester: 4th Semester

Full Marks: 60

Pass Marks: 24

Time: 3 hours

Group A (Multiple Choice Questions)

Attempt all questions. Correct answers are highlighted in yellow.

1. The process of transforming requests and results between the three levels is called.......

a)Mapping

✓ Correct Answer

b)Query processor unit

c)Communication interface

d)Data independence

💡 Explanation: Mapping is the process of transforming requests and results between the three database levels (external, conceptual, and internal) to maintain data independence.

2. Which of the following are introduced to reduce the overheads caused by the log-based recovery?

a)Deadlocks

b)Indices

c)Checkpoints

✓ Correct Answer

d)Locks

💡 Explanation: Checkpoints are introduced to reduce the overheads of log-based recovery by limiting the portion of the log that needs to be scanned during recovery.

3. Which of the following is not a component of a Data Dictionary?

a)Entity

b)Record

✓ Correct Answer

c)Attributes

d)Relationship

💡 Explanation: A Data Dictionary contains metadata about entities, attributes, and relationships, but not actual data records which belong to the database itself.

4. Which of the following is an example of metadata?

a)Record

b)Information

c)File name

d)Data type and size of the fields

✓ Correct Answer

💡 Explanation: Metadata is data about data; data type and size of fields describe the structure and characteristics of the actual data stored in a database.

5. Display the detail of the Employee belonging to the 'HR' Department having salary more than 20000 then which of the following relational algebra operations is correct for it?

a)\sigma_{Department='HR' \land salary > 20000}(employee)

✓ Correct Answer

b)\pi_{Department='HR' \land salary > 20000}(employee)

c)\sigma_{Department='HR' \lor salary > 20000}(employee)

d)\pi_{Department='HR' \lor salary > 20000}(employee)

💡 Explanation: The Select operation (\sigma) with AND condition (\land) filters rows matching both Department='HR' and salary>20000 criteria from the employee table.

6. The property of a transaction that persists all the crashes is ...

a)Atomicity

b)Durability

✓ Correct Answer

c)Isolation

d)All of the mentioned

💡 Explanation: Durability ensures that once a transaction is committed, its changes persist permanently even in case of system crashes or failures.

7. DBA, Database Designers, and Application programmer work at ........

a)Conceptual level

✓ Correct Answer

b)View level

c)Physical Level

d)Internal level

💡 Explanation: Database Designers and Application Programmers work at the conceptual level where they design the logical structure of the entire database.

8. ___________________constraint belongs to domain constraint.

a)Check

✓ Correct Answer

b)Unique

c)Primary

d)Referential

💡 Explanation: Check constraint is a domain constraint that restricts the values that can be placed in a column by specifying conditions that must be met.

9. Purpose of the GROUP BY is.......

a)Group data by column values

✓ Correct Answer

b)Group data by row values

c)Group data by column and row values

d)To filter out the row values

💡 Explanation: GROUP BY clause groups rows that have the same values in specified columns, allowing aggregate functions to be applied to each group.

10. From the set of values if we want to find the minimum value then which function can we use?

a)Min

✓ Correct Answer

b)Minimum

c)Least

d)Last

💡 Explanation: MIN() is the SQL aggregate function used to find the minimum value from a set of values in a column.

11. A sub-query that uses a correlation name from an outer query is called a ............

a)Nested sub-query

b)Outer nested query

c)Correlated sub-query

✓ Correct Answer

d)Correlated outer query

💡 Explanation: A correlated sub-query references columns from the outer query and is executed repeatedly for each row of the outer query.

12. The process of transforming requests and results between the three levels is called...

a)Mapping

✓ Correct Answer

b)Query processor unit

c)Communication interface

d)Data independence

💡 Explanation: Mapping translates requests and results between the external, conceptual, and internal database levels, enabling data independence and abstraction.

13. Which of the following levels has the highest level of abstraction?

a)View level

b)Conceptual level

✓ Correct Answer

c)Logical Level

d)Physical level

💡 Explanation: The conceptual (logical) level provides a high level of abstraction, describing what data is stored and relationships among data without implementation details.

14. Which of the following is the property of transaction that protects data from system failure?

a)Atomicity

b)Isolation

c)Consistency

d)Durability

✓ Correct Answer

💡 Explanation: Durability ensures that once a transaction is committed, its changes persist permanently even in case of system crashes or power failures.

15. Which of the following is not a conflicting operation set in a schedule of transactions T1 and T2?

a)W1(x), W2(x)

b)W1(x), R2(x)

c)R1(x), W2(x)

d)R1(x), R2(x)

✓ Correct Answer

💡 Explanation: Two read operations R1(x) and R2(x) do not conflict because reading does not modify data; conflicts only occur when at least one operation is a write.

16. Which normalization form is based on the transitive dependency?

a)1NF

b)2NF

c)3NF

✓ Correct Answer

d)BCNF

💡 Explanation: Third Normal Form (3NF) eliminates transitive dependencies, ensuring that non-key attributes depend only on the primary key, not on other non-key attributes.

17. Which of the following is not a binary operator in relational algebra?

a)Union

b)Natural Join

c)Project

✓ Correct Answer

d)Join

💡 Explanation: Project is a unary operator that selects specific columns from a single relation, while binary operators like union and join operate on two relations.

18. Extended ER diagram uses the concept of ............

a)Inheritance

✓ Correct Answer

b)Structure

c)Polymorphism

d)Object

💡 Explanation: Extended ER diagrams use inheritance (specialization/generalization) to represent hierarchical relationships where subclasses inherit attributes from superclasses.

19. Two Schedules are said to be ------- if the order of any two conflicting operations is the same in both schedules.

a)Conflict Serialization

b)Serial Schedule

c)Conflict Equivalent

✓ Correct Answer

d)Ordered Schedule

💡 Explanation: Conflict equivalent schedules maintain the same order of conflicting operations, ensuring they produce the same final result and are interchangeable.

20. ........... Captures data types, relationships, and constraints on data.

a)Database instance

b)Database table

c)Database schema

✓ Correct Answer

d)Normalization

💡 Explanation: Database schema defines the logical structure, including data types, relationships, and constraints, providing a blueprint for how data is organized.

TU BCA 4th Semester — 2025, 2024 BOARD EXAM — Database Management System MCQs

TRIBHUVAN UNIVERSITY

OFFICE OF THE DEAN

Group A (Multiple Choice Questions)

1. The process of transforming requests and results between the three levels is called.......

2. Which of the following are introduced to reduce the overheads caused by the log-based recovery?

3. Which of the following is not a component of a Data Dictionary?

4. Which of the following is an example of metadata?

5. Display the detail of the Employee belonging to the 'HR' Department having salary more than 20000 then which of the following relational algebra operations is correct for it?

6. The property of a transaction that persists all the crashes is ...

7. DBA, Database Designers, and Application programmer work at ........

8. ___________________constraint belongs to domain constraint.

9. Purpose of the GROUP BY is.......

10. From the set of values if we want to find the minimum value then which function can we use?

11. A sub-query that uses a correlation name from an outer query is called a ............

12. The process of transforming requests and results between the three levels is called...

13. Which of the following levels has the highest level of abstraction?

14. Which of the following is the property of transaction that protects data from system failure?

15. Which of the following is not a conflicting operation set in a schedule of transactions T1 and T2?

16. Which normalization form is based on the transitive dependency?

17. Which of the following is not a binary operator in relational algebra?

18. Extended ER diagram uses the concept of ............

19. Two Schedules are said to be ------- if the order of any two conflicting operations is the same in both schedules.

20. ........... Captures data types, relationships, and constraints on data.

💎 Upgrade to Elite Pass

TU BCA 4th Semester — 2025, 2024 BOARD EXAM — Database Management System MCQs

TRIBHUVAN UNIVERSITY

OFFICE OF THE DEAN

Group A (Multiple Choice Questions)

1. The process of transforming requests and results between the three levels is called.......

2. Which of the following are introduced to reduce the overheads caused by the log-based recovery?

3. Which of the following is not a component of a Data Dictionary?

4. Which of the following is an example of metadata?

5. Display the detail of the Employee belonging to the 'HR' Department having salary more than 20000 then which of the following relational algebra operations is correct for it?

6. The property of a transaction that persists all the crashes is ...

7. DBA, Database Designers, and Application programmer work at ........

8. ___________________constraint belongs to domain constraint.

9. Purpose of the GROUP BY is.......

10. From the set of values if we want to find the minimum value then which function can we use?

11. A sub-query that uses a correlation name from an outer query is called a ............

12. The process of transforming requests and results between the three levels is called...

13. Which of the following levels has the highest level of abstraction?

14. Which of the following is the property of transaction that protects data from system failure?

15. Which of the following is not a conflicting operation set in a schedule of transactions T1 and T2?

16. Which normalization form is based on the transitive dependency?

17. Which of the following is not a binary operator in relational algebra?

18. Extended ER diagram uses the concept of ............

19. Two Schedules are said to be ------- if the order of any two conflicting operations is the same in both schedules.

20. ........... Captures data types, relationships, and constraints on data.

💎 Upgrade to Elite Pass