IBM
C2090-610 · Question #125
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…
The correct answer is C. SELECT conv_temp(avg_temp) FROM climate_info. See the full explanation below for the reasoning.
Question
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?
Options
- ACALL conv_temp(climate_info.avg_temp);
- BCALL convert_ftoc(climate_info.avg_temp);
- CSELECT conv_temp(avg_temp) FROM climate_info;
- DSELECT convert_ftoc(avg_temp) FROM climate_info;
How the community answered
(43 responses)- A16% (7)
- B2% (1)
- C74% (32)
- D7% (3)
Community Discussion
No community discussion yet for this question.