nerdexam
IBM

C2090-420 · Question #81

The search framework supports the dynamic creation of an SQL statement based on the search business object. What are three important steps in the creation at a dynamic query? (Choose three.)

The correct answer is A. Create an ordered collection of CriterionElements, which represent the SQL criteria. C. Create an instance of the appropriate search input class by passing in the search business D. Create an instance of SearchSQL, using the SQL statement, criterion elements, and the search. See the full explanation below for the reasoning.

Question

The search framework supports the dynamic creation of an SQL statement based on the search business object. What are three important steps in the creation at a dynamic query? (Choose three.)

Options

  • ACreate an ordered collection of CriterionElements, which represent the SQL criteria.
  • BThe SELECT column list must depend on (correlate to) the input parameters.
  • CCreate an instance of the appropriate search input class by passing in the search business
  • DCreate an instance of SearchSQL, using the SQL statement, criterion elements, and the search
  • EUse the default search result set processor class to handle the list of criteria columns.

How the community answered

(43 responses)
  • A
    72% (31)
  • B
    19% (8)
  • E
    9% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-420 Practice