What does compacting a database involve and why is this process needed?
What will be an ideal response?
As users work in a database by adding and deleting records and objects, the size of the database increases and decreases. However, the space created by deleting a record or object is not automatically recovered for use by records and objects that users add to the database. Just like any other computer file, a database becomes large with blocks of unused space. These unused areas can ultimately increase the database size and make it inefficient. The process of recovering unused space in a database is known as compacting the database. When you compact a database, the data and objects in the database are reorganized and unused spaces are reassigned and deleted. The end result is usually a database with a decreased file size and improved efficiency.
You might also like to view...
The default style set is called:
A) Default. B) Office 2013. C) Style 2013. D) Word 20130.
Answer the following questions true (T) or false (F)
1. True/False: To input a string from a user, we must know beforehand exactly how many characters are in that string. 2. True/False: An array does not have to be declared of any data type. 3. True/False: Databases consist of many linked tables.