If a single row of the PLAN_TABLE has a ‘Y’ value in more than one of the sort composite
columns, what is indicated?

A.
The next sort step will perform two sorts.

B.
There are multiple sorts in the plan step.

C.
One sort in the plan step will accomplish two tasks.

D.
Two sorts are performed on the new table of a star join.

Explanation: