Answer-first summary for fast verification
Answer: CREATE FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNS DOUBLERETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;
The correct SQL DDL statement to create a UDF for converting distance values between Miles and Kilometers, while returning the input value for any other distance measure, must include the function name, parameters, the return type, and the custom logic. The correct syntax is: `CREATE FUNCTION convert_distance(distance DOUBLE, measure STRING) RETURNS DOUBLE RETURN CASE WHEN measure = 'Miles' THEN (distance * 1.60934) WHEN measure = 'KM' THEN (distance * 0.621371) ELSE distance END;`
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which SQL DDL statement correctly creates a User-Defined Function (UDF) to convert distance values between Miles and Kilometers, returning the input value for any other distance measure?
A
CREATE UDF convert_distance(distance DOUBLE, measure STRING)RETURN CASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;
B
CREATE UDF FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;
C
CREATE FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;
D
CREATE FUNCTION convert_distance(distance DOUBLE, measure STRING)RETURNS DOUBLERETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;
E
CREATE UDF convert_distance(distance DOUBLE, measure STRING)RETURNS DOUBLERETURNCASE WHEN measure = “Miles“ THEN (distance * 1.60934) WHEN measure = “KM“ THEN (distance * 0.621371) ELSE distanceEND;