Database Management System PYQ 2020-21 AKTU Question Paper

AKTU · BTECH · Semester 5 · Database Management System · Session 2020-21 · PYQ

AKTU Database Management System previous year question paper 2020-21 for B.Tech Semester 5. Covers Introduction and ER Model, Relational Model and SQL…

Open the interactive reader to study this resource on AcademicArk.

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 2020-21

  1. Q1a. What is Data Independency in DBMS? (2 marks, 2020-21)
  2. Q1b. Write the difference between DDL and DML. (2 marks, 2020-21)
  3. Q1c. What are different Integrity Constraints? (2 marks, 2020-21)
  4. Q1d. Explain different Features of SQL. (2 marks, 2020-21)
  5. Q1e. What are advantages of normalization? (2 marks, 2020-21)
  6. Q1f. Write different Inference Rule for Functional Dependency? (2 marks, 2020-21)
  7. Q1g. What are ACID properties of Transaction? (2 marks, 2020-21)
  8. Q1h. What are various reasons for transaction failure? (2 marks, 2020-21)
  9. Q1i. What are Concurrent Transactions? (2 marks, 2020-21)
  10. Q1j. What is Lock in Transaction Management? (2 marks, 2020-21)
  11. Q2a. What is ER Diagram? Explain different Components of an ER Diagram with thier Notation. Also make an ER Diagram for Employee Project Management System. (10 marks, 2020-21)
  12. Q2b. What is Relational Algebra? Explain Different Operations of Relational Algebra with Example. (10 marks, 2020-21)
  13. Q2c. (i) What is highest normal form of the Relation R(W,X,Y,Z) with the set F= { WY → XZ, X →Y } (ii) Consider a relation R(A,B,C,D,E) with set F= { A→CD, C→B,B→AE} What are the prime attributes of this Relation and Decompose the given relation in 3NF. (10 marks, 2020-21)
  14. Q2d. Explain the method of testing the serializability. Consider the schedule S1 and S2 given below S1: R1(A),R2(B),W1(A),W2(B) S2: R2(B),R1(A),W2(B), W1(A) Check whether the given schedules are conflict equivalent or not? (10 marks, 2020-21)
  15. Q2e. Explain the Validation Based protocol for concurrency control. (10 marks, 2020-21)
  16. Q3a. What is Data Abstraction? How the Data Abstraction is achieved in DBMS? (10 marks, 2020-21)
  17. Q3b. Explain the following with example (i) Generalization (ii) Specialization (iii) Aggregation (10 marks, 2020-21)
  18. Q4a. What is Aggregate Function in SQL? Write SQL query for different Aggregate Function. (10 marks, 2020-21)
  19. Q4b. Explain Procedure in SQL/PL SQL. (10 marks, 2020-21)
  20. Q5a. What is Functional Dependency? Explain the procedure of calculating the Canonical Cover of a given Functional Dependency Set with suitable example. (10 marks, 2020-21)
  21. Q5b. (i) Consider the relation R(a,b,c,d) with Set F={a→c,b→d}. Decompose this relation in 2 NF. (ii) Explain the Loss Less Decomposition with example. (10 marks, 2020-21)
  22. Q6a. What is Conflict Serializable Schedule? Check the given Schedule S1 is Conflict Serializable or not? S1: R1(X), R2(X),R2(Y),W2(Y),R1(Y),W1(X) (10 marks, 2020-21)
  23. Q6b. Explain Deadlock Handling with Suitable Example (10 marks, 2020-21)
  24. Q7a. Explain Time Stamp Based Concurrency Control technique. (10 marks, 2020-21)
  25. Q7b. Explain Recovery from Concurrent Transaction. (10 marks, 2020-21)

AKTU paper codes: BCS501, KCS501, RCS501

Database Management System previous year papers

More Database Management System resources

Browse all notes · Semester 5 notes · Database Management System notes