Explain why it is necessary to have procedures in place to back up and restore a database.
What will be an ideal response?
A database can become damaged or destroyed as a result of a variety of problems: users can enter incorrect data, programs that update the database can end abnormally during an update, a hardware problem can occur, and so on. After any such event has occurred, the database might contain invalid data, or even be totally destroyed.
When data has been damaged or destroyed you must have a process to return the database to its correct state. This is called recovery. The simplest approach to recovery is to periodically make a copy of the database. This is called a back up copy. If a problem occurs you copy the backup database copy over the damaged database.
You might also like to view...
A white space between side-by-side columns can be set up using which of the following?
A. the left margin of the left column B. the right margin of the right column C. the right margin of the left column D. none of the above
In some situations, it's best to approach a problem from a ________ perspective, following steps in order
Fill in the blank(s) with correct word
?_____, a risk control strategy, eliminates risks by adding protective safeguards.
A. ?Avoidance B. ?Acceptance C. ?Conveyance D. ?Transference
The ____________________ property sets the size of text in a control.
Fill in the blank(s) with the appropriate word(s).