nerdexam
IBM

C2090-610 · Question #126

If a table named MY_TAB contains 100 rows and the following statement is executed: What will happen?

The correct answer is A. The last 5 rows in the table will be deleted. See the full explanation below for the reasoning.

Question

If a table named MY_TAB contains 100 rows and the following statement is executed:

What will happen?

Options

  • AThe last 5 rows in the table will be deleted.
  • BThe first 5 rows in the table will be deleted.
  • CThe statement will fail because a subquery cannot be used with a DELETE statement.
  • DThe statement will fail because a table name was not specified with the DELETE statement.

How the community answered

(20 responses)
  • A
    85% (17)
  • B
    5% (1)
  • D
    10% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice