Scribd
Upload
151 views1 page

Adb Unit 1

This document contains an assessment test for an advanced databases course. It has three parts testing students' knowledge of database fragmentation types and advantages/disadvantages, concurrency control and its need, and design principles of active rules. It also evaluates understanding of skew in hash and range partitioning, the two-phase commit protocol, transaction handling in distributed databases, temporal databases and how commands are implemented, and I/O parallelism through examples of interquery and intraquery parallelism.

Uploaded by

pdvdm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
151 views1 page

Adb Unit 1

This document contains an assessment test for an advanced databases course. It has three parts testing students' knowledge of database fragmentation types and advantages/disadvantages, concurrency control and its need, and design principles of active rules. It also evaluates understanding of skew in hash and range partitioning, the two-phase commit protocol, transaction handling in distributed databases, temporal databases and how commands are implemented, and I/O parallelism through examples of interquery and intraquery parallelism.

Uploaded by

pdvdm
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

JEPPIAAR ENGINEERING COLLEGE JEPPIAAR ENGINEERING COLLEGE

DEPARTMENT OF CSE DEPARTMENT OF CSE

ASSESSMENT TEST I ASSESSMENT TEST I


IF5191 – ADVANCED DATABASES IF5191 – ADVANCED DATABASES
M.E (CSE) M.E (CSE)

TOTAL MARKS: 60 YEAR/SEM: I/II TOTAL MARKS: 60 YEAR/SEM: I/II


DATE: .02.2018 DATE: .02.2018

Answer all the Questions Answer all the Questions

PART - A 3*2=6 PART - A 3*2=6


1. List the types of fragmentation and state its 1. List the types of fragmentation and state its
advantages and disadvantages. advantages and disadvantages.
2. Define Concurrency control and its need. 2. Define Concurrency control and its need.
3. What are the design principles of active rules? 3. What are the design principles of active rules?

PART - B 3*13=39 PART - B 3*13=39


1. (i) What factors could result in skew when a 1. (i) What factors could result in skew when a
relation is partitioned on one of its attributes by: relation is partitioned on one of its attributes by:
a) Hash Partitioning b)Range Partitioning (6) a) Hash Partitioning b)Range Partitioning (6)
(ii) Explain Two-Phase commit protocol in (ii) Explain Two-Phase commit protocol in
distributed database. (7) distributed database. (7)
2. Explain in detail about how the transactions are 2. Explain in detail about how the transactions are
handled in distributed database. handled in distributed database.
3. What is temporal database? Explain with example 3. What is temporal database? Explain with example
how the insert, delete and update commands are how the insert, delete and update commands are
implemented in a temporal database? implemented in a temporal database?

PART - C 1*15=15 PART - C 1*15=15


1. What is I/O parallelism? Explain with examples 1. What is I/O parallelism? Explain with examples
about interquery parallelism and intraquery about interquery parallelism and intraquery
parallelism. parallelism.

You might also like