搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

Given the following function:<br /> 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 (&#39;A00&#39;, &#39;B00&#39;); END<br /> 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

查看正确答案
更多“ Given the following function:<br /> 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 (&#39;A00&#39;, &#39;B00&#39;); END<br /> How can this function be used in an SQL statement?”相关的问题
第1题
[] A new company has been given one public IP address. The company employs 200 users requiring Internet access from the headquarters. Which of the following can be implemented to provide Internet access for all the employees?（） A new company has been given one public IP address. The company employs 200 users requiring Internet access from the headquarters. Which of the following can be implemented to provide Internet access for all the employees?（）

A、A. Multicasting  B、B. Proxy server  C、C. NAT  D、D. Subnetting  

点击查看答案
第2题
[] Given the following MPLS L2 configuration command: mpls-relay 10.1.1.1 4 Which two statements true? （）(Choose two.) Given the following MPLS L2 configuration command: mpls-relay 10.1.1.1 4 Which two statements true? （）(Choose two.)

A、A. This command is applied to the core router facing interface.  B、B. This command is applied to the customer facing interface.  C、C. The 4 is locally significant and identifies the layer 2 circuit.  D、D. The 4 must match exactly on the peer router configuration on the remote end.  

点击查看答案
第3题
[] Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（） Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）

A、A.2  B、B.7  C、C.9  D、D.14  

点击查看答案
第4题
[单选题] A technician is troubleshooting a network connectivity issue. Given the following abbreviated trace route output: Which of the following is MOST likely occurring?（）

A、Switching loop  B、Broadcast storm  C、IP conflict  D、Routing loop  

点击查看答案
第5题
[] Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（） Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（）

A、A.Compilation fails.  B、B.Nothing is added to the file system.  C、C.Only a new file is created on the file system.  D、D.Only a new directory is created on the file system.  E、E.Both a new file and a new directory are created on the file system.  

点击查看答案
第6题
[单选题] Exhibit Given the information provided in the Exhibit, which of the following procedures will successfully resolve the problem before rebooting in normal mode?（）

A、Increase the size of rootvg.  B、Delete unnecessary files in the / (root) file system.  C、Edit /etc/inittab and correct any erroneous entries.  D、Run fsck on the rootvg and recreate the log device with the following command: /usr/sbin/logform /dev/hd8.  

点击查看答案
第7题
[单选题] Given the following policy, what happens when the 1.1/17 route is evaluated?（）

A、The route does not match this policy.  B、The route is accepted.  C、The route is rejected.  D、The route is accepted with a metric of 6.  

点击查看答案
第8题
[单选题] An administrator is trying to extend an existing volume group with a new hard disk, but the extendvg command returns the following error. 0516-1162 /usr/sbin/extendvg. Warning, The Physical Partition Size of 64 requires the creation of 8924 partitions for hdisk11. The limitation for volume group datavg is 1016 physical partitions per physical volume. Use chvg command with -t option to attempt to change the maximum Physical Partitions per Physical volume for this volume group. The chvg -t may or may not allow the extendvg command to succeed. What is the implication of using this option?（）

A、It reduces the maximum file size allowed within the given volume group.  B、It reduces the maximum number of files allowed within the given volume group.  C、It reduces the maximum number of logical volumes allowed within the given volume group.  D、It reduces the maximum number of physical volumes allowed within the given volume group.  

点击查看答案
第9题
[] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（） Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）

A、A.SELECT * FROM T1 MINUS SELECT * FROM T2  B、B.SELECT * FROM T1 EXCEPT SELECT * FROM T2  C、C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1  D、D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2  

点击查看答案
第10题
[单选题] Given the following router output,which configuration file will the router use at its next reload?（）

A、config  B、clientqos.cnf  C、startup-config  D、running-configuration  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服