Tribhuvan University
Bachelor of Computer Application
Semester 4 · TU Board 2022
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 B
Attempt any SIX question.(6 × 5 = 30)
- 2.5
What is DBMS? Describe the advantages and disadvantages of using DBMS.
- 3.5
Describe 3-schema architecture of database.
Answer comingAlso asked in 2024
- 4.5
What are roles and responsibilities of DBA.
- 5.5
Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.
Answer comingAlso asked in 2026, 2020
- 6.5
What are the states of transaction model? Describe the ACID properties of transaction.
Answer comingAlso asked in 2026
- 7.5
Describe the use of ER diagram. Draw an ER diagram for a university to design a database for it.
- 8.5
What is DDL and DML queries? Consider the following relation.
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
Define normalization. Describe the importance of normalization in DBMS. Describe 1NF, 2NF and 3NF with examples.
Answer comingAlso asked in 2024, 2020
- 10.10
Differentiate between stored procedure and trigger. Why concurrency control is needed? Describe timestamp based concurrency protocol.
- 11.10
What is data model? What are its types? Describe the structure of database.
— The End —