Examice

Exam MCD - Level 1 All QuestionsBrowse all questions from this exam

Question 124

Refer to the exhibit. How should the WHERE clause be changed to set the city and state values from the configured input parameters?

WHERE city = :city AND state = :state

WHERE city = attributes.city AND state = attributes.state

WHERE city := ${city} AND state := ${state}

WHERE city = #[city] AND state = #[state]

Correct Answer: A

To set the city and state values from the configured input parameters in SQL, the appropriate syntax is to use bind variables. This can be done using the colon (:) followed by the parameter name. Therefore, the correct WHERE clause change is: WHERE city = :city AND state = :state.

Discussion

RanjansinghOption: A

A - correct

AlandtOption: A

ChatGPT: Therefore, the correct way to change the WHERE clause to use the configured input parameters would be: A. WHERE city = :city AND state = :state

ExamDevOption: A

A - correct