Master in Data Science (SMS, TU) Database Management Systems Question Paper 2081 Nepal
This is the official Master in Data Science (SMS, TU) Database Management Systems question paper for 2081, as set in the Board examination. It carries 45 full marks and a time allowance of 120 minutes, across 10 questions. On Kekkei you can attempt this Database Management Systems past paper online with a timer, get instant AI feedback and step-by-step solutions, and track the topics where you lose marks — completely free. Whether you are revising for your Master in Data Science (SMS, TU) Database Management Systems exam or solving previous years' question papers, this 2081 paper is a great way to practise under real exam conditions.
| Level | Master in Data Science (SMS, TU) |
|---|---|
| Subject | Database Management Systems |
| Year | 2081 BS |
| Exam session | Board |
| Full marks | 45 |
| Time allowed | 120 minutes |
| Questions | 10, all with step-by-step solutions |
Group A
What are the advantages of using DBMS?
How is cost-based optimization of SQL queries done?
How is no waiting algorithm of deadlock prevention different from cautious waiting?
Define a statistical database with an example.
What is three schema architecture?
Group B
Describe 1NF, 2NF and 3NF with appropriate examples. [6]
OR
Describe the dependency preservation and lossless join property. Describe 4NF with an example. [3+3]
Describe how lost update and dirty read problems occur in concurrent execution of transactions? Illustrate with examples. [6]
OR
How is exclusive lock different from shared lock? Consider any three transactions T1, T2 and T2 are performing read and write operations over data items A, B, and C. Now create a schedule containing T1, T2, and T3 that suffers from deadlock. [2+4]
How database records are mapped to files using fixed length record and variable length record approaches? Justify with examples. [6]
Design an ER diagram that contains at least three entities. One of the entity must be weak entity. There should be many to many relationship between the two strong entities. Use your own assumptions for other requirements. Now convert the so constructed ER diagram into equivalent database table schema. [3+3]
Consider the following relations defining the hotel management system. [6]
Food(Fid, Fname, PriceRate, Cookedby, Inspectedby) Cook(Cid, Cname, Cspeciality) FoodInspector(Fid, Fname, Experience) Reportdetail(Fid, Cid, Report_date)
Frequently asked questions
- Where can I find the Master in Data Science (SMS, TU) Database Management Systems question paper 2081?
- The full Master in Data Science (SMS, TU) Database Management Systems 2081 (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 2081 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 2081 paper?
- The Master in Data Science (SMS, TU) Database Management Systems 2081 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.