You are on page 1of 2

GKM COLLEGE OF ENGINEERING AND TECHNOLOGY

CHENNAI – 63
Department of Computer Science & Engineering
CS2029 – ADVANCED DATABASE TECHNOLOGY
INTERNAL TEST – 1
PART – A ( 2 MARKS)
UNIT-1
1. Define Database Management System?
2. Define Data Model?
3. What is an entity relationship model?
4. Brief about single valued and multivalued attributes.
5. Distinguish between primary key with superkey.
6. Define Data base Recovery?
7. What is meant by normalization of data?
8. What is transaction and their properties
9. What is query optimization?
10.
What are tunable parameters?
UNIT-2
11.
What is Fragmentation?
12.
Name some Partitioning techniques and write short note about
it?
13.
Difference between Inter and Intra query parallelism?
14.
List the basic failure types of a distributed System`
15.
Mention the types and uses of commit protocols.
16.
Short notes on types of fragmentation.
17.
What is a global and local transaction.
18.
What are the failures types of a transaction.
19.
How you will manage deadlocks in a DDBMS.
20.
List the components of DDBMS architecture.

PART – B ( 12 MARKS)

UNIT-2 8. Describe in detail about how to partition the database into fragments and explain where to locate those fragments and replicas. ==============================8888888===== =========================== . Explain the 2PC protocol and discuss how it handles the various types of failures? 11. Illustrate the steps involved in processing a query with neat diagram. INTERSECTION. Explain about deadlock handling. 10. SET DIFFERENCE and CARTESIAN PRODUCT algorithm. 3. Discuss briefly on data base tuning. 12. Define deadlocks. local global weight of graph. Discuss in detail how parallelism could be used in query processing and relational operation executions. 9. Illustrate the several architecture models for parallel database. Develop cost function for the PROJECT UNION. 5. 4. 6. deadlock characterization. 13. Write short notes on transaction processing.1. 7. Explain the architecture of distributed database in detail. 2. Compare and contrast between BCNF & 2NF. UNIT-1 Discuss two phase locking protocol technique for concurrency in detail What is query optimization? Explain any two optimization techniques in detail with suitable example.