Suppose a system crashes during the undo phrase. All the actions, including the undo actions, will be redone and undone if the transaction is not committed yet.

 If 2PL is enforced, a transaction is not allowed to downgrade a lock during the growing phase.

During the redo phase, all the actions will be redone if they update a page that is in the Dirty Page Table

At the end of the analysis phase, the dirty page table only contains the entries of the pages updated by the transactions that were still active when crash happened.

 If wound-wait policy is used, it is impossible that a deadlock could occur.

The single urogenital opening in birds and monotremes is called the cloaca.

The random variable X represents the number of classes a student skipped. The probability distribution for this scenario is shown below. Number of Classes p(x) 0 0.21 1 0.38 2 0.34 3 0.05 4 0.02   The probability that a randomly selected student skipped exactly 4 classes is Event A.  The probability that a randomly selected student skipped at most 2 classes is Event B.  The probability that a randomly selected student skipped at least 3 classes is Event C. Find the average number of skipped classes for this population. 

The number of miles employees drive to their jobs are normally distributed with a mean of 18 miles and a standard deviation of 3.4 miles. How many miles do the farthest 4% drive?  Report your answer to 2 decimal places.  

A local consignment shop offers both new and used furniture. The following table shows the furniture classified by type and condition. Table Chair Desk New 70 50 25 Used 125 100 25   What is the probability that a randomly chosen item was a desk GIVEN that it was New? Report your answer to 3 decimal places. 

A real estate agent reports that 29% of buyers purchase one of the first houses they tour.   This agent has been busy and has had 206 clients. How many do you expect bought one of the first houses they toured? Report your answer to 2 decimal places.