What is a transaction log, and what is its function?
Answer to relevant QuestionsWhat is a scheduler, what does it do, and why is its activity important to concurrency control?What is an exclusive lock, and under what circumstances is it granted?Suppose that your database system has failed. Describe the database recovery process and the use of deferred-write and write-through techniques.Starting with a consistent database state, trace the activities that are required to execute a set of transactions to produce an updated consistent database state.If indexes are so important, why not index every column in every table? (Include a brief discussion of the role played by data sparsity.)
Post your question