多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END()

  • A、CALL getratews11('USA','CANADA')
  • B、CALL expenses.getratews11('USA','CANADA')
  • C、SELECT getratews11('USA','CANADA') FROM expenses
  • D、SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题