Tribhuvan University
Bachelor of Business Administration
Semester 2 · Model question
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:(Attempt All Questions)(10 × 1 = 10)
- 1.1
Define data independence.
- 2.1
What is specialization?
- 3.1
What are the uses of keys in databases?
- 4.1
What is DDL?
- 5.1
What is functional dependency?
- 6.1
Define serializable schedule.
Answer comingAlso asked in 2024
- 7.1
List desirable properties of transactions.
Answer comingAlso asked in 2025, 2024, 2023
- 8.1
What is deferred update?
Answer comingAlso asked in 2025, 2024
- 9.1
What is shadow paging?
Answer comingAlso asked in 2024
- 10.1
Define BigData.
Group B
Short Answer Questions: (Attempt any FIVE Questions)(5 × 3 = 15)
- 11.3
Explain different constraints and characteristics of specialization and generalization in brief.
Answer comingAlso asked in 2024
- 12.3
Explain different types of relationship sets in brief.
Answer comingAlso asked in 2025
- 13.3
Explain any three data types in SQL with example.
- 14.3
What are the properties of relational decomposition? Explain.
- 15.3
How do you recover the database from catastrophic failure? Explain.
- 16.3
Explain recovery technique based on immediate update.
Group C
Long Answer Questions: (Attempt any THREE Questions)(3 × 5 = 15)
- 17.5
Explain three-schema architecture of database in detail.
Answer comingAlso asked in 2025
- 18.5
Draw an E-R diagram for online food ordering system.
- 19.5
What is concurrency control? Explain two-phase locking protocol. (1.5 + 3.5)
Answer comingAlso asked in 2025
- 20.5
Define data warehouse. Explain datamining with example. (1.5 + 3.5)
Group D
Comprehensive Answer / Case / Situation Analysis Questions(2 × 10 = 20)
- 21.10
Why do we need normalization in databases? Explain 1NF, 2NF, and 3NF with suitable example. (2.5 + 7.5)
- 22.10
Consider a University database with three tables, where the primary keys are underlined as given below:
student(SID, SName, SAddress, SEmail) studies(SID, CID) course(CID, CName, Credit_hours)
Give an expression in SQL for each of the following queries:
a. Insert data with values "S101", "Ram", "Lalitpur", and "[email protected]" in the student table. (2) b. Find names of all students whose address is "Kathmandu". (2) c. Find names of all students who study "Database Management System". (2) d. Count number of students who study "Database Management System". (2) e. Find names of all courses with credit hours greater than or equal to 3. (2)
— The End —