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

Wednesday, 31 January 2018

CP7202 - Advanced Databases November December 2016 Anna University Question

CP 7202 Advanced Databases question paper – November/December 2016 



Question Paper Code : 17312
M.E./M.Tech. DEGREE EXAMINATION, NOVEMBER/DECEMBER 2016
Second Semester
Computer Science and Engineering
CP 7202 — ADVANCED DATABASES
(Common to M.E. 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 X 2 = 20 marks)
1. What is three-tier client-server architecture?
2. Define commit protocol. What are its types?
3. What is meant by object persistence?
4. Differentiate between ODL and OQL.
5. Mention the design principles for active rules.
6. Write the different types of queries used in spatial database.
7. Mention the significance of handoff management.
8. How is mining different from searching?
9. Can you store XML in databases? Justify your answer.
10. List some of the cloud data models.
PART B – (5 X 13 = 65 marks)
Or
(ii) What is distributed query processing? Explain in detail with an example. (6)

12. (a) (i) Describe about object identity, object structure and type constructors in Object oriented databases. (6)
(ii) Distinguish between object oriented and object relational databases. (7)
Or
(b) Explain the components of ODMG model. (13)

13. (a) Describe the syntax and semantics of Active databases explain how the active rules are specified in Oracle. (13)
Or
(b) (i) How are recursive queries specified in SQL? Explain. (8)
(ii) Describe about Temporal databases. (5)

14. (a) Explain about the mobile transaction models. (13)
Or
(b) Explain the various data classification methods for data mining. (13)

15. (a) Write a note on:
(i) Native XML database. (7)
(ii) Web databases. (6)
Or
(b) Describe cloud storage architecture with neat diagram. (13)
PART C – (1 X 15 = 15 marks)
16. (a) How is concurrency control achieved in distributed databases? Justify your answer with an example.
Or
(b) Mention the problems of location-dependent data distribution. How does it affect the data integrity and data consistency? Explain your answer.

________________________






CS 9221 - Database Technology Anna University ME/MTech Question paper
CS 921 - Database Technology Anna University ME/MTech question paper
CP 7202 - Advanced Databases Anna University ME/MTech Question paper
Anna University Exam Questions with Answers



 

Monday, 14 September 2015

CP7202 - Advanced Databases May/June 2015 Question Paper


CP 7202 Advanced Databases question paper – May/June 2015


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


Question Paper Code : 43299
M.E./M.Tech. DEGREE EXAMINATION, MAY/JUNE 2015
Second Semester
Computer Science and Engineering
CP 7202 — ADVANCED DATABASES
(Common to M.E. 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 are the limitations of client server architecture?
2. Differentiate between Inter-query and Intra-query parallelism.
3. How persistent objects are maintained in object oriented databases?
4. What is object relational database management systems?
5. Write the syntax and semantics of Datalog languages.
6. How to represent time in temporal databases and compare the different time dimensions.
7. Why do we need multimedia databases? List its advantages and disadvantages.
8. State the problems that would occur if transactions are allowed to execute concurrently.
9. What is native XML database? Give example.
10. Mention the components of cloud storage system.

PART B — (5 × 16 = 80 Marks)

11. (a) (i) Explain the key properties which are used to measure the parallel database system performance. (8)
(ii) Discuss the different architectures for parallel databases. (8)

Or

(b) (i) Explain the steps involved in processing a query with suitable example. (8)
(ii) Compare and contrast the following pairs in distributed database; (4 + 4)
(2) Vertical and Horizontal partitioning.

12. (a) (i) Explain object identity and reference types with example. (8)
(ii) How does the concept of a object in the object oriented model differ from the concept of an ER model? (8)

Or

(b) (i) Discuss the structure and various operation of object oriented database. (8)
(ii) Explain the concept of ODMG model win example. (8)

13. (a) Explain how to identify an active and deductive databases with an example. (16)

Or

(b) Explain spatial data management. Discuss the various indexing techniques of spatial data management. (16)

14. (a) (i) Give a brief note on the design and implementation issues in mobile databases. (8)
(ii) Distinguish location dependent and location independent query with an example. (8)

Or

(b) (i) Consider a data warehouse consists of four dimensions date, spectator, location and game and the two measures count and charge. The charge is the fare where the spectator pays when watching a game on a given date, spectator may be students, adults or seniors. Each category is having its own charge rate. Draw a star schema for the data warehouse and explain how many cuboids are needed to build the data cube? (8)
(ii) Describe the task primitives and issues in text mining. (8)

15. (a) (i) Discuss the different approaches for storing XML documents in databases.  (8)
(ii) Describe the web based architecture with suitable example. (8)

Or

(b) (i) Explain the concept of Geographic Information Systems. (8)
(ii) Describe the characteristics of cloud computing environment. (8)

_____________________________





CS 9221 - Database Technology Anna University ME/MTech Question paper
CS 921 - Database Technology Anna University ME/MTech question paper
CP 7202 - Advanced Databases Anna University ME/MTech Question paper



Saturday, 25 July 2015

CP7202 - Advanced Databases November/December 2014 Question Paper


CP 7202 Advanced Databases question paper – November/December 2014 


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



Question Paper Code : 13294
M.E./M.Tech. DEGREE EXAMINATION, November/December 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. Execution of a single query can be parallelized in two ways. What are they?
2. Define ACID in transaction processing.
3. Write the types of fragmentation.
4. What is operator polymorphism.
5. Define the term ‘persistence’ in object based databases.
6. List the types of spatial queries.
7. Define Handoff in mobile database.
8. Mention the components of deductive database.
9. List the goals of data mining.
10. List the merits of Web database.

PART B — (5 × 16 = 80 Marks)

11. (a) (i) What factors could result in skew when a relation is partitioned on one of its attributes by:                                                                                               (8)
(1) Hash partitioning
(2) Range partitioning.
In each case, what can be done to reduce the skew?
(ii) Write short notes parallel database and distributed databases.                           (8)

Or

(b) Explain the various ways in which concurrency control can be implemented in a database. Draw the schematic diagram for two-phase locking system.            (16)

12. (a) Explain about the mandatory features of OODBMS and illustrate the syntax of OQL.                                                                                                            (16)

Or

(b) (i) Write the differences and similarities between class and interface inheritance. (8)
(ii) Represent the following schema diagram in ODL. How do you iterate through all the persistent classes?                                                                               (8)
STATE_NAME(CCITY#, STATE)
CUST(CID#, CNAME, CCITY)
SALE_DETAIL(CID#, PID#, SALE, SALEDT#)
PROD(PID#, PNAME, PCOST, PPROFIT)

13. (a) (i) Explain the various spatial access methods and data structure of spatial database.                                                                                                     (8)
(ii) Write a short note on spatial data types and relationships.                       (8)

Or

(b) Explain about temporal database and TSQL2.                                            (16)

14. (a) Explain about mobile database, location and handoff management in detail. (16)

Or

(b) (i) Compare Online Transaction Processing (OLTP) with Online Analytical Processing (OLAP).                                                                                              (8)
(ii) What is the difference between classification and association in the context of data mining?                                                                                                        (8)

15. (a) Consider the following DTD
<!DOCTYPE bibliography [
<!ELEMENT book(title, author+, year, publisher, place?)>
<! ELEMENT article (title, author+, journal, year, number, volume, pages?)>
<!ELEMENT title (#PCDATA)>
… similar PCDATA declarations for
Year, publisher, place, journal, year, member, volume, pages, lastname, firstname)]>
(i) Show how to map this DTD to a relational schema.
(ii) Create a XML document for this DTD.                                             (16)


Or

(b) Write short notes on the following.
(i) Cloud database                                                                                        (8)
(ii) Big data analysis                                                                                     (8)

_____________________________

 



Important properties of two phase locking protocol and its variants

Important properties of two phase locking protocol and its variants Properties of     2PL Serializability  2PL ensures co...