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?

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

Database Management and Maintenance

Question

Options

AUPDATE
CDELETE
DALTER TABLE

How the community answered

(36 responses)

A
83% (30)
C
11% (4)
D
6% (2)

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.

Topics

#SQL UPDATE#Data correction#DML operations#Data modification

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice