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)

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