nerdexam
IBM

A2090-560 · Question #119

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

The correct answer is A. The number of rows in the table. E. The minimum and maximum column value information (excluding text columns). See the full explanation below for the reasoning.

Question

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

Options

  • AThe number of rows in the table.
  • BThe column histogram statistics.
  • CThe number of NULLs in each column.
  • DThe number of unique values in each column.
  • EThe minimum and maximum column value information (excluding text columns).

How the community answered

(22 responses)
  • A
    73% (16)
  • B
    5% (1)
  • C
    9% (2)
  • D
    14% (3)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice