Database with Tables

Part 1 - Type of Maintenance Required By These Databases

A bookstore database requires maintenance such as log file maintenance which keeps track of every transaction in the bookstore database such as the books returned and those that are not returned. Log files help in ensuring that that database can be restored to a time before that. Therefore, it is essential for references. Another maintenance activity required in a bookstore database would be file compaction. As people continue using the bookstore, the data keeps growing. Therefore, there is need to compact files to create space for new data without deleting the old data.

P

Pay to View the Entire Post

To view this post and other posts in this category please pay the amount below