Tribhuvan University
Bachelor of Business Administration
Semester 2 · TU Board 2025
Course Title: Database Management System (IT232)
Full Marks: 60Pass Marks: 30Time: 3 Hrs
Candidates are required to give their answers in their own words as for as practicable.
Group A
Brief Answer Questions(10 × 1 = 10)
- 1.1
Mention any one difference between schemas and instances.
- 2.1
Define attribute inheritance.
- 3.1
List out any two data types used in SQL.
- 4.1
What is the importance of creating role?
Answer comingAlso asked in 2024, 2023
- 5.1
Define Transitive dependency.
- 6.1
Write SQL query to remove an attribute named 'email' from Employee table.
- 7.1
Define concurrent transaction.
- 8.1
Define distributed databases.
- 9.1
Define privileges in database management.
- 10.1
What is catastrophic failure?
Group B
Short Answer Questions: (Attempt any FIVE Questions)(5 × 3 = 15)
- 11.3
Write about any three types of constraints used in database.
- 12.3
Differentiate between deferred update and immediate update.
Answer comingAlso asked in 2024, Model question
- 13.3
Illustrate and explain three-schema architecture.
Answer comingAlso asked in Model question
- 14.3
Mention any three methods to make database secure.
- 15.3
Explain the types of relationship set.
Answer comingAlso asked in Model question
- 16.3
Explain the desirable properties of transactions.
Answer comingAlso asked in 2024, 2023, Model question
Group C
Long Answer Questions: (Attempt any THREE Questions)(3 × 5 = 15)
- 17.5
Define concurrency control. Describe about two phase locking protocol for concurrent transaction.
Answer comingAlso asked in Model question
- 18.5
Explain the concept of specialization with your own example.
- 19.5
Explain the types of Anamolies.
- 20.5
Illustrate and explain two tier and three tier database application architecture.
Group D
Comprehensive Answer / Case / Situation Analysis Questions(2 × 10 = 20)
- 21.10
Consider the following tables of a database: Instructor (InstructorID, InstructorName, JobStatus) Subject (SubCode, SubjectName, CreditHours) Taught (Subcode, InstructorID, Semester) Write SQL Queries for the following: i) Insert a record with values "IT232", "DBMS", 3 in the Subject table ii) Change the JobStatus of an Instructor with ID 521 to 'Permanent' iii) To add a column "salary" in instructor table. iv) To display the name of instructor with highest salary. v) To delete a column credit hours from subject table.
- 22.10
Normalize the following relation up to 3-NF. E-IDE-nameContact NoP-IdP-nameE01Ram9841,2273P01ABCE01Ram9841,2273P02XYZE02Shyam98510P02XYZE03Hari9860,5535P01ABCE03Hari9860,,5535P03PQRE04Shyam9899,9847P03PQR
— The End —