IBM认证考试

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 Ho

题目

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
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Evaluate the following function code:Which statement is true regarding the above function? ()

A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.

C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.

D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.


参考答案：A

第2题：

Given the configuration shown in the exhibit, what is the function of the protect－loopback filter?()

A. to protect the Routing Engine

B. to protect all interfaces on the device

C. to protect the Packet Forwarding Engine

D. to protect the management interface


参考答案：A

第3题：

Questions 59-60 are based on the following information

A hash table With hash function

H1(k)=k mod 13

Is shown below．

Collision is resolved using the hash function H2(k)=(k mod 11)+1

How many key comparisons occur in searching for key 35 in the given hash table?

A．0

B．1

C．2

D．3


正确答案：D

第4题：

Which of the following are types of routine objects?()

A.Package and function

B.Function and userexit

C.Procedure and package

D.Function and procedure


参考答案：D

第5题：

all of the following are function of crm system except （）

A.automation procurement

B.automation sales

C.automation marketing

D.automation customer service


正确答案：A
所有以下是客户关系管理系统功能除了（）A、自动化采购B、自动化销售C、自动化营销D、自动化客户服务

第6题：

Which of the following statements describe the use of the keyword

static?

a) Within the body of a function: A static variable maintains its value

between function revocations

b) Within a module: A static variable is accessible by all functions

within that module

c) Within a module: A static function can only be called by other

functions within that module


正确答案：
 

第7题：

A technician is troubleshooting a network connectivity issue. Given the following abbreviated traceroute output:Which of the following is MOST likely occurring?()

A. Switching loop

B. Broadcast storm

C. IP conflict

D. Routing loop


参考答案：D

第8题：

A word is a___free form. of a language that has a given sound and meaning and syntactic function.


参考答案：minimal

第9题：

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‘); ENDHow 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


参考答案：D

第10题：

Among the following， ( ) is NOT one of the functions of adult′s language according to Halliday.

A.the Ideational Function
B.the Syntactic Function
C.the Interpersonal Function
D.the Textual Function

答案：B
解析：
语言学基本知识。询问哪一项不属于Halliday所定义的语言的功能。Halliday是Systematic-functionalGrammar(系统功能语法)的创始人。根据他的理论，语言有三个功能，即Ideational Function(概念功能)、Interpersonal Function(交际功能)和Textual Function(文本功能)。

更多相关问题
相关内容