Hello There, Guest! Register
Login with Facebook

Anna University April/May/June 2015 UG/PG Theory and Practical Exam Timetable
ZARIUS'15 - National level Technical Symposium - PPG Institute of Technology
Anna University Internal Assessment Schedule for May/June 2015 Exam
Anna University Question Papers : Nov Dec 2014 and Jan 2015 Question Papers | April May June 2014 Question Papers
Anna University Study Materials for all Departments

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

Don't Destroy your Notes - Sell your Lecture Notes on Vidyarthiplus (V+)

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
  GE6351-Environmental science And Engineering Nov Dec 2014 Important Question kavi 4 1,730 04-12-2014, 02:58 PM
Last Post: Aravindhan Manogaran
  GE6251 Basic Civil And Mechanical Engg Nov Dec 2014 Important question kavi 0 512 03-12-2014, 06:47 PM
Last Post: kavi
  AT6032 Mechanics Of Machines Nov Dec 2014 Important Question kavi 0 603 03-12-2014, 04:56 PM
Last Post: kavi
  EC2312-Microprocessor and Microcontroller Nov Dec 2014 Important Question V+ Rajee 0 569 03-12-2014, 11:54 AM
Last Post: Rajee
  EC2304 Microprocessors And Microcontrollers Important Questions - Anand Edition Anandec 1 976 30-08-2014, 07:54 AM
Last Post: Srini
  080230069 Cloud computing Important Questions - All Units Srini 0 1,552 03-04-2014, 07:54 AM
Last Post: Srini
  ELECTRIC CIRCUITS AND ELECTRON DEVICES - Two Marks Important Questions Srini 4 5,828 25-01-2014, 09:56 AM
Last Post: pujimani
  ME2352 Design Transmission Systems 2 marks with answer - Rdx Rdx 7 4,195 28-12-2013, 06:36 PM
Last Post: V SIVA
Thumbs Up ANNA UNIV- BASIC INDUSTRIAL BIOTECHNOLOGY- IMPORTANT 16 MARKS indiainspire 1 1,349 05-12-2013, 01:27 PM
Last Post: Rdx
  ANNA UNIV- BT2255 MICROBIOLOGY IMPORTANT 16 MARKS indiainspire 2 1,239 04-12-2013, 10:59 AM
Last Post: indiainspire
Reply


Subscribe


Recommend on Google

Latest Threads
-> GATE Civil Engineering 2013 Question Paper
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> Geopolymer Concrete - Seminar Lecture Notes - Aravinth Edition
Forum : Civil Technical Seminar
Last Post : Aravindhan Manogaran
-> Energy use in building - Seminar topics
Forum : Unapproved Threads
Last Post : Aravindhan Manogaran
-> Brand Communication Conclave to be held on 1st March, 2015 at SIMC (PG), Pune
Forum : Announcements
Last Post : Aravindhan Manogaran
-> IIIT Guwahati Job Vacancy For Professor
Forum : Job Recruitments
Last Post : Aravindhan Manogaran
-> Latest Technical and Non-Technical Symposium , Workshop , Conference Details
Forum : College Events
Last Post : Aravindhan Manogaran
-> Anna University Last Date for Applying Revaluation of Answer Script for Nov / De...
Forum : Anna University Exam Cell
Last Post : Aravindhan Manogaran
-> GATE Civil Engineering Paper 2012 (Objective Type)
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> Gate Civil 2006 Question Paper with Answer Key
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> useful website for civil engineers.
Forum : Link Heaven
Last Post : Aravindhan Manogaran
-> GATE 2012 Civil Engineering Question Paper - Non Objective Type Questions
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> Gate Civil 2005 Question Paper with Keys
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> GATE Civil 2003 Question Paper with Keys
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> Gate Civil 1999 Question Paper with Keys
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran
-> Gate Civil 1998 Question Paper with Keys
Forum : Gate Question Papers
Last Post : Aravindhan Manogaran