Master in Data Science (SMS, TU) Database Management Systems Question Paper 2082 (Set page 9; Second Assessment 2082) Nepal
This is the official Master in Data Science (SMS, TU) Database Management Systems question paper for 2082 Set page 9; Second Assessment 2082, as set in the Second Assessment 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 2082 paper is a great way to practise under real exam conditions.
| Level | Master in Data Science (SMS, TU) |
|---|---|
| Subject | Database Management Systems |
| Year | 2082 BS |
| Exam session | Second Assessment · Set page 9; Second Assessment 2082 |
| Full marks | 45 |
| Time allowed | 120 minutes |
| Questions | 10, all with step-by-step solutions |
Group A
Describe any one RAID Level.
Differentiate between supervised and unsupervised algorithm.
Explain any three Codd's rule.
Explain the concept of DDL and DML.
Explain weak entity set.
Group B
Explain different data warehouse schemas.
Convert the table to 3 NF.
| emp_id | emp_name | emp_zip | emp_state | emp_city | emp_district |
|---|---|---|---|---|---|
| 1 | Hira | 2005 | State5 | C1 | D1 |
| 2 | Kanti | 5780 | state2 | C2 | D2 |
| 3 | Bishal | 2005 | State5 | C3 | D3 |
| 4 | Pushpa | 2290 | state4 | C4 | D4 |
| 5 | Indira | 85009 | state3 | C5 | D4 |
Explain any one method of concurrency control.
OR
Which of the following schedule is (conflict) serializable? For each serializable schedule, determine the equivalent serial schedules. a) b)
Differentiate between classification and clustering. Explain the applications of clustering.
OR
Provided the following schema, write relational algebra
Patient(PID, Pname, Paddress, Pgender, disease) Doctor(DID, Dname, Daddress, Department, salary) Appointment(PID, DID, time)
a) List all the patients who were checked by doctors Maila and Sarthak. b) List name and id of doctors whose salary is less than Rs. 50,000. c) Display female patients who were checked by doctor Maila in day time only.
Write short notes on a) Spatial database b) ACID
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 (Second Assessment) 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.