Author Question: To support rollforward and rollback recovery, transactions must be written to a script before they ... (Read 45 times)

ss2343 · **on:** Jul 7, 2018

To support rollforward and rollback recovery, transactions must be written to a script before they are applied to the database.

Indicate whether the statement is true or false

Question 2

What are inconsistent values, and why are they a problem?

What will be an ideal response?

memslove · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

FALSE

Answer to Question 2

Inconsistent values are different forms of the same data value. For example, in a database of dog owners and their dogs, we might find a border collie listed as b. collie, collie, border, and border collie. This will create query problems. For example, a query for border collie will not return the dogs listed in the other formats. Or, alternatively, we would have to write a query that includes all possible (or at least known) variations of border collie, and that would be a real pain.