Database Management System PYQ 2019-20 AKTU Question Paper

Database Management System AKTU syllabus

1. Unit 1: Introduction and ER Model
2. Unit 2: Relational Model and SQL
3. Unit 3: Database Design and Normalization
4. Unit 4: Transaction Processing and Distributed DB
5. Unit 5: Concurrency Control Techniques

Questions in Database Management System AKTU PYQ 2019-20

1. Q1a. What is Relational Algebra? (2 marks, 2019-20)
2. Q1b. Explain normalization. What is normal form? (2 marks, 2019-20)
3. Q1c. What do you mean by Aggregation? (2 marks, 2019-20)
4. Q1d. Define Super key, Candidate key, Primary key & foreign key (2 marks, 2019-20)
5. Q1e. What is Strong & Weak Entity set? (2 marks, 2019-20)
6. Q1f. What do you mean by Conflict Serializable Schedule? (2 marks, 2019-20)
7. Q1g. Define Concurrency Control. (2 marks, 2019-20)
8. Q2a. Explain data independence with its types. (7 marks, 2019-20)
9. Q2b. Describe mapping constraints with its types. (7 marks, 2019-20)
10. Q2c. Define Key. Explain various types of keys. (7 marks, 2019-20)
11. Q2d. Explain the phantom phenomena. Discuss a Time Stamp Protocol that avoids the phantom phenomena. (7 marks, 2019-20)
12. Q2e. What are Distributed Database? List advantage and disadvantage of data Replication And data Fragmentation. (7 marks, 2019-20)
13. Q3a. Define Join. Explain different types of join. (7 marks, 2019-20)
14. Q3b. Discuss the following terms (i) DDL Command (ii) DML command (7 marks, 2019-20)
15. Q4a. What is tuple relational calculus and domain relational calculus? (7 marks, 2019-20)
16. Q4b. Describe the following terms : (i) Multivalued dependency (ii) Trigger (7 marks, 2019-20)
17. Q5a. What do you understand by ACID properties of transaction? Explain in details. (7 marks, 2019-20)
18. Q5b. Discuss about deadlock prevention schemes. (7 marks, 2019-20)
19. Q6a. Explain Concurrency Control. Why it is needed in database system? (7 marks, 2019-20)
20. Q6b. Give the following queries in the relational algebra using the relational schema: student(id, name) enrolled(id, code) subject(code, lecturer) i) What are the names of students enrolled in cs3020? ii) Which subjects is Hector taking? iii) Who teaches cs1500? iv) Who teaches cs1500 or cs3020? v)… (7 marks, 2019-20)
21. Q7a. Explain Directory System in detail. (7 marks, 2019-20)
22. Q7b. 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) i) Finds the names of all… (7 marks, 2019-20)

Database Management System previous year papers

• PYQ 2025-26
• PYQ 2024-25
• PYQ 2023-24
• PYQ 2022-23
• PYQ 2021-22
• PYQ 2020-21
• PYQ 2018-19
• PYQ 2017-18

More Database Management System resources

• Important Questions: Unit 1 Important Questions
• Important Questions: Unit 2 Important Questions
• Important Questions: Unit 3 Important Questions
• Important Questions: Unit 4 Important Questions
• Important Questions: Unit 5 Important Questions
• Important Questions: Important Questions (All Units)
• Notes: Unit 1 Notes
• Notes: Unit 2 Notes
• Notes: Unit 3 Notes
• Notes: Unit 4 Notes
• Notes: Unit 5 Notes
• Notes: Notes (All Units)

Database Management System exam preparation

• Database Management System Important Topics
• Database Management System PYQ Analysis (unit-wise)
• Database Management System Predicted Paper
• Database Management System Important Questions