B.TechSemester 62023-24Basics Of Data Base Management SystemKOE067H
View PDFDownload

Basics Of Data Base Management System (KOE067H) - AKTU Question Paper 2023-24

B.Tech · Semester 6 · Free PDF Download

This is the official AKTU Basics Of Data Base Management System Previous Year Question Paper for B.Tech Semester 6, academic session 2023-24. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:B.Tech
Semester:Semester 6
Session:2023-24
University:AKTU / UPTU

Rate this paper

Questions Asked in 2023-24

Basics Of Data Base Management System (KOE067H) — complete question paper · 100 marks · 3 Hours

Section BAttempt any three o f t h e f o l l o w i n g :
  • a
    Discuss the concepts of genera lization and aggregation in the ER model. Provide examples to explain how these concepts are used to simplify and o r g a n i z e complex data relationships and how they can be represented in an ER diagram
  • b
    Compare and contrast tuple re lational calculus and domain re lational calculus. Provide examples to demonstrate how queries are formulated in e a c h t y p e o f relational calculus
  • c
    Explain the concept of database triggers in PL/SQL. Discuss the different types of triggers (BEFORE, AFTER, INS TEAD OF) and provide examples of how triggers can be used to enforce business rules and maintain data integrity
  • d
    Explain log-based recovery in a database management system. Discuss the purpose of logs, different types of logs (e.g., undo log, redo log), and how checkpoints are used in conjunction with logs to facilitate efficient recovery from transaction failures
  • e
    Compare and contrast centra lized and client-server architect ures in database management systems. Discuss the advantages and disadvantages of each architecture, including scalability, performance, and ease of maintenance
Section CAttempt any one p a r t o f t h e f o l l o w i n g :
  • a
    Explain the process of transfo rming an Entity-Relationship ( ER) diagram into relational tables. Use an example to illustrate how entities an d relationships are converted into tables and how primary keys and foreign keys are used to maintain relationships between tables
  • b
    Detail the roles and responsibilities of a database administ rator (DBA). Explain how a DBA ensures database securi ty, performance, and recovery, and describe the tools and techniques they might use to perform these tasks
  • a
    Explain the concept of functi onal dependencies and their role in the normalization process. Discuss how functional dependencies are used to identify normal forms and provide examples to illustrate the first, second, and third normal forms
  • b
    What is a lossless join decomposition in the context of data base normalization? Explain the criteria for a decomposition to be lossless and provide an example of how a relational schema can be decomposed in a way that preserves data integrity
  • a
    Explain the concept of joins in SQL and describe the differe nt types of joins (inner join, left join, right join, full outer join). Provide SQL examples for each type of join and discuss scenarios where each would be appropriately used
  • b
    Explain the transaction control commands in SQL (COMMIT, ROL LBACK, SAVEPOINT). Discuss the importance of transactions in maintaini ng data integrity and consistency, and provide examples of how these commands are used in practice
  • a
    Describe time-stamping protocols for concurrency control. Ex plain how time stamps are assigned and used to manage the order of transactions and discuss the benefits and potential drawbacks of using time-stamping protocols
  • b
    Describe multi-version concurre ncy control (MVCC) in a datab ase management system. Explain how MVCC allows for multiple versions of data i tems and discuss the advantages of MVCC over single-version techniques. Provide examples to illustrate how MVCC handles concurrent transactions
  • a
    Explain the different levels o f security in a database envir onment, including physical security, operating system (OS) security, network secu rity, and DBMS security. Discuss the measures taken at each level to protect against unauthorized access, data breaches, and other security threats
  • b
    Explain the concepts of data mining, data warehousing, and d ecision support systems (DSS) in the context of database management systems

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.

Basics Of Data Base Management System — Other Year Papers

AKTU Basics Of Data Base Management System PYQs from other sessions

Basics Of Data Base Management System2021-22Basics Of Data Base Management System2022-23Basics Of Data Base Management System2024-25

More B.Tech Semester 6 (2023-24) Papers

Other subjects from same semester and session

Gis Remote Sensing2023-24Gas Dynamics And Jet Propulsion2023-24Foundation Design2023-24Advance Structural Analysis2023-24Microprocessor And Microcontroller2023-24Nondestructive Testing2023-24Introduction To Mems2023-24Real Time Systems2023-24
View all B.Tech Semester 6 2023-24 papers →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

AKTU 3rd Year PYQs — All Branches