IBM
C2090-420 · Question #67
C2090-420 Question #67: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-420 to reveal the answer and full explanation for question #67. The question stem and answer options stay visible for context.
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.
Unlock C2090-420 to see the answer
You've previewed enough free C2090-420 questions. Unlock C2090-420 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.