IBM
C2090-420 · Question #67
For the pre-written SQL statement to be successfully fetched in the FETCH algorithm, there are a number of points to keep in mind while designing the search SQL statements. What are two correct…
The correct answer is A. A pre-written SQL will only be selected if each non-null and non-blank input parameter passed C. The SQL lookup algorithm only considers the search input parameters passed into the search. See the full explanation below for the reasoning.
Question
For the pre-written SQL statement to be successfully fetched in the FETCH algorithm, there are a number of points to keep in mind while designing the search SQL statements. What are two correct consideration points? (Choose two.)
Options
- AA pre-written SQL will only be selected if each non-null and non-blank input parameter passed
- BAll elements of the SQL criteria are considered during a lookup, including the (AND, OR)
- CThe SQL lookup algorithm only considers the search input parameters passed into the search
- DA criterion element may only appear once in the SQL.
How the community answered
(38 responses)- A74% (28)
- B8% (3)
- D18% (7)
Community Discussion
No community discussion yet for this question.