MCASemester 22022-23Database Management SystemsKCA-204
View PDFDownload

Database Management Systems (KCA-204) - AKTU Question Paper 2022-23

MCA · Semester 2 · Free PDF Download

This is the official AKTU Database Management Systems Previous Year Question Paper for MCA Semester 2, academic session 2022-23. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:MCA
Semester:Semester 2
Session:2022-23
University:AKTU / UPTU

Rate this paper

Questions Asked in 2022-23

Database Management Systems (KCA-204) — complete question paper

Section AAttempt all questions in brief. 2 x 10 = 20
  • a
    Define the terms Data and Database
  • b
    Discuss various advantages of DBMS?
  • c
    Define cursor in PL/SQL
  • d
    What do you mean by sub-queries?
  • e
    Why normalization is used?
  • f
    What is pseudo-transitivity?
  • g
    Define serializable schedule
  • h
    What do you mean by transaction failure? (i) Define concurrent processing in database. (j) What do you mean by dispatcher in terms of Oracle?
Section BAttempt any three of the following: 10 x 3 = 30
  • a
    Discuss ANSI/SPARC architecture in detail
  • b
    Create a table Employee(Emp_id, Emp_name, Emp_add, Emp_basicpay) and insert some records in it. Create another table Emp_detail (Emp_name, Emp_add) from Employee table by using SELECT statement
  • c
    Explain basic inference rules applied on the set of functional dependencies. Suppose R with attributes A, B, C, D, E, F have the FDs A BC, B E, CD EF. Prove that FD : AD F also holds in R
  • d
    Write short note on Testing of serializability
  • e
    What are various types of Locks applied on data ite ms? Discuss Two-phase locking protocol and Strict Two-phase locking protocols
Section CAttempt any one part of the following: 10 x 1 = 10
  • a
    Discuss various types of Entity, Attribute and Rela tion used in designing an ER- diagram
  • b
    What are various types of databases? Discuss them
  • a
    Create the tables Supplier(SNo, SName, City), Parts(PNo, Pname, Color, City), and Shipment(SNo, PNo, Quantity). Answer the following queries : (i) Get the total number of suppliers. (ii) Get the total number of suppliers currently supplying parts. (iii) Get part numbers of all parts supplied. (iv) Change the color of parts from red to black
  • b
    Discuss Primary Key, Unique Key, Candid ate Key and Foreign Key by taking examples
  • b
    How will you check that the decomposition of a rela tion on a given set of functional dependencies is dependency preserving? Discuss with the help of an example
  • a
    Explain ACID properties of a transaction in detail
  • b
    Write short note on Log -Based Recovery
  • a
    What is Timestamp Ordering Protocol? Discuss workin g of Basic Timestamp ordering protocol along with advantages and disadvantages of it
  • b
    Write short note on Multiple Granularity

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

Database Management Systems — Other Year Papers

AKTU Database Management Systems PYQs from other sessions

Database Management Systems2021-22Database Management Systems2023-24Database Management Systems2024-25Database Management Systems2024-25

More MCA Semester 2 (2022-23) Papers

Other subjects from same semester and session

Cyber Security2022-23Data Structures Analysis Of Algorithms2022-23Object Oriented Programming2022-23Theory Of Automata Formal Languages2022-23Operating Systems2022-23
View all MCA Semester 2 2022-23 papers →