单项选择题
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'); END
How 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
相关考题
-
单项选择题
Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）
A.Visual Explain
B.Activity Monitor
C.SQL Performance Monitor
D.DB2 Performance Monitor -
单项选择题
Which of the following is NOT true about XML columns?（）
A.Data can be retrieved by SQL.
B.Data can be retrieved by XQuery.
C.XML columns must be altered to accommodate additional parent and child relationships.
D.Access to any portion of an XML document can be direct, without reading the whole document. -
单项选择题
Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）
A.CLOB
B.BLOB
C.Hierarchically
D.Rows and columns
