How can you correct errors in data?

What will be an ideal response?


It depends on the type of error. If there is an extra row in the table, use the DELETE command to remove it. If there is a row of data missing, use the INSERT command to add it. If a row contains an incorrect value, use the UPDATE command to change the value.

Computer Science & Information Technology

You might also like to view...

____ arrays are two or more arrays whose elements are related by their position in the arrays.

A. Parallel B. Connected C. Equivalent D. Comparable

Computer Science & Information Technology

Which of the following is not considered a tool used to analyze and improve the performance of a database?

A. Field Analyzer B. Database Documenter C. Performance Analyzer D. Table Analyzer

Computer Science & Information Technology

A disk management software utility named ____________________ searches your hard drive for unnecessary files to delete.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

What is wrong with the following code fragment? Will this code compile if it is part of an otherwise valid program? Explain.

``` if (length = MIN_LENGTH) System.out.println("The length is minimal."); ```

Computer Science & Information Technology