cs2029 adt int1

GKM COLLEGE OF ENGINEERING AND TECHNOLOGY CHENNAI – 63 Department of Information Technology U.G / Internal Test - I Year/Sem: IV/VII Branch: IT Sub Code/Name: CS2029-Advanced Database Technology Max Marks: 50 Date: 12/08/2015 Duration: 1.5 hrs Part – A Answer all the questions: (7x2=14 marks) 1. Define ACID in transaction processing. 2. List out the different levels in data base tuning? 3. Differentiate distributed intra query parallelism from inter query parallelism. 4. Differentiate distributed database and normal database. 5. State any two features of distributed database. 6. Write an SQL query to retrieve employee name and ID from a table employee? 7. List the features of DDB? Part – B Answer any three questions: (3x12=36 marks) 1. Discuss in detail about cost based query optimization in RDBMS with example. 2. Write short notes on transaction processing in RDBMS. 3. Discuss query optimization in DDBMS briefly.

Upload: jai-sharma

Post on 17-Aug-2015

218 views

Category:

Documents

4 download

Report

Download

Embed Size (px):

DESCRIPTION

hghfhgf

TRANSCRIPT

GKM COLLEGE OF ENGINEERING AND TECHNOLOGYCHENNAI 63Department of Information Tecno!o"#$%G & Interna! Te't ( IYear&)em* I+&+II ,ranc* IT)-. Co/e&Name* C)0102(A/3ance/ Data.a'e Tecno!o"#Ma4 Mar5'* 61Date* 70&18&0176 D-ration* 7%6 r'9art AAn':er a!! te ;-e'tion'*7? mar5'@1. Defne ACID in transaction processing.2. List out the diferent levels in data base tuning?3. Diferentiate distributed intra quer parallelis! "ro! inter quer parallelis!.#. Diferentiate distributed database and nor!al database. $. %tate an t&o "eatures o" distributed database.'.(rite an %)L quer to retrieve e!ploee na!e and ID "ro! a table e!ploee?*. List the "eatures o" DD+?9art ,An':er an# tree ;-e'tion'*36 mar5'@1. Discuss in detail about cost based quer opti!i,ation in -D+.% &ithe/a!ple.2. (rite short notes on transaction processing in -D+.%.3. Discuss quer opti!i,ation in DD+.% brie0.#. Illustrate the several architectural !odels "or parallel database.$. Discuss t&o phase loc1ing protocol technique "or concurrenc in detail. %ub %taf %ub .entor 23D

ADT Catalogo

SC 1139 Woodruff Road - images4.loopnet.comimages4.loopnet.com/d2/ypgE-n4jYlwFa5PxdqdMd5... · sc atlanticretail.com the vitamin shoppe adt adt adt rd rd dr adt 85 385 greenville,

Int1 SN Movement

Multi-Family Residential and Commercial Developments€¦ · 40,466 adt 27,292 adt 54,303 adt 31,094 adt 44,583 adt e sr 434 w 43 an t st orange ave e church ave lre a ve e r ave

LB Classic Int1 110819

201216-Lindsey- InT1 Task 114.1.1 Revision 3

Proposal for a Shared INT1 Symbol Repository - iho.int Excerpt… · Proposal for a Shared INT1 Symbol Repository ... When the CSPCWG introduce a new symbol for the paper chart,

vpagpe 120v InT1 2e - Shenehon

SolGetreadyPre Int1

Hotel Standard INT1

ryb-int1.edu.yar.ru fileryb-int1.edu.yar.ru

AN UPDATE ON...Roadway Type (# Lanes + Median Type) Vehicle ADT < 9,000 Vehicle ADT > 9,000 - 12,000 Vehicle ADT >12,000 - 15,000 Vehicle ADT > 15,000 SPEED LIMIT (mph)