DS0-001 · Question #145
DS0-001 Question #145: Real Exam Question with Answer & Explanation
The correct answer is A: UPDATE. UPDATE is the correct choice because it modifies existing records in a database table without removing them - perfect for correcting data that was imported incorrectly. DELETE removes rows entirely rather than fixing them, so it destroys data instead of correcting it. ALTER TABLE
Question
A database administrator realizes that certain data was not captured correctly when it was imported. Which of the following commands should the administrator use to fix the issue?
Options
- AUPDATE
- CDELETE
- DALTER TABLE
Explanation
UPDATE is the correct choice because it modifies existing records in a database table without removing them - perfect for correcting data that was imported incorrectly. DELETE removes rows entirely rather than fixing them, so it destroys data instead of correcting it. ALTER TABLE changes the structure of a table (adding/removing columns, changing data types), not the actual data values stored within it. There is no option B listed, but common distractors like INSERT would add new rows rather than fix existing ones.
Memory tip: Think "UPDATE = edit in place." If data exists but is wrong, you UPDATE it - just like updating a contact's phone number in your phone rather than deleting and re-adding them.
Community Discussion
No community discussion yet for this question.