Instructions: Please complete this homework on your own.
Your company has had a disaster in the server room over the weekend. Luckily all database components where replicated to an off-site server. The last good backup of the database was on Thursday night, and you would like to implement a forward recovery to bring the database to the status it was at end of day Friday. How would you do that? (3pts)
List AND describe at least 5 information items that are stored in a database journal or log file (5pts).
Describe the concept of data independence (2 pts).
List and define 6 specific duties that a Database Administrator must perform (3pt).
Define the process of Archiving and describe a valid reason as to why a DBA would need to Archive (2pts).
What is the difference between a shared lock and an exclusive lock (2pt)?
List and define 3 important characteristics of a distributed DBMS (3pts).
You just made an update to a remote site on a distributed DB. You noticed the communication time for your update was 58 seconds and you know that the access delay on the network is estimated to be 4 seconds. You updated 30,000 records that were 600 bits long each. Calculate the transmission rate of the network you used to make the update. (Please show your work) (2pts).