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.

Computer Science & Information Technology

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

Computer Science & Information Technology

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

Computer Science & Information Technology

What feature of UNIX provides the GUI and is network-enabled?

A. BSD B. Aero C. Aqua D. X Window

Computer Science & Information Technology

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

Computer Science & Information Technology