IBM
P2090-050 · Question #75
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
(46 responses)- A80% (37)
- B11% (5)
- C7% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.