Hello There, Guest! RegisterLogin with Facebook
Login with Facebook

Tamil Nadu Schools and College Leave Due to Dr. A.P.J Abdul Kalam Funeral
FORNYA 5 - National Level Technical Symposium - Velammal Engineering College
Anna University April May June 2015 PG 2nd & 4th Semester Exam Results Announced
Staff Selection Commission (SSC) Junior Engineer Recruitment 2015
TNPSC CCS-I Exam (Group-I Services) Recruitment 2015
Anna University Internal Assessment Schedule for Nov./Dec. 2015 Examinations (UG/PG Odd Semesters)
>>> Anna University Arrear Examinations Nov / Dec - 2015 Starts From 2nd September - 2015 (Tentatively)
Tamil Nadu Engineering Admission TNEA 2015 Vacancy Position details for Academic General Counselling
>>> TANCET 2015 Unofficial Ranklist
>>> Anna University Chennai B.E./B.TECH All Semester Syllabus Regulation 2013
>>> Anna University Question Papers : April May June 2015 Question Papers | Nov Dec 2014 and Jan 2015 Question Papers
TANCET 2015 Ranklist

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

Vidyarthiplus Premium Lecture Notes

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
  Strategic Human Resource Management - MBA Model Question Anna University of Technology Tirunelveli Mathi Subhash 0 174 30-03-2015, 06:05 PM
Last Post: Mathi Subhash
  Important Questions for Integrated Product Development Vidhy Arthi 2 236 12-03-2015, 07:21 PM
Last Post: Aravindhan Manogaran
  Important Questions for Fly by wire Systems Vidhy Arthi 0 177 12-03-2015, 03:28 PM
Last Post: Vidhy Arthi
  GE6351-Environmental science And Engineering Nov Dec 2014 Important Question kavi 4 2,489 04-12-2014, 02:58 PM
Last Post: Aravindhan Manogaran
  GE6251 Basic Civil And Mechanical Engg Nov Dec 2014 Important question kavi 0 883 03-12-2014, 06:47 PM
Last Post: kavi
  AT6032 Mechanics Of Machines Nov Dec 2014 Important Question kavi 0 1,372 03-12-2014, 04:56 PM
Last Post: kavi
  EC2312-Microprocessor and Microcontroller Nov Dec 2014 Important Question V+ Rajee 0 963 03-12-2014, 11:54 AM
Last Post: Rajee
  EC2304 Microprocessors And Microcontrollers Important Questions - Anand Edition Anandec 1 1,435 30-08-2014, 07:54 AM
Last Post: Srini
  080230069 Cloud computing Important Questions - All Units Srini 0 2,295 03-04-2014, 07:54 AM
Last Post: Srini
  ELECTRIC CIRCUITS AND ELECTRON DEVICES - Two Marks Important Questions Srini 4 6,239 25-01-2014, 09:56 AM
Last Post: pujimani
Reply

National Conference on Research Issues in BigData (NCBD 2015) - Rathinam College of Arts and Science


Subscribe


Recommend on Google


Latest Threads
-> Health Care Of Special Groups March 2010 Question Paper Type Version
Forum : Dr. M.G.R. Educational and Research Institute Question Paper
Last Post : yogesh yogib
-> Health Care Of Special Groups September 2009 Question Paper Type Version
Forum : Dr. M.G.R. Educational and Research Institute Question Paper
Last Post : yogesh yogib
-> Health Care Of Special Groups March 2009 Question Paper Type Version
Forum : Dr. M.G.R. Educational and Research Institute Question Paper
Last Post : yogesh yogib
-> Health Practice And Administration And Recent Advances April 2012 Question Paper...
Forum : Dr. M.G.R. Educational and Research Institute Question Paper
Last Post : yogesh yogib
-> Environmental Studies Question Bank with Answers
Forum : Computer Science Engineering Study Materials
Last Post : Srini
-> GE6351 Environmental Science and Engineering - Unit 2 IMP Two Marks with Answers
Forum : Civil Semester 3 Two Marks
Last Post : Vetri Vkkv
-> Top PR industry professionals discuss changing trends at SIMC, Pune’s Public Rel...
Forum : Other Department / Other Events
Last Post : Srini
-> Health Practice And Administration And Recent Advances October 2011 Question Pap...
Forum : Dr. M.G.R. Educational and Research Institute Question Paper
Last Post : yogesh yogib
-> Health Practice And Administration And Recent Advances May 2011 Question Paper T...
Forum : Dr. M.G.R. Educational and Research Institute Question Paper
Last Post : yogesh yogib
-> Anna University Announcement regarding the Leave on 30th July 2015
Forum : Announcements
Last Post : kavi
-> Re-Schedule of TNEA Counselling for Vocational candidates
Forum : TNEA 2015
Last Post : kavi
-> UPSC (Mains) Civil Engineering Paper II 2012 Question Paper
Forum : UPSC Exam Question Paper
Last Post : kavi
-> UPSC (Mains) Civil Engineering Paper I 2012 Question Paper
Forum : UPSC Exam Question Paper
Last Post : kavi
-> UPSC (Mains) Chemistry Paper II 2012 Question Paper
Forum : UPSC Exam Question Paper
Last Post : kavi
-> UPSC (Mains) Chemistry Paper I 2012 Question Paper
Forum : UPSC Exam Question Paper
Last Post : kavi