Browse papers
LevelMaster in Data Science (SMS, TU)
SubjectDatabase Management Systems
Year2082 BS
Exam sessionBoard · Set page 16; 2082 board/final exam (IOST,TU)
Full marks45
Time allowed120 minutes
Questions10, all with step-by-step solutions
A

Group A

5 questions·3 marks each
1Short answer3 marks

Define BCNF and DKNF.

bcnfdknf
2Short answer3 marks

Describe QBE with an example.

qbe
3Short answer3 marks

List different types of data models and explain anyone.

data-models
4Short answer3 marks

What do you understand by information retrieval? Explain.

information-retrieval
5Short answer3 marks

Explain the concept of data abstraction in DBMS.

data-abstraction
B

Group B

5 questions·6 marks each
6Long answer6 marks

Explain two phase commit protocol. List its advantages.

two-phase-commit
7Long answer6 marks

What do you understand by query optimization? Explain.

query-optimization
8Long answer6 marks

Create B tree of order(M) = 3 for the following values: 1, 4, 11, 3, 7, 12, 2, 5, 15, 13, 6

OR

Explain different data warehouse schemas.

b-treedata-warehouse
9Long answer6 marks

Provided the following schema, write relational algebra

MEMBER (MID, Mname, Maddress) HALL (HID, Hname, Haddress, Hdepartment, Hprice) RESERVES (MID, HID, date)

a) List all the members who have reserved two halls i.e. Hall 4 and Hall 6. b) Display name and address of those members who have booked the hall of science department for 18/6/2025. c) List the id and name of those members who have booked the hall whose price is less than Rs. 10,000.

OR

Explain any one classification algorithm with an example of your own.

relational-algebraclassification
10Long answer6 marks

Write short notes on a) Mobile Database b) DML

mobile-databasedml

Frequently asked questions

Where can I find the Master in Data Science (SMS, TU) Database Management Systems question paper 2082?
The full Master in Data Science (SMS, TU) Database Management Systems 2082 (Board) question paper is available free on Kekkei. You can read every question online and attempt the paper under timed exam conditions.
Does the Database Management Systems 2082 paper come with solutions?
Yes. Every question on this Database Management Systems past paper includes a step-by-step solution, plus instant AI feedback when you attempt it on Kekkei.
How many marks is the Master in Data Science (SMS, TU) Database Management Systems 2082 paper?
The Master in Data Science (SMS, TU) Database Management Systems 2082 paper carries 45 full marks and is meant to be completed in 120 minutes, across 10 questions.
Is practising this Database Management Systems past paper free?
Yes — reading and attempting this Database Management Systems past paper on Kekkei is completely free.