2023 2024 MBA

2023 2024 MBA (https://mba.ind.in/forum/)
-   Main Forum (https://mba.ind.in/forum/main-forum/)
-   -   UPTU DBMS Question Paper (https://mba.ind.in/forum/uptu-dbms-question-paper-419023.html)

Unregistered 12th November 2016 12:31 PM

UPTU DBMS Question Paper
 
I am student of Dr. A.P.J. Abdul Kalam Technical University, Lucknow and looking for the DBMS question paper. Can you provide me UPTU DBMS Question Paper so that I can prepare well for university exam and also provide me complete DBMS subject syllabus to know topics?

shikha 12th November 2016 12:48 PM

Re: UPTU DBMS Question Paper
 
Dr. A.P.J. Abdul Kalam Technical University, Lucknow formerly Uttar Pradesh Technical University is a public university in the Indian state of Uttar Pradesh set up by the government of Uttar Pradesh on 8 May 2000

https://mba.ind.in/img/c/UPTU-DBMS-Question-Paper-1.jpg
https://mba.ind.in/img/c/UPTU-DBMS-Question-Paper-2.jpg
https://mba.ind.in/img/c/UPTU-DBMS-Question-Paper-3.jpg

As per your request below I am providing you the UPTU DBMS Question Paper:

DBMS Syllabus:

UNIT I INTRODUCTION AND CONCEPTUAL MODELING: Introduction to File and Database systems- Database system structure Data Models Introduction to Network and Hierarchical Models ER model Relational Model Relational Algebra and Calculus.

UNIT II RELATIONAL MODEL: SQL Data definition- Queries in SQL- Updates- Views Integrity and Security Relational Database design Functional dependencies and Normalization for Relational Databases (up to BCNF).

UNIT III DATA STORAGE AND QUERY PROCESSING: Record storage and Primary file organization- Secondary storage Devices- Operations on Files- Heap File- Sorted Files- Hashing Techniques Index Structure for files Different types of Indexes- B-Tree - B+Tree Query Processing.

UNIT IV TRANSACTION MANAGEMENT: Transaction Processing Introduction- Need for Concurrency control- Desirable properties of Transaction- Schedule and Recoverability- Serializability and Schedules Concurrency Control Types of Locks- Two Phases locking- Deadlock- Time stamp based concurrency control Recovery Techniques Concepts- Immediate Update- Deferred Update - Shadow Paging.

UNIT V CURRENT TRENDS: Object Oriented Databases Need for Complex Data types- OO data Model- Nested relations- Complex Types- Inheritance Reference Types - Distributed databases- Homogenous and Heterogenous- Distributed data Storage XML Structure of XML- Data- XML Document- Schema- Querying and Transformation. Data Mining and Data Warehousing

Contact:

Dr. A.P.J. Abdul Kalam Technical University
IET Campus, Sitapur Road
Lucknow, Uttar Pradesh 226021
Phone: 0522 273 2193


All times are GMT +5.5. The time now is 03:57 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2


1 2