Go Back   2023 2024 MBA > MBA > Main Forum > UPTU DBMS Question Paper

Thread: UPTU DBMS Question Paper Reply to Thread
Your Username: Click here to log in
Title:
  
Message:
Trackback:
Send Trackbacks to (Separate multiple URLs with spaces) :
Post Icons
You may choose an icon for your message from the following list:
 

Additional Options
Miscellaneous Options

Topic Review (Newest First)
12th November 2016 12:48 PM
shikha
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





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
12th November 2016 12:31 PM
Unregistered
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?

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT +5.5. The time now is 10:42 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