Database Management System Unit 2 – Relational Model and SQL: important questions for AKTU
Unit 2 (Relational Model and SQL) questions that AKTU repeats most often. This unit carries about 31 marks per paper. Start with the repeated questions, then the most asked topics.
Most repeated Unit 2 questions
- Consider the following relational DATABASE. Give an expression in SQL for each following queries Underline records are Primary Key Employee (person_name, street, city) Works (person_name, Company_name, salary) Company (Company_name, city) Manages (person_name, manager_name) a) Finds the names of all employees who works for the ABC bank b) Finds the name of all employees who live in the same city and on the same street as do their managers c) Find the name street address and cities of residence of all employees who work for ABC bank and earn more than 7,000 per annum. d) Find the name of all employee who earn more than every employee of XYZ. e) Give all Employees of corporation ABC a 7% salary raise. f) Delete all tuples in the works relation for employees of ABC. g) Find the name of all employees in this DATABASE who live in the same city as the company for which they work. (7 marks, 2026, SQL Queries and Operations) – also asked in 2021, 2025
- What is Aggregate Function in SQL? Write SQL query for different Aggregate Function. (10 marks, 2021, SQL Queries and Operations) – also asked in 2022, 2023, 2026
- What is Relational Algebra? Explain Different Operations of Relational Algebra with Example. (10 marks, 2021, Relational Data Model) – also asked in 2022, 2025, 2026
Most important Unit 2 topic
- Relational Data Model (Unit 2: Relational Model and SQL) – asked 9 times in 2021, 2022, 2023, 2025, 2026
Most asked Unit 2 topics
- Relational Data Model – asked 9 times
- SQL Queries and Operations – asked 9 times
- SQL Basics and Commands – asked 4 times
More Unit 2 previous year questions
- Define Relational Algebra. (2 marks, 2026, Relational Data Model)
- Define constraint and its types in DBMS. (2 marks, 2026, Relational Data Model)
- Write difference between Cross Join, Natural Join, left outer join and right outer join with suitable example. (7 marks, 2026, SQL Queries and Operations)
- Discuss the importance of domain constraints and key constraints in maintaining database consistency. Also explain Entity Integrity and Referential Integrity constraints with suitable examples. (7 marks, 2026, Relational Data Model)
- Differentiate TRUNCATE and DELETE command (2 marks, 2025, SQL Basics and Commands)
Unit 2 syllabus topics
- Relational Data Model
- SQL Basics and Commands
- SQL Queries and Operations
- Cursors Triggers Procedures