Tribhuvan University
Bachelor of Computer Application
Semester 4 · TU Board 2026
Course Title: Database Management System (CACS255)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to answer the question in their own words as far as possible.
Group A
Group B
Attempt any SIX question.(6 × 5 = 30)
- 2.5
Define transaction. Describe ACID properties with example. [1+4]
Answer comingAlso asked in 2022
- 3.5
Explain physical data independence and logical data independence. [2.5+2.5]
- 4.5
What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]
- 5.5
Define schedule and serializability with example. How can you test the serializability? [2+3]
- 6.5
What is data model? What are its types? [1+4]
- 7.5
Define query processing and steps in query processing. [1+4]
Answer comingAlso asked in 2023
- 8.5
Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.
Answer comingAlso asked in 2022, 2020
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
Describe DDL and DML queries with example. Explain database system architecture. [3+7]
- 10.10
What is normalization? What are its advantages? Describe its types with appropriate examples. [2+2+6]
- 11.10
Consider the following schema:
Guest (Gid, Gname, Age, Gender) STAFF (Sid, Sname, Age, Gender, Roles) SERVICE (serId, serName, Price) ASSISTS (Gid, Sid) (Which staff assists which guest) PROVIDES (serId, Sid) (Which staff provides which service)
Write SQL Queries: a. Find name of guests who are VIP. b. Find total number of guests assisted by staff Ram. c. Find name of staff whose name starts with A and ends with A. d. Display name of staff who provides laundry service. e. Give 10% discount to female guests on the price of service they receive. [3+2+2+1+2]
— The End —