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?
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;
|
Download Printable PDF. VALID exam to help you PASS. |
 |