Database Management System Unit 2 – Relational Model and SQL: AKTU previous year questions
26 AKTU questions from Unit 2 (Relational Model and SQL) asked in 2021–2026, tagged by marks, year and topic. In short: about 31 marks of every paper come from this unit; the most asked topic is Relational Data Model (9 times); 17 questions came back in a later year. The latest ones are listed below; on the page you can filter them by 2-mark or long questions, topic and repeats.
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)
- 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)
- 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)
- Define triggers and its types. (2 marks, 2025, Cursors Triggers Procedures)
- Explain Joins? Discuss all types of Joins with the help of proper example of each. (7 marks, 2025, SQL Queries and Operations)
- Employee (ename, street, city) Worksfor (ename, company_name, salary) Company (Company_name, city) Construct the SQL statements for the following (i) Create the above given tables with suitable data types and size. (ii) Find the name of employees who live in the same city where they work. (iii) Find the name of employees who have salary more than Rs. 50000. (iv) Find the name of employees who don't work in "tcs" company. (v) Find all employees whose name has second letter 'A'. (vi) Find the employee's name having second highest salary. (7 marks, 2025, SQL Queries and Operations)
- Consider the following three relation schema S, P and SP in which S# is supplier code, P# part number and qty is quantity and others carry their respective meanings: S(S#, SNAME, SCITY, TURNOVER) P(P#,WEIGHT, COLOR, COST, SELLING PRICE) SP(S#, P#, QTY) Construct the appropriate RA statement for the following queries. i Get all details of supplier who operate from CALCUTTA with TURNOVER=80. ii Get part numbers weighting between 25 and 55. iii Get the part# which has cost greater than selling price. iv Get the part numbers whose color is red or black. v Get the SNAME where S# is 101. (7 marks, 2025, Relational Data Model)
- What is the difference between DROP and DELETE command? (2 marks, 2023, SQL Basics and Commands)
- What are different Integrity Constraints? (2 marks, 2023, Relational Data Model)
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
Unit 2 question pattern
- 2-mark questions: 11 asked in 2021–2026
- 7-mark questions: 6 asked in 2021–2026
- 10-mark questions: 9 asked in 2021–2026
- About 31 marks from Unit 2 in every paper
- 17 questions were asked again in a later year
Unit 2 questions year by year
- 2026: 5 Unit 2 questions asked (25 marks across that year's papers)
- 2025: 5 Unit 2 questions asked (25 marks across that year's papers)
- 2023: 5 Unit 2 questions asked (34 marks across that year's papers)
- 2022: 6 Unit 2 questions asked (36 marks across that year's papers)
- 2021: 5 Unit 2 questions asked (34 marks across that year's papers)