单项选择题

Which of the following will DELETE all of the rows from table T03?（）

A.DELETE * FROM TABLE T03
B.DELETE ALL FROM T03
C.DELETE * FROM T03
D.DELETE FROM T03

点击查看答案

上一题目录下一题

相关考题

单项选择题

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?（）

A.SORT BY age ASC, last_name
B.SORT BY age DESC, last_name
C.ORDER BY age DESC, last_name
D.ORDER BY age ASC, last_name

单项选择题

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