Database Management System PYQ 2018-19 AKTU Question Paper

AKTU · BTECH · Semester 5 · Database Management System · Session 2018-19 · PYQ

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

  1. Q1a. Explain the difference between a weak and a strong entity set with example. (2 marks, 2018-19)
  2. Q1b. Discuss three level of abstractions or schemas architecture of DBMS (2 marks, 2018-19)
  3. Q1c. Define constraint and its types in DBMS. (2 marks, 2018-19)
  4. Q1d. Explain the difference between physical and logical data independence with example. (2 marks, 2018-19)
  5. Q1e. What are the different types of anomalies associated with database? (2 marks, 2018-19)
  6. Q1f. Write the difference between super key and candidate key. (2 marks, 2018-19)
  7. Q1g. Why do we normalize database? (2 marks, 2018-19)
  8. Q2a. Define Transaction and explain its properties with suitable example. (7 marks, 2018-19)
  9. Q2b. What is schedule? What are its types? Explain view serializable and cascadeless schedule with suitable example of each. (7 marks, 2018-19)
  10. Q2c. What is log file? Write the steps for log based recovery of a system with suitable example. (7 marks, 2018-19)
  11. Q2d. What is deadlock? What are necessary conditions for it? How it can be detected and recovered? (7 marks, 2018-19)
  12. Q2e. Draw overall structure of DBMS and explain its components in brief. (7 marks, 2018-19)
  13. Q3a. Compare Generalization, Specialization and aggregation with suitable examples. (7 marks, 2018-19)
  14. Q3b. Write difference between Cross Join, Natural Join, left outer join and right outer join with suitable example. (7 marks, 2018-19)
  15. Q4a. Define partial functional dependency. Consider the following two sets of functional dependencies F = {A→C, AC→D, E→AD, E→H} and G = {A→CD, E→AH}. Check whether or not they are equivalent. (7 marks, 2018-19)
  16. Q4b. Define Minimal Cover. Suppose a relation R (A,B,C) has FD set F = {A→B, B→C, A→C, AB→B, AB→C, AC→B} convert this FD set into minimal cover. (7 marks, 2018-19)
  17. Q5a. Explain two phase locking protocol with suitable example. (7 marks, 2018-19)
  18. Q5b. Write the salient features of graph based locking protocol with suitable example (7 marks, 2018-19)
  19. Q6a. Which of the following schedules are conflicts serializable? For each serializable schedule find the equivalent schedule. S1: r1(x); r3(x); w3(x); w1(x); r2(x) S2: r3(x); r2(x); w3(x); r1(x); w1(x) S3: r1(x); r2(x); r3(y); w1(x); r2(z); r2(y); w2(y) (7 marks, 2018-19)
  20. Q6b. Write the difference between 3NF and BCNF. Find normal form of relation R(A,B,C,D,E) having FD set F = {A→B, BC→E, ED→A}. (7 marks, 2018-19)
  21. Q7a. Suppose there are two relations R(A, B, C), S(D, E, F) Write TRC and SQL for the following RAs i) Π_{A,B}(r) ii) σ_{B=45}(r) iii) Π_{A,F}(σ_{C=D}(r × s)) (7 marks, 2018-19)
  22. Q7b. What do you mean by multi granularity? How the concurrency is maintained in this case. Write the concurrent transactions for the following graph. [Original supplied directed graph: A→B, A→E, B→C, B→D, E→F, E→G.] T1 wants to access Item C in read mode T2 wants to access item D in Exclusive mode T3… (7 marks, 2018-19)

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