Midterm2Key

Midterm2Key - CSCI 485, Midterm 2 Spring 2006: April 27,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CSCI 485, Midterm 2 Spring 2006: April 27, 2006 Prof. Shahram Ghandeharizadeh Warm-up and Terminology (30 points) 1. (5 points) Write your name and student id on your blue book. Shahram Ghandeharizadeh, 777-77-7777 2. (5 points) True or False: Atomicity means repeating an operation multiple times produces the same result. False 3. (5 points) True or False: A transaction may abort after executing its last statement and prior to generating its <commit> log record. True 4. (5 points) True or False: Time stamp based protocols are free from deadlocks. True 5. (5 points) True or False: With two phase locking, the serial order of transactions is the same as their order of arrival. False 6. (5 points) True or False: IS and IX lock modes are compatible. True Transaction Processing and Concurrency Control (20 points) 7. (20 points) A transaction processing system must support ACID properties of a transaction. What does the acronym ACID stand for? State what the letters ‘A’, ‘C’, ‘I’, and ‘D’ denote for 5 points each. Atomicity, Consistency, Isolation, Durability
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/11/2009 for the course CSCI 485 taught by Professor Ghandeharizadeh during the Fall '08 term at USC.

Page1 / 2

Midterm2Key - CSCI 485, Midterm 2 Spring 2006: April 27,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online