CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2011 Question Paper

Anna University

B.E / B.Tech Degree Examination, April / May / June 2011

Department of Computer Science

 CS606 / 10144CSE23 / CS2029

 Advanced Database Technology (ADT)

6th Semester

(Regulation 2008)

(Common to Information Technology)

Semester : 6

Department : CSE (IT)

Subject Code : CS606 / 10144CSE23 / CS2029


Subject Name :  Advanced Database Technology (ADT)

Regulation : 2008

Attachment Type : pdf

No. of. Pages : 2

Details : CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2011 Question Paper

View - CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2011 Question Paper

Download a copy of  CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2011 Question Paper


Advanced Database Technology (ADT) April / May / June 2011 Question Papers given above can be used by the following students.

1. Students admitted in Anna University Chennai during the year 2008, 2009, 2010, 2011 and 2012
2. Students admitted in Anna university (or) Anna University of technology, Tirunelveli during the year 2011 and 2012
3. Students admitted in Anna university (or) Anna University of technology, Trichy during the year 2011 and 2012
4. Students admitted in Anna university (or) Anna University of technology, Coimbatore during the year 2011 and 2012
5. Students admitted in Anna university (or) Anna University of technology, Madurai during the year 2011 and 2012

CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - November / December 2012 Question Paper

     Anna University

B.E / B.Tech Degree Examination, November / December 2012

Department of Computer Science

 CS606 / 10144CSE23 / CS2029

 Advanced Database Technology (ADT)

6th Semester

(Regulation 2008)

(Common To Information Technology)

Semester : 6

Department : CSE (IT)

Subject Code : CS606 / 10144CSE23 / CS2029


Subject Name :  Advanced Database Technology (ADT)

Regulation : 2008

Attachment Type : pdf

No. of. Pages : 2

Details : CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - November / December 2012 Question Paper

View - CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - November / December 2012 Question Paper

Download a copy of CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - November / December 2012 Question Paper


Advanced Database Technology (ADT) November / December 2012 Question Papers given above can be used by the following students.

1. Students admitted in Anna University Chennai during the year 2008, 2009, 2010, 2011 and 2012
2. Students admitted in Anna university (or) Anna University of technology, Tirunelveli during the year 2011 and 2012
3. Students admitted in Anna university (or) Anna University of technology, Trichy during the year 2011 and 2012
4. Students admitted in Anna university (or) Anna University of technology, Coimbatore during the year 2011 and 2012
5. Students admitted in Anna university (or) Anna University of technology, Madurai during the year 2011 and 2012

CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2012 Question Paper

 Anna University

B.E / B.Tech Degree Examination, April / May / June 2012

Department of Computer Science

 CS606 / 10144CSE23 / CS2029

 Advanced Database Technology (ADT)

6th Semester

(Regulation 2008)

(Common to Information Technology)

Semester : 6

Department : CSE (IT)

Subject Code : CS606 / 10144CSE23 / CS2029


Subject Name :  Advanced Database Technology (ADT)

Regulation : 2008

Attachment Type : pdf

No. of. Pages : 2

Details : CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2012 Question Paper

View - CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April  / May / June 2012 Question Paper

 Download a copy of CS606 / 10144CSE23 / CS2029 - Advanced Database Technology (ADT) - April / May / June 2012 Question Paper


Advanced Database Technology (ADT) April / May / June 2012 Question Papers given above can be used by the following students.

1. Students admitted in Anna University Chennai during the year 2008, 2009, 2010, 2011 and 2012
2. Students admitted in Anna university (or) Anna University of technology, Tirunelveli during the year 2011 and 2012
3. Students admitted in Anna university (or) Anna University of technology, Trichy during the year 2011 and 2012
4. Students admitted in Anna university (or) Anna University of technology, Coimbatore during the year 2011 and 2012
5. Students admitted in Anna university (or) Anna University of technology, Madurai during the year 2011 and 2012

CS2029 / CS606 / 10144CSE23 - Advanced Database Technology (ADT) - Nov / Dec 2012 Question Paper

Anna University

B.E./B.Tech. DEGREE EXAMINATION, NOVEMBER / DECEMBER 2012

Sixth Semester

Computer Science and Engineering

CS2029 / CS606 / 10144CSE23

Advanced Database Technology

(Regulation 2008)

Semester :6

Year : 3rd yr

Regulation : 2008

Department : B.E CSE

Subject Code : CS606 / CS2029 / 10144CSE23

Subject Name : Advanced Database Technology (ADT)

Content : CS2029 / CS606 / 10144CSE23 - Advanced Database Technology (ADT) - Nov / Dec 2012 Question Paper

 Download A Copy of CS2029 / CS606 / 10144 CSE23 Advanced Database Technology November / December 2012 Question Paper

UNITS COVERED:

Unit I - Relational Model Issues
Unit II - Distributed Databases
Unit III - Object Oriented Databases
Unit IV - Emerging systems
Unit V - Current Issues

CS2029 / CS606 / 10144CSE23 - Advanced Database Technology (ADT) - Nov / Dec 2012 Question Paper | CS2029 / CS606 / 10144CSE23 - Advanced Database Technology (ADT) - Nov / Dec 2012 - Model Question Paper | CS2029 / CS606 / 10144CSE23 - Advanced Database Technology (ADT) - Nov / Dec 2012 - Previous Year Question Papers | CS2029 / CS606 / 10144CSE23 - Advanced Database Technology (ADT) - Nov / Dec 2012 - Sample Question Papers

CS2029 / CS606 - ADVANCED DATABASE TECHNOLOGY (ADT) - Question bank

Anna University

B.E. / B.Tech. DEGREE EXAMINATION

Sixth Semester

Computer Science Engineering

CS2029 / CS606 - ADVANCED DATABASE TECHNOLOGY

(Regulation 2008)

 

Subject Title: Advanced Database Technology

Subject Code : CS2029 /  CS606

Semester: 6

Year: III

Attachment Type: PDF

Content:  CS2029 / CS606 - ADVANCED DATABASE TECHNOLOGY - Question bank

GET A COPY OF CS2029 / CS606 - ADVANCED DATABASE TECHNOLOGY QUESTION BANK - DOWNLOAD FROM HERE

SAMPLE CONTENT:

UNIT I

2 mark questions

1. What do you mean by cardinality? What are different kinds of cardinalities?

2. What is a primary key?

3. How is E-R data model useful?

4. Define an attribute. What is a key attribute?

5. Define subtype and super type entities?

6. What is DOMAIN? What is domain value?

7. What do you mean by a key? Give the difference between primary key and Candidate key.

8. What is the difference between the strong entity set and weak entity set ?

9. Give example of following relationships:

(i) Many-to-One

(ii) One-to-One

(iii) One-to-Many

(iv) Many-to-Many

10. Define foreign key? How does it play a role in the join operation?

11. What do you mean by Mapping Operation?

12. What do you mean by redundancy? How this can be avoided?

13. What do you mean by Normalization? Why this is useful?

14. Write short notes on transaction processing.

15. Define ACID in transaction processing.

16. Briefly describe lost update problem.

17. Briefly describe inconsistent read problem.

18. Briefly describe phantom phenomena.

19. What are the various types of serializability?

20. What are the four essential conditions for deadlock?

21. List the different types of backup and recovery techniques in Oracle database setup environment.

22. Discuss the reasons for converting SQL queries into relational algebra queries before optimization is done.

23. What is a query execution plan?

24. What is meant by the term heuristic optimization? Discuss the main heuristics that are applied during query optimization.

25. How does a query tree represent a relational algebra expression?

26. What is meant by an execution of a query tree?

27. Discuss the rules for transformation of query trees, and identify when each rule should be applied during optimization.

28. How many different join orders are there for a query that joins 10 relations?

29. What is meant by cost-based query optimization?

30. What is the difference between pipelining and materialization?

31. Discuss the different types of parameters that are used in cost functions. e is this information kept?

32. List the cost functions for the SELECT and JOIN methods.

33. What is meant by semantic query optimization? How does it differ from other query optimization techniques?