Hello There, Guest! Register
Login with Facebook

Anna university Results 8th sem April May 2015 Announced
Anna University April May June 2015 Semester Exams Important Questions and Study Materials
Anna University B.E/B.Tech May/June 2015 Gracemark Details
Anna University Question Papers : April May June 2015 Question Papers | Nov Dec 2014 and Jan 2015 Question Papers
Anna University Study Materials for all Departments

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

Anna University Academic Schedule and Re-opening Dates 2015-2016

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
  Aerodynamics I Important Questions V Unit Vidhyarthi 1 0 38 14-05-2015, 11:47 AM
Last Post: Vidhyarthi 1
  Aerodynamics I Important Questions IV Unit Vidhyarthi 1 0 23 14-05-2015, 11:46 AM
Last Post: Vidhyarthi 1
  Aerodynamics I Important Questions III Unit Vidhyarthi 1 0 24 14-05-2015, 11:44 AM
Last Post: Vidhyarthi 1
  Aerodynamics I Important Questions II Unit Vidhyarthi 1 0 25 14-05-2015, 11:43 AM
Last Post: Vidhyarthi 1
  Aerodynamics I Important Questions 16 marks Vidhyarthi 1 0 33 14-05-2015, 11:42 AM
Last Post: Vidhyarthi 1
  Aerodynamics I Important Questions Vidhyarthi 1 0 20 14-05-2015, 11:41 AM
Last Post: Vidhyarthi 1
  Important scheduling 4 marks Vidhyarthi 1 0 71 13-05-2015, 01:48 PM
Last Post: Vidhyarthi 1
  Important scheduling 2 marks Vidhyarthi 1 0 99 13-05-2015, 01:45 PM
Last Post: Vidhyarthi 1
  Important material-handling system 2 marks Vidhyarthi 1 0 32 13-05-2015, 01:34 PM
Last Post: Vidhyarthi 1
  Important Flexible manufacturing system 10 marks Vidhyarthi 1 0 29 13-05-2015, 01:31 PM
Last Post: Vidhyarthi 1
Reply

Subscribe


Recommend on Google

Latest Threads
-> Anna University Webportal is opened for profile correction
Forum : Anna University Exam Cell
Last Post : Aravindhan Manogaran
-> R7210106 - Fluid Mechanics May 2013 Question Paper
Forum : JNTUH Question Papers
Last Post : Aravindhan Manogaran
-> R7210101 - Mathematics-II May 2012 Question Paper
Forum : JNTUH Question Papers
Last Post : Aravindhan Manogaran
-> R7210102 - Electrical and Electronics Engineering May 2012 Question Paper
Forum : JNTUH Question Papers
Last Post : Aravindhan Manogaran
-> R7210103 - Strength Of Materials-I May 2012 Question Paper
Forum : JNTUH Question Papers
Last Post : Aravindhan Manogaran
-> R31055 - Microprocessor and Multicore Systems June/July 2014 Question Paper (ALL...
Forum : JNTUH Question Papers
Last Post : Aravindhan Manogaran
-> SLE - Earning details (Updated)
Forum : Share Learn and Earn (SLE)
Last Post : Jeba Princy
-> RR-0507-R Problems of Indian Economic Development March/April-2010 Question pape...
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> RR-0243 Political Science: Paper - VII March/April - 2010 Question paper
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> RE-3690-91 Microbiology : Paper - V April/May-2010 Question paper
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> UA-2506 Economics September/ October-2012 Question paper
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> JD-4381 Education management : Paper - II May/June-2013 Question paper
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> RF-4832 502 : Unix Internals and Shell Programming April/May - 2010 Question pap...
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> SA-1026 Dairying & poultry March/April - 2011 Question paper
Forum : Unapproved Threads
Last Post : C.Krishna Kumar
-> UA-0305 ECT - 1.01 : Sanskrit - IV - A March/April - 2012 Question paper
Forum : Unapproved Threads
Last Post : C.Krishna Kumar