Chat with us, powered by LiveChat

Define the process of Archiving and describe a valid reason as to why a DBA would need to Archive

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).


Last Completed Projects

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min