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 Winter 7th Sem New 2170714 Distributed Dbms Question Paper

Download GTU (Gujarat Technological University) BE/BTech (Bachelor of Engineering / Bachelor of Technology) 2019 Winter 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/B.Tech 2019 Winter Question Papers || Gujarat Technological University


FirstRanker.com

GUJARAT TECHNOLOGICAL UNIVERSITY
BE - SEMESTER- VII (New) EXAMINATION — WINTER 2019

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

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

Instructions:

  1. Attempt all questions.
  2. --- Content provided by FirstRanker.com ---

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

MARKS

Q.1 (a) Explain Complicating factors in distributed Database. 03

(b) Define Normalization. How anomalies can be eliminated with Normalization? 04

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

(c) Explain Client/Server Database architecture. 07

Q.2 (a) Explain Horizontal Fragmentation. 03

(b) Explain pull-only, push-only and hybrid Data Delivery Modes. 04

(c) Explain Top Down Design Process for Distributed Database. 07

OR

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

(c) Define Distributed Database System. What is transparency in DDBMS? Explain Layers of transparency in DDBMS. 07

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

(b) Explain Discretionary Access Control. 04

(c) Explain View management. How it is carried out in centralized and distributed DBMS? 07

OR

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

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

(b) Explain layers of Query processing. 04

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

Q.4 (a) Explain ACID Property of Transaction. 03

(b) Explain Type of Transactions. 04

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

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

OR

Q.4 (a) Explain Multiple Granularities. 03

(b) Explain classification of concurrency control algorithm in distributed database. 04

(c) Explain optimistic concurrency control algorithms. 07

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

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

(b) Define Reliability and Availability. 04

(c) Explain Deadlock Avoidance Techniques. 07

OR

Q.5 (a) Explain Fuzzy Check Points. 03

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

(b) Explain terms: Cascading Abort, Dirty Read, Fuzzy Read, and Conflict Equivalence. 04

(c) Write a Short note on: Shadow Paging. 07

FirstRanker.com


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


This download link is referred from the post: GTU BE/B.Tech 2019 Winter Question Papers || Gujarat Technological University