单选题 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?
SELECT TABLE(EMPLIST()) FROM EMPLOYEE
SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
单选题 Which of the following will begin a new unit of work?()
The CONNECT statement
The first FETCH of a cursor
The BEGIN TRANSACTION statement
The first executable SQL statement
单选题 Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()
Journal
Task Center
Activity Monitor
Command Line Processor
单选题 Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?()
LIST DB DIRECTORY
LIST DCS DIRECTORY
LIST NODE DIRECTORY
LIST ACTIVE DATABASES
单选题 If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?()
Rollback the transaction in both applications.
Rollback the transaction in one of the two applications.
Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
单选题 On which of the following database objects may the SELECT privilege be controlled?()
Sequence
Schema
Group
View
单选题 Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?()
SELECT * FROM t1 UNION SELECT * FROM t2
SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
SELECT * FROM t1 INTERSECT SELECT * FROM t2
SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
下列属于直线行驶的是()
某通信机房设置七氟丙烷预制灭火系统,该系统应有( )种启动方式。
唐后期书院产生的一个原因是受到()的影响。
压力损失是指()
干旱区造林,整地的主要目的是()
治癫证痰气郁结证,治以()
小学低、中年级的儿童____识记发展最为迅速。
( )是北京市制定的第一个全面保护历史文化名城的法规。
安全带的正确使用:使用前作外观检查,若破损应()使用。
Your network consists of a single Active Directory domain. The domain contains more than 300 group objects. The group objects are divided between several regional organizational units (OUs). You need to create a list of all groups that have names that begin with the word Sales. Which command should you use? ()