Database Management System PYQ 2021-22 AKTU Question Paper

AKTU · BTECH · Semester 5 · Database Management System · Session 2021-22 · PYQ

AKTU Database Management System previous year question paper 2021-22 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 2021-22

  1. Q1a. What is the significance of Physical Data Independence? (2 marks, 2021-22)
  2. Q1b. List the four functions of DBA. (2 marks, 2021-22)
  3. Q1c. When a relation set is called a recursive relationship set? (2 marks, 2021-22)
  4. Q1d. What do you mean by currency with respect to database? (2 marks, 2021-22)
  5. Q1e. What is Relational Calculus? (2 marks, 2021-22)
  6. Q1f. What is Equi-Join in database? (2 marks, 2021-22)
  7. Q1g. What is a CLAUSE in terms of SQL? (2 marks, 2021-22)
  8. Q1h. Define the closure of an attribute set. (2 marks, 2021-22)
  9. Q1i. When is a transaction Rolled Back? (2 marks, 2021-22)
  10. Q1j. List the various levels of locking? (2 marks, 2021-22)
  11. Q2a. Draw the overall structure of DBMS and explain its various components. (10 marks, 2021-22)
  12. Q2b. Which relational algebra operations require the participating tables to be union-compatible? Give the Reason in detail. (10 marks, 2021-22)
  13. Q2c. What do you understand by transitive dependencies? Explain with an example any two problems that can arise in the database if transitive dependencies are present in the database. (10 marks, 2021-22)
  14. Q2d. List ACID properties of transaction. Explain the usefulness of each. What is the importance of log? (10 marks, 2021-22)
  15. Q2e. What do you mean by time stamping protocol for concurrency controlling? Discuss multi version scheme of concurrency control. (10 marks, 2021-22)
  16. Q3a. What are the different types of Data Models in DBMS? Explain them. (10 marks, 2021-22)
  17. Q3b. State the procedural DML and nonprocedural DML with their differences. (10 marks, 2021-22)
  18. Q4a. 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 and relational algebra: I. List roll number and name of all students of the branch 'CSE'.… (10 marks, 2021-22)
  19. Q4b. What do you mean by trigger? Explain it by a suitable example. (10 marks, 2021-22)
  20. Q5a. Describe Armstrong's axioms in detail. What is the role of these rules in database development process? (10 marks, 2021-22)
  21. Q5b. Describe the term MVD in the context of DBMS by giving an example. Discuss 4NF and 5NF also. (10 marks, 2021-22)
  22. Q6a. Describe serializable schedule. Discuss conflict serializability with suitable example. (10 marks, 2021-22)
  23. Q6b. Discuss the procedure of deadlock detection and recovery in transaction? (10 marks, 2021-22)
  24. Q7a. Given a schedule S for transactions T1 and T2 with set of read and write operations, S: R1(X) R2(X) R2(Y) W2(Y) R1(Y) W1(X). Identify, whether given schedule is equivalent to serial schedule or not? (10 marks, 2021-22)
  25. Q7b. Discuss 2 phase commit (2PC) protocol and time stamp based protocol with suitable example. How the validation based protocols differ from 2PC? (10 marks, 2021-22)

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