A goal of fragmentation in a distributed database is to improve performance by moving copies of the data closer to the users. (Example: In a banking situation, having my banking information close to me in my home state of Maryland and in California).
True
False
Which of the following could be used effectively to improve the performance of reading a table?
A. Partitioning the table across multiple physical drives
B. Oracle Keep Cache
C. Named Cache
D. All of the above
You have a distributed database with 4 sites. You decide on a symmetric synchronous architecture. What are the problems that must be overcome with this architecture?
A developer set up his DBMS to do full database backups nightly but his customer told him he could not loose more than 1 hours worth of data. The developers solution was to do full database backups every hour. What are the disadvantages of this solution?