Note: also take a look at the sample midterm from Winter 2006 for an XML question.
Note: also take a look at the sample finals above for additional questions on transactions. Our midterm will cover all of transactions: recovery and concurrency control.