DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
To save time
|
|
To prevent losing data
|
|
To clean up the database
|
|
None of the above
|
Detailed explanation-1: -Creating backups on a regular basis is especially important when you have several users updating a database. Without a backup copy, you cannot restore corrupted or missing objects or any changes to the database design.
Detailed explanation-2: -If you schedule a nightly or weekly backup, you can limit the amount of data that is lost in the event that a computer or your entire system were to fail. A scheduled backup allows you to relax because you know that all of your information is being backed up, and you are limiting what you may lose.
Detailed explanation-3: -Restore valuable business data That’s why it’s important to prioritize backup and recovery operations to ensure an optimal balance between risk and performance. You should schedule backups on a per-system basis, with the most important and time-sensitive data being backed up regularly, such as every hour.
Detailed explanation-4: -Automated backups are more reliable and less error-prone than manual backups. With automated backups, you can ensure consistent data protection, reduce recovery windows, and improve business continuity.
Detailed explanation-5: -If you use your computer frequently (i.e. spend over 10 hours a week on your PC), you should back up your data weekly. Occasional PC users (those spending five hours or less) should similarly perform data back at least once a week. However, if you own an e-commerce store, performing daily backups would be ideal.