Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 604
|
Downflow is the process associated with __________ and back up of data in a warehouse.
|
packaging
|
|
|
archiving
|
|
|
extraction
|
|
|
loading
|
Question 604 Explanation:
→ Downflow is the process associated with archiving and backup of data in a warehouse.
→ Archived files (or) logs are crucial for recovery when no data can be lost, because they constitute a record of changes to the database.
Avantages using archiving
1. The database can be completely recovered from both instance and media failure.
2. The user can perform backups while the database is open and available for use.
3. The database can be completely recovered from both instance and media failure.
→ Archived files (or) logs are crucial for recovery when no data can be lost, because they constitute a record of changes to the database.
Avantages using archiving
1. The database can be completely recovered from both instance and media failure.
2. The user can perform backups while the database is open and available for use.
3. The database can be completely recovered from both instance and media failure.
Correct Answer: B
Question 604 Explanation:
→ Downflow is the process associated with archiving and backup of data in a warehouse.
→ Archived files (or) logs are crucial for recovery when no data can be lost, because they constitute a record of changes to the database.
Avantages using archiving
1. The database can be completely recovered from both instance and media failure.
2. The user can perform backups while the database is open and available for use.
3. The database can be completely recovered from both instance and media failure.
→ Archived files (or) logs are crucial for recovery when no data can be lost, because they constitute a record of changes to the database.
Avantages using archiving
1. The database can be completely recovered from both instance and media failure.
2. The user can perform backups while the database is open and available for use.
3. The database can be completely recovered from both instance and media failure.