违法和不良信息举报 联系客服
免费注册 登录

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

题目
单选题
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题：

Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values ‘C‘, ‘H‘ and ‘N‘, and permits inserts only when a corresponding value for the employee‘s department exists in the DEPARTMENT table.Which of the following CREATE statements will successfully create this table?（）

A.CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN (‘C‘,‘H‘,‘N‘)), );

B.CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES (‘C‘,‘H‘,‘N‘) );

C.CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN (‘C‘,‘H‘,‘N‘)), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );

D.CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN (‘C‘,‘H‘,‘N‘)) );


参考答案：D

第2题：

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

第3题：

在在SQL Server 2000中，设有课程表(课程号，课程名，学分，开课学期)，现要在此关系表上建立一个查询指定学期开设的课程总门数和总学分数的内嵌表值函数，函数名为f _FindTotal。实现这个函数的正确代码是

A．CREATE FUNCTION f_FindTotal(@semester int) RETURNS table AS RETURN( SELECT COUNT(课程号)as课程门数， SUM(学分)as总学分FROM课程表 WHERE开课学期 = @ semester)

B．CREATE FUNCTION f_FindTotal(@semester int) RETURNS table AS RETURN( SELECT COUNT(课程号)as课程门数， COUNT(学分)as总学分FROM课程表 WHERE开课学期 = @semester)

C．CREATE FUNCTION f_FindTotal(@semester int) RETURNS table AS RETURN( SELECT SUM(课程号)as课程门数， SUM(学分)as总学分FROM课程表 WHERE开课学期= @semester)

D．CREATE FUNCTION f_FindTotal(@semester int) RETURNS table AS RETURN( SELECT SUM(课程号)as课程门数， COUNT(学分)as 总学分FROM课程表 WHERE开课学期 = @semester)


正确答案：A

第4题：

Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?（）

  • A、CALL increase_salary('A00')
  • B、VALUES increase_salary('A00')
  • C、CALL increase_salary('A00', ?)
  • D、VALUES increase_salary('A00', ?)

正确答案:C

第5题：

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

正确答案:D

第6题：

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()

A.0

B.1

C.3

D.6


参考答案：D

第7题：

现有表Employee，字段：id（int）、firstname（varchar）、lastname（varchar）；以下sql语句错误的是（）

  • A、select firstname+’.’+lastnameas’name’from employee
  • B、select firstname+’.’+lastname=’name’from employee
  • C、select’name’=firstname+’.’+lastnamefrom employee
  • D、select firstname，lastname from employee

正确答案:B

第8题：

设在SQL Server 2008某数据库中有销售表（商品号，销售时间，销售数量，销售价格），其中商品号的类型为char（6），销售价格的类型为int。现要定义统计指定商品销售总价的标量函数。有下列定义该标量函数的语句：Ⅰ．Create FUNCTION db0．GetTotal（@GoodID char（6））Returns int ASBEGINReturn（SELECT SUM（销售价格）FROM销售表WHERE商品号=@GoodID．ENDⅡ．Create FUNCTION db0．GetTotal（@GoodID char（6））Returns int ASBEGINReturns（SELECT SUM（销售价格）FROM销售表WHERE商品号=@GoodID．ENDⅢ．Create FUNCTION db0．GetTotal（@GoodID chat（6））Returns intBEGINReturn（SELECT SUM（销售价格）FROM销售表WHERE商品号=@GoodID．END1V．Create FUNCTION db0．GetTotal（@GoodID char（6））Returns intReturns（SELECT SUM（销售价格）FROM销售表WHERE商品号=@GoodID．上述语句中，正确的是（ ）。

A.仅I和Ⅱ

B.仅Ⅲ和Ⅳ

C.仅Ⅱ和Ⅳ

D.仅I和Ⅲ


正确答案：D
标量函数返回一个确定类型的标量值。函数体语句定义在BEGIN-END语句内，其中包含了可以返回值的Transact-SQL命令。创建标量函数的语法如下：CREATEFUNCTION[ownername．]function_name（[{@parameter_name[AS][type_schema_name．]parameter_data_type[＝default]}[，…n]）RETURNSreturn_data_type[AS]BEGINfunction_bodyRETURNscalar_expressionEND[；]

第9题：

How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）

  • A、CALL getratews11('USA','CANADA')
  • B、CALL expenses.getratews11('USA','CANADA')
  • C、SELECT getratews11('USA','CANADA') FROM expenses
  • D、SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency

正确答案:C

第10题：

Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table. Which of the following CREATE statements will successfully create this table?（）

  • A、CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')), );
  • B、CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N') );
  • C、CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN ('C','H','N')), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );
  • D、CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N')) );

正确答案:D

更多相关问题
相关内容