Content Calendar Grades UserProgress Attendance Help $vv$

Table of Contents $>$ Database Management Topics $9-10,$ Topic $9-$ Transaction Management $/$ Performance Optimization $/$ Database Administration $($Weeks $13$ and $14)>$ Assignment

Assignment $7$

$$

Section $1$: Review Questions

Refer to the textbook to answer the following "Review Questions". You do not need to provide a citation when answering from the textbook If you use another source, you MUST provide a citation or link to the source AND avoid copy$/$paste of content. IMPORTANT: "homework help" websites are NOT permitted and your use of these websites to answer assignment questions may result in Academic Dishonesty sanctions. Answers must be complete ${?}^{**}(2$ marks each question$)$

What is a consistent database state, and how is it achieved?

What is the ACID test? Briefly describe each of the four individual transaction properties of ACID What is a transaction $log$ and what is its purpose?

How are database statistics obtained? Why are they important?

In simple terms, the DBMS processes a query in three phases. What are the phases, and what is accomplished in each phase?

What is the difference between a rule$-$based optimizer and a cost$-$based optimizer?

What are some general guidelines for creating and using indexes? Also, why not index every column in every table?

Section $2$: Problems

Type here to search