FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

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

Download GTU (Gujarat Technological University) BE/BTech (Bachelor of Engineering / Bachelor of Technology) 2019 Summer 7th Sem New 2170714 Distributed Dbms Previous Question Paper

This post was last modified on 20 February 2020

This download link is referred from the post: GTU BE 2019 Summer Question Papers || Gujarat Technological University


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

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


This download link is referred from the post: GTU BE 2019 Summer Question Papers || Gujarat Technological University