Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow ca
题目
Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?
A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
相似考题
参考答案和解析
更多“Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , first ”相关问题
-
第1题：
You are consuming a Windows Communication Foundation (WCF) service in an ASP. NET Web application.The service interface is defined as follows:[ServiceContract]public interface ICatalog{ [OperationContract] [WebGet(UriTemplate="/Catalog/Items/{id}", ResponseFormat=WebMessageFormat.Json)] string RetrieveItemDescription(int id); } The service is hosted at Catalogsvc.You need to call the service using jQuery to retrieve the description of an item as indicated by a variable named itemId. Which code segment should you use?（）
A. $get(String.format("/Catalogsvc/Catalog/Items/id{0}", itemId) null, function (data) { ... }, javascript");
B. $get(String.format("/Catalogsvc/Catalog/Items/{0}", itemId), null, function (data) { ... }, "json");
C. $get(String.format("/Catalogsvc/Catalog/Items/{0}", itemld), null, function (data) { ... }, "xml");
D. $get(String.format("/Catalogsvc/Catalog/Items/id{0}", itemld), null, function (data) { ... }, "json");
参考答案：B
-
第2题：
对于函数原型void function(int x，float y，char z='a')，合法的函数调用是( )。
A．function(2，3．Of)
B．function(2，3，4)
C．function(2)
D．function()
正确答案：A
解析：由于只有第三个参数有默认值，故要求给出前两个参数的值。 -
第3题：
10、以下 jQuery 事件处理程序的写法错误的是？
A．$("#id").hover(function(){ //some code },function(){ //other code });
B．$(function(){ //some code });
C．$.click(function(){ //some code });
D．$("#id").click(function(){ //some code });
click;change -
第4题：
GivenanELfunctiondeclaredwith：11.<function>12.<name>spin</name>13.<function-class>com.example.Spinner</function-class>14.<function-signature>15.java.lang.StringspinIt（）16.</function-signature>17.</function>Whichtwoaretrue？（）
A.Thefunctionmethodmusthavethesignature：publicStringspin（）.
B.Themethodmustbemappedtothelogicalname"spin"intheweb.xmlfile.
C.Thefunctionmethodmusthavethesignature：publicStringspinIt（）.
D.ThefunctionmethodmusthavethesignaturepublicstaticStringspin（）.
E.Thefunctionmethodmusthavethesignature：publicstaticStringspinIt（）.
F.ThefunctionclassmustbenamedSpinner，andmustbeinthepackagecom.example.
参考答案：E, F
-
第5题：
设A是一个类的类名，下面函数的参数的引用形式是( )。
A．function(A &p)
B．function(A p)
C．function(A *p)
D．function(constＡ)
正确答案：A
解析：重载的语法。