You are on page 1of 2

GKM COLLEGE OF ENGINEERING AND TECHNOLOGY

CHENNAI – 63
Department of Information Technology
U.G / Internal Test - I
Year/Sem: IV/VII
Branch: IT
Sub Code/Name: CS2029-Advanced Database Technology
Max Marks: 50
Date: 12/08/2015
Duration: 1.5 hrs
Part – A
Answer all the questions:
(7x2=14 marks)
1. Define ACID in transaction processing.
2. List out the different levels in data base tuning?
3. Differentiate distributed intra query parallelism from inter query
parallelism.
4. Differentiate distributed database and normal database.
5. State any two features of distributed database.
6. Write an SQL query to retrieve employee name and ID from a table
employee?
7. List the features of DDB?
Part – B
Answer any three questions:
(3x12=36 marks)
1. Discuss in detail about cost based query optimization in RDBMS with
example.
2. Write short notes on transaction processing in RDBMS.
3. Discuss query optimization in DDBMS briefly.
4. Illustrate the several architectural models for parallel database.
5. Discuss two phase locking protocol technique for concurrency in
detail.

Sub Staff Sub Mentor HOD .