Hello There, Guest! RegisterLogin with Facebook
Login with Facebook

Anna University TNEA 2018 Rank List Published. Login to know your Rank.
Anna University April May 2018 Exam Results
Anna University Latest News , Updates and Announcements
>>> Anna University Sixth Semester Question Bank Collection (R2013) ECE,MECH,CSE,IT,EEE,CIVIL,EIE
>>> Anna University Study Materials for all Departments
>>> Anna University Question Papers : April May June 2015 Question Papers | Nov Dec 2014 and Jan 2015 Question Papers

Register or Login to Submit Study Materials , Shoutbox and also to access Many Features !!

Vidyarthiplus Shop :: Handwritten Premium Lecture Notes
Share your Study Materials with us
Share your Study Materials with us : Click Here

Database Management Systems (DBMS) - 2012 Important Questions
#1


Anna University Examination 2012 Important Questions

Database Management Systems
Subject Code : 141405
Subject Name : Database Management Systems

Common To

Tirunelveli, Madurai, Coimbatore, Tirchy All Over Tamil Nadu engineering colleges


Unit I


1. Discuss in detail about the database management system architecture with neat diagram?

2. Explain the different types of data model in detail with suitable examples

3. Describe the components of E- R diagram with example? [Ex: Library management system, Hospital management system any example they may ask]

4. Explain the different types of keys used in dbms discuss about database users and administrator


Unit II

1. Discuss the fundamental operations in relational algebra operations with suitable example.

2. Explain the following with suitable example
(i) Integrity Constraints
(ii) Distributed and Client server databases

3. What are aggregate functions? Discuss with examples, the various aggregate functions used in SQL?

4. With relevant examples discuss the following in SQL?
(i) DDL
(ii)DML
(iii)DCL
(iv) Views


Unit III

1. What is normalization? Explain 1NF, 2NF, 3NF and BCNF with suitable example.

2. Discuss on two-phase locking protocol and time-based protocol in detail?

3. Explain non-loss decomposition and functional dependencies with suitable examples

4. Discuss how schema refinement an improve schemas obtained through ER design


Unit IV

1. Explain different forms of serializability?

2. State and explain in detail about three concurrency problems

3. Why is recovery needed? Discuss any two recovery techniques?

4. Explain in detail about different locking protocols in detail.


Unit V

1. Discuss in detail about the different RAID Levels?

2. Illustrate the purpose of indexing .How indexing can be done by B+ tree. Explain.

3. Describe the different types of file organization? Explain using a sketch of each of them With their advantages and disadvantages

4. Explain the various complex selection predicates and sorting operations with an example




Possibly Related Threads...
Thread Author Replies Views Last Post
  Important Questions for Fly by wire Systems Vidhy Arthi 0 908 12-03-2015, 03:28 PM
Last Post: Vidhy Arthi
  080250009 Database Management Systems Unit 1 Important Questions WR1334 0 2,184 23-04-2013, 05:22 AM
Last Post: WR1334
  CE2305 Foundation Engineering Nov / Dec 2012 Important Questions rajsathya 1 5,303 05-12-2012, 04:42 PM
Last Post: Anna University
  PRINCIPLES OF COMPILER DESIGN 2012 Important Questions Srini 1 8,635 04-12-2012, 11:37 AM
Last Post: Karthickvijay
  080250022 Design and Analysis of Algorithm Important Questions - 2012 Edition WR1334 3 3,273 04-12-2012, 11:01 AM
Last Post: WR1334
  CS2303 Theory of Computation - Important Questions 2012 Edition (Scan Version) Anna University 0 4,408 02-12-2012, 02:35 PM
Last Post: Anna University
  EC2205 Electronic Circuits- I - Important Questions - V+ 2012 Edition Anna University 1 2,366 27-11-2012, 01:31 PM
Last Post: abinaya
  Software project management - Important Questions - Lonely 2012 Edition Mr.lonely 0 1,620 20-11-2012, 11:17 PM
Last Post: Mr.lonely
  EC2351 Measurements and Instrumentation Important Questions - 2012 Edition Anna University 0 6,401 07-11-2012, 07:06 PM
Last Post: Anna University
  EC2311 Communication Engineering - Important Questions - Oct 2012 V+ Edition Anna University 0 3,573 21-10-2012, 07:47 AM
Last Post: Anna University
Reply

Subscribe


Recommend on Google



Vidyarthiplus Whatsapp