Exam Details
Subject | distributed database system | |
Paper | ||
Exam / Course | m.c.a.commerce | |
Department | ||
Organization | savitribai phule pune university | |
Position | ||
Exam Date | April, 2018 | |
City, State | maharashtra, pune |
Question Paper
Total No. of Questions—5] [Total No. of Printed Pages—4
Seat
No. [5361]-52
M.C.A. (Commerce) (Fifth Semester) EXAMINATION, 2018
502 DISTRIBUTED DATABASE SYSTEM
(2008 PATTERN)
Time Three Hours Maximum Marks 80
N.B. All questions are compulsory.
(ii Figures to the right indicate full marks.
(iii Draw the neat diagrams if necessary.
1. Attempt any four
What is Performance Tuning Explain
Improving Set Orientation
(ii Tuning of Bulk Loads and Updates.
List advantages of distributed systems.
Write the difference between optimistic and pessimistic
concurrency control.
Write a note on architectural aspects of distributed transaction.
What is replication Why is it necessary
2. Attempt any four
Explain in brief
Overview of distributed database
(ii Global optimization.
[5361]-52 2
Write a note on temporal databases.
Write a note on multiversion timestamp based protocol.
Write different approaches to calculate distributed weight for
graph.
Write a note on primary copy 2-phase locking protocol.
3. Attempt any four
Write a note on Transaction Processing Monitor.
Write a note on Mixed Fragmentation.
What are the objectives of data distribution
Explain optimistic timestamp based protocol in detail.
What are the correctness rules of Fragmentation
4. Attempt any four
Explain top-down approach to design distributed database.
Define the following terms
Simple Predicate
(ii Minterm Predicate
(iii Distributed DBMS
Distributed database.
What is spatio-temporal database Explain with suitable
example.
Write a note on recovery procedure in centralized system.
What are different alternatives for allocation of catalogs
[5361]-52 3 P.T.O.
5. Attempt any four
Consider the following schema
EMP(ENUM, ENAME, DESG, SAL)
Consider given predicates
P1 DESG "Manager"
P2 DESG "Worker"
P3 DESG "Supervisor"
Divide the given relation using horizontal fragmentation.
Consider the following schema
EMP(ENO, ENAME, TITLE)
PAY(TITLE, SAL)
Convert the given query into relational algebraic query and
operator tree
Select ENAME from EMP, PAY where SAL 1,00,000 and
PAY.TITLE EMP.TITLE.
Consider the given situation where Transactions T1 and T2
are executing at site 1. Transactions T3 and T4 are executing
at site 2.
Transaction T1 is waiting for T2. Transaction T3 is waiting
for T4. Transaction T4 is waiting for T2 and Transaction T1
is waiting for T3.
Draw local and global weight for graphs.
[5361]-52 4
Consider the following schema
EMP(ENO, ENAE)
PROJ(PNO, PNAME, LOC)
ASG(ENO, PNO, DURATION)
Convert the given operator tree into optimized operator
tree
PJENAME, PNAME
SL DURATION 12 LOC "PUNE"
JN
JN
EMP ASG PROJ
Consider the following schema
PRODUCT(PROD_NO, PROD_NAME, TYPE, WEIGHT)
PRODUCT relation is divided into tree fragments
PRODUCT1 SL TYPE "PLASTIC" (PRODUCT)
PRODUCT2 SL TYPE "FIBRE" (PRODUCT)
PRODUCT3 SL TYPE "WOODEN" (PRODUCT)
Consider the given query.
Select PROD_NAME from PRODUCT where TYPE "WOODEN".
Convert the given query into global operator tree and reduced
operator tree.
Seat
No. [5361]-52
M.C.A. (Commerce) (Fifth Semester) EXAMINATION, 2018
502 DISTRIBUTED DATABASE SYSTEM
(2008 PATTERN)
Time Three Hours Maximum Marks 80
N.B. All questions are compulsory.
(ii Figures to the right indicate full marks.
(iii Draw the neat diagrams if necessary.
1. Attempt any four
What is Performance Tuning Explain
Improving Set Orientation
(ii Tuning of Bulk Loads and Updates.
List advantages of distributed systems.
Write the difference between optimistic and pessimistic
concurrency control.
Write a note on architectural aspects of distributed transaction.
What is replication Why is it necessary
2. Attempt any four
Explain in brief
Overview of distributed database
(ii Global optimization.
[5361]-52 2
Write a note on temporal databases.
Write a note on multiversion timestamp based protocol.
Write different approaches to calculate distributed weight for
graph.
Write a note on primary copy 2-phase locking protocol.
3. Attempt any four
Write a note on Transaction Processing Monitor.
Write a note on Mixed Fragmentation.
What are the objectives of data distribution
Explain optimistic timestamp based protocol in detail.
What are the correctness rules of Fragmentation
4. Attempt any four
Explain top-down approach to design distributed database.
Define the following terms
Simple Predicate
(ii Minterm Predicate
(iii Distributed DBMS
Distributed database.
What is spatio-temporal database Explain with suitable
example.
Write a note on recovery procedure in centralized system.
What are different alternatives for allocation of catalogs
[5361]-52 3 P.T.O.
5. Attempt any four
Consider the following schema
EMP(ENUM, ENAME, DESG, SAL)
Consider given predicates
P1 DESG "Manager"
P2 DESG "Worker"
P3 DESG "Supervisor"
Divide the given relation using horizontal fragmentation.
Consider the following schema
EMP(ENO, ENAME, TITLE)
PAY(TITLE, SAL)
Convert the given query into relational algebraic query and
operator tree
Select ENAME from EMP, PAY where SAL 1,00,000 and
PAY.TITLE EMP.TITLE.
Consider the given situation where Transactions T1 and T2
are executing at site 1. Transactions T3 and T4 are executing
at site 2.
Transaction T1 is waiting for T2. Transaction T3 is waiting
for T4. Transaction T4 is waiting for T2 and Transaction T1
is waiting for T3.
Draw local and global weight for graphs.
[5361]-52 4
Consider the following schema
EMP(ENO, ENAE)
PROJ(PNO, PNAME, LOC)
ASG(ENO, PNO, DURATION)
Convert the given operator tree into optimized operator
tree
PJENAME, PNAME
SL DURATION 12 LOC "PUNE"
JN
JN
EMP ASG PROJ
Consider the following schema
PRODUCT(PROD_NO, PROD_NAME, TYPE, WEIGHT)
PRODUCT relation is divided into tree fragments
PRODUCT1 SL TYPE "PLASTIC" (PRODUCT)
PRODUCT2 SL TYPE "FIBRE" (PRODUCT)
PRODUCT3 SL TYPE "WOODEN" (PRODUCT)
Consider the given query.
Select PROD_NAME from PRODUCT where TYPE "WOODEN".
Convert the given query into global operator tree and reduced
operator tree.
Other Question Papers
Subjects
- advance java
- advanced database management system
- advanced networking
- advanced operating system
- advanced web programming
- business and professional skills
- business communication
- business strategies
- content management system
- core java
- cyber law and ethics
- data structure using-c
- data warehousing and data mining
- database management system
- distributed database system
- e-commerce practices andtechnologies
- element of statistics
- elements of mathematics
- financial and investment analysis
- fundamental of informationtechnology
- human resource management
- information system audit
- it project management
- knowledge management for business
- m-commerce
- management information system
- mobile communication
- networking operations
- numerical and statistical methods
- oop’s using c++
- operating system
- operating systems
- principles of management
- programming fundamentals : ‘c’ programming
- programming in ‘c’
- relational database management systems
- software engineering
- system analysis and design
- system organisation and management
- system simulation and modeling
- visual programming
- web technologies