The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
QUESTION 2
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?
-----------