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

Question 1

What are the advantages of using Database Management System over traditional filing system? Explain different data models with example.

Marks: 10

Year: 2076 Final TU

Advantages of Database Management System (DBMS) over Traditional File System A Database Management System (DBMS) is a software system that allows storing, organizing, and managing data efficiently. It

Question 2

What is data abstraction? What are three levels of data abstraction? Explain.

Marks: 5

Year: 2076 Final TU

Data Abstraction Data Abstraction in DBMS refers to hiding the internal details of data storage and presenting users with only necessary information. It simplifies database usage by separating data

Question 3

What are different types of Database users and their roles? Explain the Data independence with example.

Marks: 10

Year: 2078 Final TU

1. Types of Database Users and Their Roles A DBMS is accessed by different categories of users, each having specific roles and responsibilities. The main types of database users are: a) Database Admi

Question 4

What is difference between logical data independence and physical data independence?

Marks: 5

Year: 2078 Final TU

Data Independence refers to the capability to change the schema at one level of the database without affecting the next higher level. It is of two types: 1. Logical Data Independence - It is the abil

Question 5

What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?

Marks: 10

Year: 2079 Final TU

1. Database Management System (DBMS) A Database Management System (DBMS) is a software system that enables users to define, create, maintain, and control access to databases. Key Features: - Stores

Question 6

What do you mean by Schema and Instance in DBMS? Explain both with examples.

Marks: 5

Year: 2079 Final TU

1. Schema in DBMS Definition: A schema is the overall structure or design of the database, describing how data is organized and how the relationships among data are associated. It is defined at th

Question 7

Define data abstraction, data model, schemas, instances and database state.

Marks: 5

Year: 2080 Final TU

DBMS 4th Sem - Key Concepts 1. Data Abstraction Definition: Data abstraction is the concept of hiding the internal details of how data is stored and maintained, and showing only the essential featu

Question 8

Define data independence. Explain three-schema architecture.

Marks: 5

Year: 2080 Final TU

Data Independence and Three-Schema Architecture 1. Data Independence Definition: Ability to change the schema at one level without affecting the next higher level. Types: - Logical Data Independen

Question 9

What is specialization? What are different constraints on specialization?

Marks: 5

Year: 2080 Final TU

Specialization in DBMS 1. Definition of Specialization Specialization is a top-down process in Entity-Relationship (ER) modeling where a higher-level (superclass) entity is divided into two or more l

Question 10

Explain ANSI/SPARC three-schema architecture with suitable diagram.

Marks: 5

Year: 2081 Final TU

ANSI/SPARC Three-Schema Architecture The ANSI/SPARC three-schema architecture is a framework that describes how a Database Management System (DBMS) separates data into three different levels of abstra

Question 11

Classify database management systems based on the data model.

Marks: 5

Year: 2081 Final TU

Classification of Database Management Systems Based on Data Model Database Management Systems (DBMS) can be classified into different types depending on the data model they use to represent and manage