2011 Kannur University B.Tech Computer Science and Engineering Seventh Semester B.Tech. (Reg./Sup./Imp. - Including part Time) Degree Examination:ADVANCED DATABASE SYSTEMS Question paper

Are you looking for the old question papers of Kannur University- Computer Science and Engineering? Here is the previous year question paper from Kannur University. VII Semester B.Tech. (Reg./Sup./Imp. - Including part Time) Degree Examination:ADVANCED DATABASE SYSTEMS.Feel free to download the question paper from here and use it to prepare for your upcoming exams.

VII Semester B.Tech. (Reg./Sup./Imp. - Including part Time) Degree
Examination, November 201 1
(2007 Admn.)
2K6CS 705 (A) : ADVANCED DATABASE SYSTEMS 
Time : 3 Hours Max. Marks : 100 

PART _ A

1. a) Describe structured types and inheritance in SQL. [Marks 5]

b) Describe the Multiset types in SQL. [Marks 5]

c) Explain briefly on Page Rank in Google Search Engine. [Marks 5]

d) How the text mining applied in data-mining techniques ? [Marks 5]

e) Give the advantage of centralized system with diagram. [Marks 5]

f ) Explain the three different portioning techniques. [Marks 5]

g) Write notes on time specification in SQL. [Marks 5]

h) Explain Real-Time Transaction Systems. [Marks 5]

PART _ B 

2. a) Explain the object identity and reference types in SQL. [Marks 15]

OR

b) Explain the Nesting and Unnesting with example. [Marks 15]
3. a) Explain the concept of Ranking with example. [Marks 15]

OH

b) Explain the information retrieval and structured data. [Marks 15]
4. a) Explain the two forms of inter-operation parallelism and query optimization. [Marks 15]

OR

b) Explain the concurrency control in Distributed Databases. [Marks 15]

5. a) Explain the indexing of spatial data. [Marks 15]

OR

b) Explain briefly on transactional workflows. [Marks 15]