Follow US



7839 views

Database Management Systems (DBMS) - 2012 Important Questions

Author Message
Rejinpaul
Banned
Banned

Posts: 35 Joined: May 2012 Status: OFFLINE
Rupees: Rs.-24.70
Post: #1
Database Management Systems (DBMS) - 2012 Important Questions

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
  080230069 Cloud computing Important Questions - All Units Srini 0 223 03-04-2014 07:54 AM
Last Post: Srini
  ELECTRIC CIRCUITS AND ELECTRON DEVICES - Two Marks Important Questions Srini 4 4,209 25-01-2014 09:56 AM
Last Post: pujimani
  ME2352 Design Transmission Systems 2 marks with answer - Rdx Rdx 7 1,201 28-12-2013 06:36 PM
Last Post: V SIVA
Thumbs Up ANNA UNIV- BASIC INDUSTRIAL BIOTECHNOLOGY- IMPORTANT 16 MARKS indiainspire 1 332 05-12-2013 01:27 PM
Last Post: Rdx
  ANNA UNIV- BT2255 MICROBIOLOGY IMPORTANT 16 MARKS indiainspire 2 383 04-12-2013 10:59 AM
Last Post: indiainspire
(This post was last modified: 16-05-2012 08:35 AM by Rejinpaul.)
16-05-2012 08:35 AM
www Find Quote



Vidyarthiplus | Contact Us | Return to Top | Lite (Archive) Mode


Powered By MyBB, © 2002-2014MyBB Group.

Powered by V+ Team