A student is analyzing Query Processing. Which statement about cardinality estimation is correct?

Correct Answer: B

the optimizer estimates how many rows an operation will produce

This statement is correct because cardinality estimation means that the optimizer estimates how many rows an operation will produce.