Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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;
