IBM

P2090-050 · Question #50

The simplest query execution plan file must have the following minimum nodes?

The correct answer is C. ScanNode, RestrictNode, ProjectNode, ReturnNode. See the full explanation below for the reasoning.

Question

The simplest query execution plan file must have the following minimum nodes?

Options

AScanNode, RestrictNode, LimitNode, ReturnNode
BScanNode, RestrictNode, HashNode, ReturnNode
CScanNode, RestrictNode, ProjectNode, ReturnNode
DScanNode, RestrictNode, AggregateNode, ReturnNode

How the community answered

(24 responses)

A
8% (2)
B
8% (2)
C
79% (19)
D
4% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full P2090-050 Practice