PrepAway - Latest Free Exam Questions & Answers

How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:

How can this function be used to convert average temperature (AVG_TEMP) data stored in a table
called CLIMATE_INFO?

PrepAway - Latest Free Exam Questions & Answers

A.
CALL conv_temp(climate_info.avg_temp);

B.
CALL convert_ftoc(climate_info.avg_temp);

C.
SELECT conv_temp(avg_temp) FROM climate_info;

D.
SELECT convert_ftoc(avg_temp) FROM climate_info;

Explanation:


Leave a Reply