网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Select the 3 best answers describing operation and configuration of Frame-Relay Inverse ARP.（）
- A、Dynamic address mapping uses Frame Relay Inverse ARP to request the next-hop protocol address for a specific connection on its known DLCI
- B、Responses to Inverse ARP requests are entered in an address-to-DLCI mapping table on the router or access server which is used to supply the next-hop protoco address or the DLCI for outgoing traffic
- C、Inverse ARP is enabled by default for all protocols enabled on the physical interface
- D、Inverse ARP is configured using the following command under the Interface configuration ’frame-relaymap dlci （dlci number） protocol protocol-address’
- E、Inverse ARP in Frame-Relay is synonymous of ARP in Ethernet
参考答案
更多 “Select the 3 best answers describing operation and configuration of Frame-Relay Inverse ARP.（）A、Dynamic address mapping uses Frame Relay Inverse ARP to request the next-hop protocol address for a specific connection on its known DLCIB、Responses to Inverse ARP requests are entered in an address-to-DLCI mapping table on the router or access server which is used to supply the next-hop protoco address or the DLCI for outgoing trafficC、Inverse ARP is enabled by default for all protocols enabled on the physical interfaceD、Inverse ARP is configured using the following command under the Interface configuration ’frame-relaymap dlci （dlci number） protocol protocol-address’E、Inverse ARP in Frame-Relay is synonymous of ARP in Ethernet” 相关考题
考题
若要求“查询选修了3门以上课程的学生的学生号”，正确的SQL语句是A．SELECT S# FROM SC GROUP BY S# WHERE COUNT（*） 3B．SELECT S# FROM SC GROUP BY S# HAVING COUNT（*） 3C．SELECT S# FROM SC ORDER BY S# WHERE COUNT（*） 3D．SELECT S# FROM SC ORDER BY S# HAVING COUNT（*） 3
考题
查询订单数在3个以上、订单的平均金额200元以上的职员号。正确的SQL语句是A) SELECT职员号FROM订单GROUP BY职员号HAVING COUNT(*)3 AND AVG_金额200B) SELECT职员号FROM订单GROUP BY职员号日AVING COUNT(*)3 AND AVG_(金额）200C) SELECT职员号FROM订单GROUP BY职员号HAVING COUNT(*)3 WHERE AVG_(金额200D) SELECT职员号FROM订单GROUP BY职员号WHERE COUNT(*)3 AND_AVG金额200
考题
要从选课表(学号、课程号、成绩)中查询选修了3门以上课程的学生学号，应使用的SELECT-SQL语句是______。A．SELECT学号FROM选课表WHERECOUNT(*)＞=3B．SELECT学号FROM选课表HAVINGCOUNT(*)＞=3C．SELECT学号FROM选课表GROUPBY学号HAVINGCOUNT(*)＞＝3D．SELECT学号FROM选课表GROUPBY学号WHERECOUNT(*)＞＝3
考题
假设 “ 订单 ” 表中有订单号、职员号、客户号和金额字段，正确的 SQL 语句只能是A)SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)3 AND AVG_ 金额 200B)SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)3 AND AVG( 金额 )200C)SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)3 WHERE AVG( 金额 )200D)SELECT 职员号 FROM 订单 GROUP BY 职员号 WHERE COUNT(*)3 AND AVG_ 金额 200
考题
要从选课表(学号、课程号、成绩)中查询选修了三门课程以上的学生学号，应使用的SELECT-SQL语句是A．SELECT学号FROM选课表WHERE COUNT(*)＞=3B．SELECT学号FROM选课表HAVING COUNT(*)＞=3C．SELECT学号FROM选课表GROUP BY学号HAVING COUNT(*)＞=3D．SELECT学号FROM选课表GROUP BY学号WHERE COUNT(*)＞=3
考题
从学生选课表SC中(其中有学号、课程号、成绩3个字段)查询选修了3门以上课程的学生学号，实现该功能的SELECT语句是______。A．SELECT 学号 FROM SC GROUP BY学号 HAVING SUM(*)＞3B．SELECT 学号 FROM SC GROUP BY学号 HAVING COUNT(*)＞3C．SELECT 学号 FROM SC GROUP BY学号 HAVING 课程号＞3D．SELECT 学号 FROM SC WHERE 课程号 ＞3 GROUPBY学号
考题
若需在“参赛队”表中按降序排列查询前3名的队伍，下列语法正确的是______。A．SELECT队名，积分TOP 3 FROM参赛队； ORDER BY积分DESCB．SELECT队名，积分TOP 3 PERCENT FROM参赛队； ORDER BY积分DESCC．SELECT队名，积分TOP 3 FROM参赛队DESC；D．SELECT队名，积分TOP 3 PERCENT FROM参赛队DESC
考题
假设X的值是5，则执行以下语句时，可得到的输出结果是ABCDEF的Select Case语句是 ( )A．Select Case X Case 10 To 1 Print“ABCDEF” End SelectB．Select Case X Case Is＞15，Is＜5 Print"ABCDEF" End SelectC．Selecl Case K Case Is＞5，1，3，To 10 Print"ABCDEF" End SelectD．Select Case X Case 1，3，Is＞5 Print"ABCDEF" End Select
考题
在成绩表中要求按“总分”降序排列，并查询前3名学生的记录，正确的命令是A．SELECT * TOP 3 FROM成绩表； WHERE总分DESCB．SELECT * TOP 3 FROM成绩表； FOR总分DESCC．SELECT * TOP 3 FROM成绩表； GROUP BY总分DESCD．SELECT * TOP 3FROM成绩表； ORDER BY总分DESC
考题
查询订单数在3个以上、订单的平均金额200元以上的职员号。正确的SQL语句是A．SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)＞3 AND AVG 金额＞200B．SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)＞3 AND AVG (金额)＞200C．SELECT 职员号 FROM 订单 GROUP BY 职员号 HAVING COUNT(*)＞3 WHERE AVG (金额)＞200D．SELECT 职员号 FROM 订单 GROUP BY 职员号 WHERE COUNT(*)＞3 AND AVG金额＞200
考题
在学生选课表SC中，查询选修了3号课程的学生的学号(XH)及其成绩(CJ)。查询结果按分数的降序排列。实现该功能的正确SQL语句是( )。A．SELECT XH,CJ FROM SC WHERE CH='3'ORDER BY CJ DESCB．SELECT XH,CJ FROM SC WHERE CH='3'ORDER BY CJ ASCC．SELECT XH,CJ FROM SC WHERE CH='3'GROUP BY CJ DESCD．SELECT XH,CJ FROM SC WHERE CH='3'GROUP BY CJ ASC
考题
有如下语句：OPEN DATABASE学生管理 SELECT 1USE学生SELECT 2 USE课程 SELECT 3 USE成绩 如果要到第1个工作区去操作学生表，则命令是（ ）。A. SELECT OB. SELECT 1C. SELECT 2D. SELECT 3
考题
假设供应商S和供应情况SPJ的关系模式分别为：S(Sno, Sname, Status, City)和SPJ(Sno, Pno, Jno, Qty)。SQL语句______不能正确地查询出“零件号Pno等于'P3'的供应商名Sname”。A．SELECT DISTINCT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')B．SELECT DISTINCT Sname FROM S WHERERE 0＜ (SELECT COUNT (*) FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')C．SELECT Sname FROM S WHERE EXISTS (SELECT* FROM SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3')D．SELECT Sname FROM S, SPJ WHERE S.Sno=SPJ.Sno AND SPJ.Pno='P3') GROUP BY Sname
考题
查询表中重复数据,我想把3句连起来,怎么联啊
请问高手，我想查询即有重复字段1和重复字段2还有重复字段3，怎么连起来啊？Select*From表Where重复字段1In(Select重复字段1From表GroupBy重复字段1HavingCount(*)1)Select*From表Where重复字段2In(Select重复字段2From表GroupBy重复字段2HavingCount(*)1)Select*From表Where重复字段3In(Select重复字段3From表GroupBy重复字段3HavingCount(*)1)
考题
有如下命令序列： SELECT 1 USE FILEl LIST CLOSE DATABASE SELECT 0 USE FILE2 LIST SELECT 0 USE FILE3 LIST SELECT 0 USE FILE4 执行以上命令序列后，FILE4所在的工作区是______。A．第1区B．第2区C．第3区D．第4区
考题
有如下语句： OPEN DATABASE学生管理 SELECT 1 USE学生SELECT 2 USE课程 SELECT 3 USE成绩 如果要到第1个工作区去操作学生表，则命令是（ ）。A.SELECT OB.SELECT 1C.SELECT 2D.SELECT 3
考题
以下语句正确的是：______。A．Select Case a Case b=1 Case “B” b=2 Case Else b=3 End SelectB．Select Case a Case “A” b=1 Case “B” b=2 Case Default b=3 End SelectC．Switch a Case “A” b=1 Case “B” b=2 Case Else b=3 End SwitchD．Switch a Case “A” b=1 Case “B” b=2 Case Default b=3 End Select
考题
设有如下程序段，若要给f1文件追加新记录，但又不改变当前表的打开状态，应该使用命令序列______。 SELECT 1 USE f1 SELECT 2 USE f2 SELECT 3 USE f3A．USE f1 APPENDB．SELECT 1 APPENDC．GO f APPENDD．GO 1 APPEND
考题
要从学生表(学号、姓名、性别、出生年月、入校总分、三好生)中查询入校总分最高的3个学生的记录，应使用的SELECT SQL语句是 ______。A．SELECT*FROM学生表ORDER BY入校总分ASCB．SELECT FROM学生表ORDER BY入校总分DESCC．SELECT FROM学生表TOP 3 ORDER BY入校总分ASCD．SELECT FROM学生表TOP 3 ORDER BY入校总分DESC
考题
若需在zg表中按基本工资降序排列查询前三个的职工记录，下列语法正确的是 ( )。A．SELECT职工号，基本工资 TOP 3 FROM zg； ORDER BY 基本工资 DESCB．SELECT职工号，基本工资 TOP 3 PERCENT FROM zg； ORDER BY 基本工资 DESCC．SELECT职工号，基本工资 TOP 3 FROM zg DESC；D． SELECT职工号，基本工资 TOP 3 PERCENTFROM zg DESC
考题
评估以下SELECT语句：SELECT雇员标识，姓氏，名字，薪金‘年薪’ FROM雇员 WHERE薪金ISNOTNULL ORDERBY姓氏，3；以下哪个子句有错误？（）A、SELECT雇员标识，姓氏，名字，薪金’年薪’B、FROM雇员C、WHERE薪金IS NOT NULLD、ORDER BY姓氏，3；
考题
在SQL Server2008提供了系统函数，以下说法错误的是（）A、select convert（char（3），12345），返回值为：123B、select right（’abcde’，3），返回值为’e’C、select len（’abcde’）返回值为：8
考题
下面哪条语句可以取出薪水最高的前三个人：（）A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM=3；C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM=3；D、SELECT * FROM EMPLOYEES WHERE ROWNUM=3 ORDER BY SALARY DESC；
考题
给出下列各T-SQL语句的运行结果。 （1）SELECT CHARINDEX（’科学’，’计算机科学与技术专业’） （2）SELECT ROUND（26.213+124.1869，2） （3）SELECT STR（234.5678，6，2） （4）SELECT ’25+12=’+cast（37 as nvarchar）
考题
下列查询语句中，错误的是（）。A、SELECT Sno， COUNT（*） FROM SC GROUP BY SnoB、SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*） 3C、SELECT Sno FROM SC GROUP BY Sno HAVING COUNT（*） 3D、SELECT Sno FROM SC GROUP BY Sno
考题
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ3 NUMBER(3) SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? （）A、SELECT SUM(subj1, subj2, subj3) FROM marks;B、SELECT SUM(subj1 + subj2 + subj3) FROM marks;C、SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;D、SELECT MAX(subj1, subj2, subj3) FROM marks;E、SELECT MINIMUM(subj1) FROM marks;F、SELECT COUNT(std_id) FROM marks WHERE subj1 = AVG(subj1);
考题
Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?（）A、SELECT 1, "2" FROM 3 WHERE last_name = '4';B、SELECT 1, '2' FROM 3 WHERE 'last_name = '4'';C、SELECT 1, 2 FROM 3 WHERE last_name = '4';D、SELECT 1, '2' FROM EMP WHERE last_name = '4';
考题
单选题下面哪条语句可以取出薪水最高的前三个人：（）A
SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；B
SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM=3；C
SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM=3；D
SELECT * FROM EMPLOYEES WHERE ROWNUM=3 ORDER BY SALARY DESC；
热门标签
最新试卷
