Database Fundamentals — Question 92

This question requires that you evaluate the underlined text to determine if it is correct.
Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt database.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.

Answer options

• A. Change is needed
• B. Commit
• C. Attach
• D. Restore

Correct answer: D

Explanation

The term 'truncate' is incorrect in this context as it refers to removing data from a table. The correct term for applying a backup to a damaged database is 'restore,' hence option D is the right choice. The other options do not accurately describe the process of recovering a database from a backup.