Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）

单项选择题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