Download GTU BE/B.Tech 2019 Summer 7th Sem New 2170714 Distributed Dbms Question Paper

FirstRanker.com
Subject Code:2170714
GUJARAT TECHNOLOGICAL UNIVERSITY

--- Content provided by FirstRanker.com ---

BE - SEMESTER-VII(NEW) EXAMINATION — SUMMER 2019
Subject Name:Distributed DBMS
Time:02:30 PM TO 05:00 PM
Instructions:
1. Attempt all questions.

--- Content provided by​ FirstRanker.com ---

2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

Q.1
(a) Explain following in context of Relational algebra:

--- Content provided by FirstRanker.com ---

1. Selection 2. Join 3. Projection (03)
(b) Discuss views in centralized DBMS. (04)
(c) Define transparency. Explain the layers of transparencies in distributed database design in brief. (07)

Q.2

--- Content provided by​ FirstRanker.com ---

(a) List down and explain any one condition that leads to a deadlock. (03)
(b) Explain dependency structures with example. (04)
(c) Describe Bond Energy Algorithm (BEA) algorithm in vertical fragmentation. (07)

OR

--- Content provided by​ FirstRanker.com ---

(c) Draw and explain query processing in centralized system. (07)
(a) Define Minterm selectivity and access frequency. (03)
(b) Discuss MDBS architecture with a global conceptual schema. (04)

--- Content provided by⁠ FirstRanker.com ---

Q.3
(a) What is authorization control? How to imply authorization control in centralized and distributed environment. (07)

OR

--- Content provided by FirstRanker.com ---

(a) Define Autonomy, Distribution and Heterogeneity. (03)
(b) Explain search strategy in Query Optimization. (04)
(c) Describe Two Phase Locking Protocol and Discuss Centralized Two phase locking protocol in brief. (07)

Q.4

--- Content provided by⁠ FirstRanker.com ---

(a) Write down reasons for fragmentation. (03)
(b) List down type of transactions and explain any one in details. (04)
(c) Explain query decomposition and data localization layer for distributed query processing-system. (07)

OR

--- Content provided by‍ FirstRanker.com ---

(a) Write down objectives of query processing. (03)
(b) Discuss information requirements during allocation? (04)
(c) Explain two-phase commit protocol. (07)

--- Content provided by FirstRanker.com ---

Q.5
(a) Explain Write-ahead logging Protocol. (03)
(b) Explain conflict serializability by giving example. (04)
(c) Discuss join ordering in query optimization. (07)

--- Content provided by⁠ FirstRanker.com ---

OR

(a) Explain different types of failures in DDBMS. (03)
(b) Explain in basic timestamp-based protocol. (04)
(c) Write a short note on Shadow Paging. (07)

--- Content provided by⁠ FirstRanker.com ---

Date:21/05/2019
Total Marks: 70