Why would a database administrator choose to split a database?
What will be an ideal response?
There are five reasons stated in the book for this question.
1) Improved Performance:The performance of the database usually improves because only the data is sent across the network—not the queries, forms, reports, macros, and modules.
2) Greater Data Availability:When only the data is sent across the network, database edits are completed more quickly, which makes the data available quicker.
3) Enhanced Security: If you store the back-end database on a server, you can use the server's security features to help protect your data.
4) Improved Reliability: If a user encounters a problem and the database closes unexpectedly, any database file corruption is usually limited to the front-end database.
5) Flexible Development Environment Because each user works with a separate copy of the front-end database, each user can independently develop queries, forms, reports, and other database objects without affecting other users. Also, developers can distribute an updated version of the front-end database without affecting the data in the back-end database.
You might also like to view...
Motion ____________________, which are commands that create motion tweens, allow you to quickly animate symbols entering and exiting the stage with special effects that would otherwise take a long time to create.
Fill in the blank(s) with the appropriate word(s).
If a negative value is used for an array index, ____.
A. a NumberFormatException is thrown B. the program terminates automatically without throwing an exception C. the last index of the array is automatically accessed instead D. an ArrayIndexOutOfBoundsException is thrown
What feature of UNIX provides the GUI and is network-enabled?
A. BSD B. Aero C. Aqua D. X Window
The ____ method keeps the free/busy lists organized by memory locations, from low-order memory to high-order memory.
A. fixed partition allocation B. first-fit memory allocation C. dynamic fit memory allocation D. best-fit memory allocation