Logical Query Processing

SRIMCA - Vidyanagar Mid Sem Paper

Atmiya Institute Midsem Paper

TN Rao Mid Sem paper

T.N.Rao College of Information and Technology

M.C.A. SEM. II MID SEM EXAMINATION MAY 2010

Sub: 620006 DBMS-II

DATE: 03/05/2010                      TIME: 45 Minutes                         MARKS: 20

Q.1	Attempt any two of the following		14
	(a)	What is transaction? Discuss ACID properties of transaction?
	(b)	What is Concurrency Control? List and explain problem of Concurrency?
	(c)	Describe shadow paging recovery technique in detail?
Q.2	Differentiate any two of the following		6
	(a)	Immediate Update Vs Deferred Update Technique
	(b)	Binary lock Vs Shared Lock
	(c)	Timestamp ordering technique Vs Optimistic Concurrency tech.