Engineering B.E. (Computer Engineering) Sem 6 Distributed Databases Dec 2018 Question Paper - Mumbai University | munotes
Get access to whole semester resourcesSemester Pass
MU B.E. (Computer Engineering) student group
Free to join
Loading PDF...
Older exam
None: this is the earliest we hold
Newer exam
May 2019
Semester-end · Distributed Databases
→
Questions asked in this paper
- Please check whether you have got the right question paper
Q.P. Code: 13539
[Time: Three Hours] [ Marks:80]
Please check whether you have got the right question paper
N.B: (1)Question No. 1 is Compulsory
(2) Attempt any three question out of remaining five
1 (a) Consider the following two relations: EMP and PAY 10
Assume that P1: Salary <= 30000 and P2: Salary are two simple predicates. Perform
a horizontal fragmentation of PAY with respect to predicates P1 and P2 to obtain two
fragments PAY1 and PAY2. Using these fragments, perform derived fragmentation for EMP
and prove completeness, reconstruction and disjointness rules for fragmentation of EMP
relation are satisfied
(b) Discuss the algorithms used for distributed Deadlock preventions. 10
2 (a) What is transparent System? List out the transparencies of DDBS. 10
(b) Explain SDD1 Semi joined-based algorithm in detail with example. 10
3 (a) detail the phases of Distributed Query processing with diagram. 10
(b) .. Draw and Explain architecture for Distributed Transaction Execution. 10
Describe any two methods for Deadlock Detection in distributed database. 10
What is XML schema? Define X-Path and X-Query with an example. 10
5 (a) Two phase commit protocol in detail with diagram. 10
(b) Locking based of the Optimistic concurrency control algorithm in detail. 10
6 Write a short notes on (Any Four) 20
Features of DDBS
(b) Architecture of Heterogeneous Database
(c) Anomalies for concurrency control
(d) — Applications of Distributed Databases
(e) Cost factors affects in query optimization
[Time: Three Hours] [ Marks:80]
Please check whether you have got the right question paper
N.B: (1)Question No. 1 is Compulsory
(2) Attempt any three question out of remaining five
1 (a) Consider the following two relations: EMP and PAY 10
Assume that P1: Salary <= 30000 and P2: Salary are two simple predicates. Perform
a horizontal fragmentation of PAY with respect to predicates P1 and P2 to obtain two
fragments PAY1 and PAY2. Using these fragments, perform derived fragmentation for EMP
and prove completeness, reconstruction and disjointness rules for fragmentation of EMP
relation are satisfied
(b) Discuss the algorithms used for distributed Deadlock preventions. 10
2 (a) What is transparent System? List out the transparencies of DDBS. 10
(b) Explain SDD1 Semi joined-based algorithm in detail with example. 10
3 (a) detail the phases of Distributed Query processing with diagram. 10
(b) .. Draw and Explain architecture for Distributed Transaction Execution. 10
Describe any two methods for Deadlock Detection in distributed database. 10
What is XML schema? Define X-Path and X-Query with an example. 10
5 (a) Two phase commit protocol in detail with diagram. 10
(b) Locking based of the Optimistic concurrency control algorithm in detail. 10
6 Write a short notes on (Any Four) 20
Features of DDBS
(b) Architecture of Heterogeneous Database
(c) Anomalies for concurrency control
(d) — Applications of Distributed Databases
(e) Cost factors affects in query optimization
Read from the scan above, so a character or two may differ. The scan is the original.
Something wrong on this page? Report it and we will check it against the scan.
Quick Help
No. The full paper opens straight away, with no login and nothing to pay.
Related Resources
Something wrong with this paper? Report it.
Connected Papers
Engineering / B.E. (Computer Engineering) · 250 papers
May 2026
May 2026
May 2026
May 2026
May 2026
Dec 2025
Dec 2025
Dec 2025
Dec 2025
Dec 2025
Dec 2025
May 2025
May 2025
May 2025
May 2025
May 2025
May 2025
May 2025
Dec 2024
Dec 2024
Dec 2024
Dec 2024
Dec 2024
Dec 2024
May 2024
May 2024
May 2024
May 2024
May 2024
Dec 2023
Dec 2023
Dec 2023
Dec 2023
Dec 2023
May 2023
May 2023
May 2023
May 2023
Dec 2022
Dec 2022
Dec 2022
Dec 2022
Dec 2022
Dec 2022
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer Set 2
May 2019
May 2019
May 2019
May 2019
May 2019
May 2019
May 2019 - CBSGS
May 2019 - CBSGS
May 2019 - R16
May 2019 - R16
May 2026
May 2026
May 2026
May 2026
May 2026
Dec 2025
Dec 2025
Dec 2025
Dec 2025
Dec 2025
Dec 2025
Dec 2025
May 2025
May 2025
May 2025
May 2025
May 2025
May 2025
May 2025
Dec 2024
Dec 2024
Dec 2024
Dec 2024
Dec 2024
Dec 2024
Dec 2024
May 2024
May 2024
May 2024
May 2024
May 2024
May 2024
Dec 2023
Dec 2023
Dec 2023
Dec 2023
Dec 2023
Dec 2023
Dec 2022
Dec 2022
Dec 2022
Dec 2022
2022 - Summer
2022 - Summer
May 2026
May 2026
May 2026
May 2026
May 2026
May 2026
Sep 2026
Sep 2026
Sep 2026
Sep 2026
Aug 2025
Aug 2025
Aug 2025
Aug 2025
Aug 2025
May 2025
May 2025
May 2025
May 2025
May 2025
May 2025
May 2025
Dec 2024
Dec 2024
Dec 2024
Dec 2024
Dec 2024
May 2024
May 2024
May 2024
May 2024
May 2024
May 2024
May 2024
Dec 2023
May 2023
May 2023
May 2023
May 2023
May 2023
May 2023
Dec 2022
Dec 2022
Dec 2022
Dec 2022
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
2022 - Summer
Dec 2019
Dec 2019
Dec 2019
Dec 2019
Dec 2019
Dec 2018
Dec 2018
Dec 2018
Questions? Email contact@munotes.in
Done!