Question B4. Database Backup and Recovery (10 marks) (a) (2 marks) It is important that backups are taken regularly. There are two type of image copy backups i. Describe a full image copy backup i. Describe an incremental image copy backup. (b) (8 marks) Draw a diagram that illustrates the backup/restore and roll forward of a database with the following event history. i. Monday 0100HRS-Full Backup ii. Tuesday 0100HRS-Incremental Backup ii. Wednesday 0100HRS Incremental Backup iv. The database suffered a Disk Failure on Thursday afternoon 1600HRs, fortunately all the transaction logs were saved. The business shuts down and commences recovery v. Friday 0300 Database restored to operations vi. Friday 0500HRS Incremental Backup vi. Friday 0900 Business as usual vii. Saturday 0100HRS - Management decides to perform a full image copy backup. Question B5. (10 marks) Database System Performance (a) There are 3 key database system performance tuning areas: System Performance, Database Performance and Application Performance. i. (3 marks) Describe each performance area. ii. (3 marks) Describe 3 key components in System Configuration and Tuning. ii. (2 marks) Describe 2 key techniques in Database Performance Tuning Tuning. OR (b) (10 marks) There are a dozen SQL Rules of Thumb. List and describe 10 in detail