Showing posts with label Advanced Database Questions. Show all posts
Showing posts with label Advanced Database Questions. Show all posts

Saturday, 28 February 2015

DMC 1971 Advanced Databases February 2014 Question Paper

Anna University MCA Distance Education Advanced Databases Question Paper / Anna University MCA Distance Education Previous Year Question Paper / DMC 1971 Advanced Databases Question Papers with Answers / DMC 1971 Advanced Databases February March Question Papers with Answers / February March DMC1971


Question Paper Code : 96324
M.C.A. DEGREE EXAMINATION, FEBRUARY/MARCH 2014
Elective
DMC 1971 – ADVANCED DATABASES
(Regulation 2009)
Time : Three Hours                                               Maximum : 100 Marks
Answer ALL Questions
PART A – (10 X 2 = 20 Marks)
1. What is referential key constraint?
2. State the purpose of query optimization.
3. Differentiate transient and persistent objects.
4. Justify the need for concurrency control.
5. What is client/server model?
6. Define: mobile database.
7. What is active rule?
8. Give advantages of distributed database systems.
9. When did you say that the consistency of a database is lost?
10. What is authentication? How does it differ from authorization?
PART B – (5 X 16 = 80 Marks)
11. (a) (i) Describe in detail about hashing techniques. (8)
(ii) Briefly explain about relational model concepts. (8)
Or
(b) Why normalization is required? Explain 1NF, 2NF, 3NF, and BCNF in detail with suitable examples. (16)
12. (a) How will you model and design an object oriented database? Explain in detail. (16)
Or
(b) Write short notes on the following;
(i) Database administration (8)
(ii) Recovery (8)
13. (a) What is enhanced data model? Explain each of them. (16)
Or
(b) Write a detailed note on web databases. (16)
14. (a) Write short notes on:
(i) Active databases. (8)
(ii) Deductive databases. (8)
Or
(b) (i) Explain any one of the concurrency control protocol in detail with example. (8)
(ii) Discuss in detail the parallel database. (8)
15. (a) Describe the database tuning techniques in detail. (16)
Or
(b) (i) Explain the integrity issues in database design. (8)
(ii) Discuss the research issues related to security in database design. (8).
________________



Friday, 2 January 2015

CS2029 Advanced Database Technology Anna University question paper - November/December 2014

CS2029 Advanced Database Technology question paper - November/December 2014 / Anna University Previous Year 2014 Exam Questions for Advanced Database Technology with Answers / Anna University Previous Year 2014 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper / CS2029 Sixth Semester Advanced Database Technology question / CS2029 CS606 Question paper with answers


Question Paper Code : 91325
B.E./B.Tech. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2014
Sixth Semester
Computer Science and Engineering
CS 2029/CS 606/10144CSE 23 — ADVANCED DATABASE TECHNOLOGY
(Common to Seventh Semester Information Technology)
(Regulation 2008/2010)
(Common to PTCS 2029/10144 CSE 23 – Advanced Database Technology for B.E.
(Part-Time) Fifth/Sixth Semester – CSE – Regulation 2009/2010)
Time : Three Hours                                                          Maximum : 100 marks
Answer ALL Questions
PART A – (10 X 2 = 20 marks)
1. Define query processing.
2. Mention the use of database tuning.
3. State any two features of distributed database.
4. Define concurrency control.
5. What is the use of JASMINE model?
6. Write any two features of POSTGRES model.
7. Define data mining.
8. Mention main difference between mobile and web database.
9. What is multimedia database?
10. Give any features of spatial database.

PART B – (5 X 16 = 80 marks)
11. (a) (i) Explain about third normal form and BCNF with an example. (8)
(ii) Discuss query optimization briefly. (8)
Or
(b) (i) Write short note on transaction processing. (8)
(ii) Discuss two phase locking protocol technique for concurrency in detail. (8)

Or
(b) (i) Explain the architecture of Distributed database with a neat diagram. (10)
(ii) Write about commit protocols briefly. (6)

13. (a) Discuss the modeling and design of object oriented database in detail. (16)
Or
(b) Explain the overview of GEMSTONE and ODMG models. (16)

14. (a) (i) Distinguish between OLTP and OLAP. (8)
(ii) What are the different schemas in data warehouse? Explain them. (8)
Or
(b) Write about mobile, XML, and web databases with their structures. (16)

15. (a) (i) Explain about knowledge bases, active and deductive databases. (16)
Or
(b) Discuss the concepts of multimedia data structures and query languages briefly. (16)

_________________________
 

Wednesday, 23 July 2014

CP7202 - Advanced Databases May/June 2014 Question Paper



CP 7202 Advanced Databases question paper – May/June 2014


CP 7202 Advanced Databases question paper – May/June 2014 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers / Previous Year Anna University Exam Questions with Answers





Question Paper Code : 63294
M.E./M.Tech. DEGREE EXAMINATION, MAY/JUNE 2014
Second Semester
Computer Science and Engineering
CP 7202 — ADVANCED DATABASES
(Common to Computer Science and Engineering (with Specialization in Networks) and M.Tech. Information Technology)

(Regulation 2013)

Time: Three hours                                                       Maximum: 100 Marks
Answer ALL Questions

PART A — (10 × 2 = 20 Marks)

1. What is the advantage of parallelism?
2. What is the difference between parallel system and distributed system?
3. Give examples for object relational databases.
4. How is object database differentiated from relational database?
5. What is meant by spatial database?
6. Define Semantics
7. What is mobility?
8. How is mining different from searching?
9. What is structured data?
10. What is XML Schema?

PART B — (5 × 16 = 80 Marks)

11. (a) Define Parallel databases. Explain the inter and intra query parallelism. (16)

Or

(b) How are the transactions are handled in distributed database? Explain. (16)

12. (a) What are the object relational features in SQL? Explain. (16)

Or

(b) (i) Write in details about ODMG model with ODL and OQL
(ii) Distinguish object oriented and object relational databases

13. (a) What are spatial data structures? And explain any two (16)

Or

(b) Discuss the design principles for Active rules. (16)

14. (a) Write detailed notes on Concurrency control in mobile database. (16)

Or

(b) Explain any two retrieval models used in Information Retrieval. (16)

15. (a) Give details about approaches used to store XML documents in database. (16)

Or

(b) Describe Cloud storage architecture and Big-data storage analysis with suitable example. (16)

_____________________________

 



SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...