单项选择题

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

单项选择题For which of the following is a data warehouse optimized?（）

A.Backup and recovery
B.Transactions
C.Security
D.Queries

单项选择题Which of the following is the main feature of an OLTP application?（）

A.Summarized queries
B.Granular transactions
C.Voluminous historical data
D.Heterogeneous data sources