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

FirstRanker.com

GUJARAT TECHNOLOGICAL UNIVERSITY
BE - SEMESTER-VII (NEW) EXAMINATION - WINTER 2018

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

Subject Code: 2170714 Date: 06/12/2018
Subject Name: Distributed DBMS
Time: 10:30 AM TO 01:00 PM Total Marks: 70

Instructions:
1. Attempt all questions.

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

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

MARKS

Q.1 (a) Explain data independence. 03
(b) Discuss problem areas in DDBMS environment. 04

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

(c) Explain Client Server architecture for Distributed DBMS. 07

Q.2 (a) Explain Horizontal Fragmentation. 03
(b) Explain Top-Down Design Process for Distributed Database. 04
(c) Define Distributed Database System. What is transparency in 07
DDBMS? Explain Layers of transparency in DDBMS.

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

OR

(c) State the need of Normalization in database management system. 07
Write and explain any two normal forms with appropriate
example.

Q.3 (a) Explain Characterization of Query Processors. 03

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

(b) Explain Join Ordering for Query optimization. 04
(c) What is authorization control? How to imply authorization 07
control in centralized and distributed environment.

OR

Q.3 (a) Explain Cost Function of Query Optimization. 03

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

(b) Explain layers of Query processing. 04
(c) What do you mean by distributed semantic integrity control? 07
Explain with example.

Q.4 (a) Explain ACID Property of Transaction. 03
(b) Explain Conflict serializability. 04

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

(c) Explain Centralized 2PL for distributed DBMS environment. 07

OR

Q.4 (a) Define Lock Granting. 03
(b) Explain Type of Transactions. 04
(c) Explain optimistic concurrency control algorithms. 07

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

Q.5 (a) Write down step for backward error recovery. 03
(b) Define write- Ahead Logging Protocol. 04
(c) Write a Short note on: Shadow Paging. 07

OR

Q.5 (a) Explain Transaction Failures in Distributed DBMS. 03

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

(b) Define Reliability and Availability. 04
(c) Discuss wait-die and wound-wait deadlock avoidance algorithm 07
for distributed system.

FirstRanker.com

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