BSC CSIT Semester 4 – Database Management System () Questions & Answers | Past TU Exam Papers

Question 1

Differentiate between Integrity and Security with example.

Marks: 5

Year: 2076 Final TU

Difference between Integrity and Security In a Database Management System (DBMS), Integrity and Security are two important concepts that ensure data is reliable and protected. Although they are relate

Question 2

Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key?

Marks: 5

Year: 2076 Final TU

Primary Key and Foreign Key in DBMS Keys in a database are attributes (or a set of attributes) that help uniquely identify records and maintain relationships between tables. --- 1️⃣ Primary Key - A P

Question 3

What is integrity? Explain different types of database integrity.

Marks: 5

Year: 2078 Final TU

1. What is Integrity? Integrity in DBMS refers to the accuracy, correctness, and consistency of data stored in a database. It ensures that the data is valid, reliable, and protected from unauthorize

Question 4

What is relational model? Define the terms domain, attribute, tuple and relation.

Marks: 5

Year: 2080 Final TU

1. Relational Model Definition: The relational model is a way of structuring data in the form of tables (relations) where data is organized into rows and columns. - Each table (relation) represent

Question 5

What is relational database? Explain different characteristic of a relation. Defain domain constraint.

Marks: 5

Year: 2080 Final TU

Relational Database and Characteristics of a Relation 1. Relational Database Definition: A relational database is a collection of data organized in the form of tables (relations), where each table

Question 6

What do you mean by referential integrity? Why do you need this integrity?

Marks: 5

Year: 2081 Final TU

What is Referential Integrity? Referential Integrity is a rule in relational databases that ensures the consistency of relationships between tables. It states that a foreign key in one table must re