Which of the following is a method to ensure only the desired rows will be updated?

a. Call in an outside consultant whenever an update is needed.
b. First, write a SELECT statement to select the rows you want updated, and then transfer the WHERE clause to the UPDATE statement.
c. Have the same person always perform updates.


b. First, write a SELECT statement to select the rows you want updated, and then transfer the WHERE clause to the UPDATE statement.

Computer Science & Information Technology

You might also like to view...

Why is it important to monitor how many times an update query is executed?

What will be an ideal response?

Computer Science & Information Technology

A document ________ is a set of coordinated fonts, colors, and special effects

A) theme B) template C) style D) form

Computer Science & Information Technology

What are the keyboard shortcuts to zoom in, zoom out, and fit on-screen for the Timeline?

What will be an ideal response?

Computer Science & Information Technology

Referring to the figure above, in order to choose "Edit Tag" in the Quick Tag Editor window, what would you do?

A. Click on the list arrow shown to the right of "Edit Tag" in the Quick Tag Editor window. B. Choose Insert on the Behaviors tab shown in the right pane. C. Type text in the box that says "Edit Tag" in the Quick Tag Editor window. D. Close the window, choose a section of code, and then open the window again.

Computer Science & Information Technology