Reg No.: Name:
APJ ABDUL சப்ப » பப்ப १ UNIVERSITY

Sixth Semester B.Tech Degree Regular and Supplementary Examination July 2021

Course Code: IT366
Course Name: ADVANCED DATABASE MANAGEMENT SYSTEMS

Max. Marks: 100 Duration: 3 Hours
PARTA
Answer any two full questions, each carries 15 marks. Marks
1 ஐ Explain different steps involved in distributed query processing. (7)

b) How two phase commit protocol works for concurrency Control? Explain witha (8)
neat diagram.
2 ஐ Explain the different methods used for distributed concurrency control. (8)
b) Explain the data fragmentation, replication and allocation technique used in (7)
distributed database design.
3 പ Explain about OQL Queries with Database Entry Points and iterator variables (10)

with examples.

b) What is semi join operation? Explain with example. (5)
PART ‏تا‎
‎Answer any two full questions, each carries 15 marks.
4 १) [पञ ‏اہ‎ with example FP-Growth algorithm. (8)
b) Explain the steps involved in constructing a data warehouse. (7)
5 a)___Explain the architecture of mobile database with a neat diagram (8)
b) What are different the phases of the knowledge discovery process? (7)
6 2) What are the characteristics of web databases? (6)

b) How classification algorithms are useful in data mining? Using an example, (9)
Explain classification using simple decision tree.
PART ட
Answer any two full questions, each carries 20 marks.

7 8) Draw an E-R diagram for a Banking System. (10)

Page 1 of 2