CACS255 Database Management System
Database Management System: most repeated questions
Questions that have come up in more than one paper, matched by what they ask rather than exact wording. Most repeated first.
- 3×Asked in 2024, 2022, 2020Why normalization is required in database? Explain the 1NF, 2NF and 3NF of normalization with example.Answer coming10
See the wording in each paper
- Why normalization is required in database? Explain the 1NF, 2NF and 3NF of normalization with example.TU Board 2024
- Define normalization. Describe the importance of normalization in DBMS. Describe 1NF, 2NF and 3NF with examples.TU Board 2022
- Discuss the importance of normalization in DBMS. Describe 1NF, 2NF and 3NF with examples.TU Board 2020
- 3×Asked in 2026, 2022, 2020Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.Answer coming5
See the wording in each paper
- Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.TU Board 2026
- Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.TU Board 2022
- Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.TU Board 2020
- 2×Asked in 2023, 2021Define database and DBMS. Explain the benefits of DBMS in detail.Answer coming5
See the wording in each paper
- 2×Asked in 2026, 2023Define query processing and steps in query processing. [1+4]Answer coming5
See the wording in each paper
- 2×Asked in 2026, 2022Define transaction. Describe ACID properties with example. [1+4]Answer coming5
See the wording in each paper
- 2×Asked in 2024, 2022Draw and explain three schema architecture of the database system.Answer coming5
See the wording in each paper