AKTU Basics of Data Base Management System · Important Questions 2026Source: ryzenstudy.com PYQs
BOE067 Basics of Data Base Management System Important Questions 2026 (AKTU)
Repeat analysis + most-asked questions, unit-wise
What we did: built from all 3 AKTU Basics of Data Base Management System papers (2021-22–2024-25): 70 questions grouped into 51 distinct questions, 14 of which were asked in more than one paper.
- of marks were repeat questions
- —
- of marks were repeat questions
- questions asked in 2+ papers
- 14
- questions asked in 2+ papers
- papers analysed (2021-22–2024-25)
- 3
- papers analysed (2021-22–2024-25)
- units, mapped to current syllabus
- 5
- units, mapped to current syllabus
How much of the paper repeats?
- Not enough papers yet to measure this for this subject.
Across 10 subjects and 23 papers we tested, 43% of marks repeated earlier questions on average.
1.Unit-wise most-asked questions
Ranked by how many papers asked them, then by how recently. Click a paper to open it.
Unit 1: Introduction
24% of past marks| Question | Asked |
|---|---|
| What are the three levels of data abstraction in a DBMS? | Asked 3× |
| Write a short description of the following terms: Super Key, Candidate Key, Primary Key, Alternate Key, Foreign Key and Composite Key. | Asked 2× |
| Discuss the problems with File systems. | Asked 2× |
| Define Database, DBMS, and Metadata. | Asked 2× |
Unit 2: Relational Database Concepts · Data Base Design & Normalization
27% of past marks| Question | Asked |
|---|---|
| Differentiate between entity integrity and referential integrity. | Asked 3× |
| Explain different types of join operations in relational algebra: inner join, natural join, outer join, equi-join with examples. | Asked 2× |
| Define functional dependencies and the relation of primary keys with FDs. | Asked 2× |
| Consider the relation R(A, B, C, D, E) with functional dependencies (see original paper): (i) Find the candidate keys. (ii) Determine if the relation is in 2NF or 3NF. (iii) Normalize the relation to BCNF. 7 marks2024-25 Q7(a) | Asked 1× |
Unit 3: Structured Query Language (SQL) · PL/SQL
15% of past marks| Question | Asked |
|---|---|
| What is Aggregate function in SQL? Write SQL query for aggregate function. | Asked 2× |
| Create a table STUDENT with the following structure: StudentID (Primary Key), Name (VARCHAR), Age (Integer), Department (VARCHAR), Marks (Number). Include constraints for primary key, NOT NULL, and CHECK (Marks >= 0). Also, write SQL statements to: Insert 3 student records. 7 marks2024-25 Q3(a) | Asked 1× |
| Consider the following schema for institute library: Student (RollNo, Name, Father_Name, Branch), Book (ISBN, Title, Author, Publisher), Issue (RollNo, ISBN, Date-of-Issue). Write the following queries in SQL: (i) List roll number and name of all students of the branch ‘CSE’. (ii) Find the name of student who has issued a book published by ‘ABC’ publisher. (iii) List title of all books and their authors issued to a student ‘RAM’. (iv) List title of all books issued on or before December 1, 2020. (v) List all books published by publisher ‘ABC’. 7 marks2024-25 Q4(a) | Asked 1× |
| Illustrate Group by and Having clauses with examples. 10 marks2022-23 Q2(c) | Asked 1× |
Unit 4: Transaction Processing Concepts · Concurrency Control Techniques
26% of past marks| Question | Asked |
|---|---|
| What are ACID properties of Transaction? | Asked 3× |
| What is Log? How is it maintained? Discuss the features of deferred database modification and immediate database modification in brief. | Asked 2× |
| Explain Recovery from Concurrent Transaction. | Asked 2× |
| Discuss Serializability in detail. | Asked 2× |
Unit 5:
9% of past marks| Question | Asked |
|---|---|
| Explain the following types of database security with examples: Physical security, OS-level security, Network-level security, Database-level security. Also, mention how these layers complement each other in a secure architecture. | Asked 2× |
| Explain different types of Recovery Techniques. | Asked 2× |
| Explain in detail the application of Centralized and Client-Server Architectures. 7 marks2021-22 Q2(a) | Asked 1× |
| Explain in detail any two of the following. (i) Data Mining. (ii) Data Warehousing. (iii) Data Visualization. 7 marks2021-22 Q5(b) | Asked 1× |
2.Topic weightage: which topics carry the marks
Blue = Tier 1 + Tier 2 (topics that carried ~80% of past marks). Grey = the rest. It shows where marks have gone, not a promise of what comes next.
Queries and aggregate functions · U3
9% (cum 9%)
Architecture and views of data · U1
7.3% (cum 16%)
Functional dependencies · U2
6.6% (cum 23%)
Integrity constraints · U2
6.5% (cum 29%)
Transaction properties (ACID) · U4
5.4% (cum 35%)
Serializability · U4
4.9% (cum 40%)
Recoverability and log-based recovery · U4
4.8% (cum 44%)
Normal forms 1NF-BCNF · U2
4.2% (cum 49%)
ER model concepts · U1
4% (cum 53%)
Decomposition and lossless join · U2
3.7% (cum 56%)
Join operations · U2
3.4% (cum 60%)
Keys · U1
3.2% (cum 63%)
Recovery with concurrent transactions · U4
3.2% (cum 66%)
DBMS vs file system · U1
3.2% (cum 69%)
Backup and recovery · U5
2.6% (cum 72%)
Types and levels of security · U5
2.6% (cum 75%)
Locking techniques · U4
2.5% (cum 77%)
Tables and constraints · U3
2.3% (cum 79%)
Users, DBA and storage management · U1
2% (cum 81%)
Generalization, aggregation and ER mapping · U1
2% (cum 83%)
Client-server and distributed databases · U5
1.9% (cum 85%)
MVD, JD and higher normal forms · U2
1.7% (cum 87%)
Timestamp, validation and multiversion · U4
1.7% (cum 89%)
Deadlock handling · U4
1.7% (cum 90%)
SQL basics and data types · U3
1.6% (cum 92%)
Procedures, functions and triggers · U3
1.6% (cum 94%)
Data analysis, mining and warehousing · U5
1.6% (cum 95%)
Two-phase commit and checkpoints · U4
1.4% (cum 97%)
Database languages and interfaces · U1
1% (cum 98%)
Data models and independence · U1
0.9% (cum 99%)
Views and indexes · U3
0.9% (cum 99%)
Relational model and terminology · U2
0.7% (cum 100%)
| Topic | Papers | Share |
|---|---|---|
| Queries and aggregate functions · Unit 3 · Tier 1 | 3/3 | 9% |
| Architecture and views of data · Unit 1 · Tier 1 | 3/3 | 7.3% |
| Functional dependencies · Unit 2 · Tier 1 | 3/3 | 6.6% |
| Integrity constraints · Unit 2 · Tier 1 | 3/3 | 6.5% |
| Transaction properties (ACID) · Unit 4 · Tier 1 | 3/3 | 5.4% |
| Serializability · Unit 4 · Tier 1 | 3/3 | 4.9% |
| Recoverability and log-based recovery · Unit 4 · Tier 1 | 2/3 | 4.8% |
| Normal forms 1NF-BCNF · Unit 2 · Tier 1 | 2/3 | 4.2% |
| ER model concepts · Unit 1 · Tier 1 | 2/3 | 4% |
| Decomposition and lossless join · Unit 2 · Tier 2 | 2/3 | 3.7% |
| Join operations · Unit 2 · Tier 2 | 2/3 | 3.4% |
| Keys · Unit 1 · Tier 2 | 2/3 | 3.2% |
| Recovery with concurrent transactions · Unit 4 · Tier 2 | 2/3 | 3.2% |
| DBMS vs file system · Unit 1 · Tier 2 | 2/3 | 3.2% |
| Backup and recovery · Unit 5 · Tier 2 | 2/3 | 2.6% |
| Types and levels of security · Unit 5 · Tier 2 | 2/3 | 2.6% |
| Locking techniques · Unit 4 · Tier 2 | 2/3 | 2.5% |
| Tables and constraints · Unit 3 · Tier 2 | 2/3 | 2.3% |
| Users, DBA and storage management · Unit 1 · Tier 2 | 1/3 | 2% |
| Generalization, aggregation and ER mapping · Unit 1 · Tier 3 | 1/3 | 2% |
| Client-server and distributed databases · Unit 5 · Tier 3 | 1/3 | 1.9% |
| MVD, JD and higher normal forms · Unit 2 · Tier 3 | 1/3 | 1.7% |
| Timestamp, validation and multiversion · Unit 4 · Tier 3 | 1/3 | 1.7% |
| Deadlock handling · Unit 4 · Tier 3 | 1/3 | 1.7% |
| SQL basics and data types · Unit 3 · Tier 3 | 2/3 | 1.6% |
| Procedures, functions and triggers · Unit 3 · Tier 3 | 1/3 | 1.6% |
| Data analysis, mining and warehousing · Unit 5 · Tier 3 | 1/3 | 1.6% |
| Two-phase commit and checkpoints · Unit 4 · Tier 3 | 1/3 | 1.4% |
| Database languages and interfaces · Unit 1 · Tier 3 | 1/3 | 1% |
| Data models and independence · Unit 1 · Tier 3 | 1/3 | 0.9% |
| Views and indexes · Unit 3 · Tier 3 | 1/3 | 0.9% |
| Relational model and terminology · Unit 2 · Tier 3 | 1/3 | 0.7% |
3.Paper pattern (2024-25)
| Section | Questions | Rule |
|---|---|---|
| A | 7 × 2 marks | Attempt all |
| B | 5 × 7 marks | Attempt any 3 |
| C | 10 × 7 marks | Attempt any 1 |
4.In the syllabus, never asked yet
Low priority, but read them once — a new paper can always start here.
- Relational algebra and calculus · U2
- Joins and set operations · U3
- PL/SQL basics and cursors · U3
- Transaction control commands · U3
- Authorization and privileges · U5
- Object-oriented and XML databases · U5
- Other recent databases · U5
5.Study order
- 1Queries and aggregate functions (Unit 3, Tier 1)
- 2Architecture and views of data (Unit 1, Tier 1)
- 3Functional dependencies (Unit 2, Tier 1)
- 4Integrity constraints (Unit 2, Tier 1)
- 5Transaction properties (ACID) (Unit 4, Tier 1)
- 6Serializability (Unit 4, Tier 1)
- 7Recoverability and log-based recovery (Unit 4, Tier 1)
- 8Normal forms 1NF-BCNF (Unit 2, Tier 1)
- 9ER model concepts (Unit 1, Tier 1)
- 10Decomposition and lossless join (Unit 2, Tier 2)
- 11Join operations (Unit 2, Tier 2)
- 12Keys (Unit 1, Tier 2)
- 13Recovery with concurrent transactions (Unit 4, Tier 2)
- 14DBMS vs file system (Unit 1, Tier 2)
- 15Backup and recovery (Unit 5, Tier 2)
- 16Types and levels of security (Unit 5, Tier 2)
- 17Locking techniques (Unit 4, Tier 2)
- 18Tables and constraints (Unit 3, Tier 2)
- 19Users, DBA and storage management (Unit 1, Tier 2)
FAQ
Which units of BOE067 carry the most marks?
Unit 2 (Relational Database Concepts · Data Base Design & Normalization, 27% of past marks) and Unit 4 (Transaction Processing Concepts · Concurrency Control Techniques, 26% of past marks).
Do AKTU Basics of Data Base Management System questions repeat?
14 questions have appeared in more than one of the 3 papers so far. There are not enough papers yet to measure the repeat share reliably.
How is this list made?
Every question from the 3 papers (2021-22–2024-25) was mapped to the current AKTU syllabus and grouped with the same question from other years. Questions are ranked by how many papers they appeared in, then by how recently.
Study this subject
Note: this is based on past AKTU papers, not a guarantee. Questions are mapped to the current syllabus; topics that are no longer in the syllabus are left out.