05RLMCA266052003

E Pages: 2
Reg No.: Name:
APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
Fourth Semester MCA Degree Regular and Supplementary Examination July 2021
Course Code : RLMCA266
Course Name : ADVANCED DATABASE SYSTEMS
Max. Marks: 60 Duration: 3 Hours
PARTA
Answer all questions, each carries 3 marks. Marks
1 Why sorting of data plays an important role in database systems? (3)
2 What is the query cost equation for performing selection operation using (3)
primary index?
3 Identify the fundamental characteristics of object-oriented paradigm. (3)
4 What do you understand by object ID? (3)
5 Write a short note on data transparency. (3)
6 Define the term fragmentation in distributed databases. (3)
7 What is the function of ‘zookeeper’ in Hbase architecture? (3)
8 Why do we use NoSQL database in social networking applications? (3)
PART 13
Answer any one question from each module. Each question carries 6 marks.
Module I
9 Write an abstract of the speed, cost and data capacity of each media in the (6)
storage device hierarchy using a neat sketch.
OR
10 How do you organize files using heap and sequential techniques? List the (6)
advantages and disadvantages of each.
Module II
11 What is an index? Which are the various indices used in database systems? (6)
Prepare a short note on each.
OR
12 Explain the properties and structure of B* tree index file with an example. (6)
Module III
13 Using a block diagram, describe the different stages of a query statement (6)

execution.

Page 1 of 2