网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
结构化查询语言SQL是一种(1)，其主要功能有(2)，它的典型句法为
SELECT A1，A2，…，An
FROM r1，r2，…，rm
WHERE F
其中，A1，A2，…，An和F分别是(3)。
关系模式SCS(Sno，Cno，Score)中，Sno是学生的学号，Cno是课程号，Score为成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列，平均成绩相同时按课程号降序排列，可用SQL语言写为(4)。若查询结果仅限于平均分数超过85分的，则应(5)。
A．人工智能
B．关系数据库
C．函数型
D．高级算法
参考答案
更多 “ 结构化查询语言SQL是一种(1)，其主要功能有(2)，它的典型句法为SELECT A1，A2，…，AnFROM r1，r2，…，rmWHERE F其中，A1，A2，…，An和F分别是(3)。关系模式SCS(Sno，Cno，Score)中，Sno是学生的学号，Cno是课程号，Score为成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列，平均成绩相同时按课程号降序排列，可用SQL语言写为(4)。若查询结果仅限于平均分数超过85分的，则应(5)。A．人工智能B．关系数据库C．函数型D．高级算法 ” 相关考题
考题
若有C语言语句“char r1[]="abcd"，r2[]={'a','b','c','d'}”，则下列说法正确的是______。A．数组r1和数组r2存放相同的字符串B．数组r1和数组r2的长度相同C．数组r1的长度小于数组r2的长度D．数组r1的长度大于数组r2的长度
考题
SQL语言是一种(96)语言，其主要功能有(97)，它的典型句型为；SELECT A1，A2，．．．AnFROM R1，R2，．．．RmWHERE F其中Ai(i＝1，2，…，n)、Rj(j＝1，2，…，m)和F分别是(98)。关系模式学生成绩表(S#，C#，Score)中S#是学生的学号，C#是课程号，Score是学号为S#学生的C#号课程的成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列，平均成绩相同时，按课程号降序排列，可用SQL，语言写为(99)。若查询的结果仅限于平均分数超过85分的，则应(100)。A．函数型B．关系数据库C．人工智能D．高级算法
考题
在SQL Server 2008的某数据库中，设用户U1同时是角色R1和角色R2中的成员。现已授予角色R1对表T具有SELECT、INSERT和UPDATE权限，授予角色R2对表T具有INSERT和DENY UPDATE权限，没有对U1进行其他授权，则U1对表T有权执行的操作是（ ）。A.SELECT和INSERTB.INSERT、UPDATE和SELECTC.SELECT和UPDATED.SELECT
考题
结构化查询语言SQL是一种(20)语言，其主要功能有(21)，它的典型句型为：SELECT A1，A2，…，AnFROM r1，r2，…，rmWHERE F其中A1，A2，…，An，r1，r2，…，rm和F分别是(22)。关系模式WTS(Wno，Tno，Sno)中，Wno，Wno Wno分别代表工人编号，工种编码以及月工资。若要查询工种编码以“A”开头的全体工人的平均月工资，可用SQL语言写为：SELECT(23)FBOM WTSWHERE(24)A．人工智能B．关系数据库C．函数型D．高级算法
考题
在关系代数中，最常用的式子是“投影选择联接表达式” (41) ，此处凡“R1×R2×…×R2为基本表，F是公式，A1，A2，…，An为属性，针对这个表达式，SQL设计了SELECT句型：SELECT A1，A2，…．AnFROM R1，R2，…RnWHERE FA．B．C．D．
考题
Routers R1 and R2 are EIGRP neighbors. R1 has been configured with the eigrp stub connected command.Which of the following is true as a result?()
A.R1 can learn EIGRP routes from R2, but R2 cannot learn EIGRP routes from R1B.R1 can send IP packets to R2, but R2 cannot send IP packets to R1C.R2 no longer learns EIGRP routes from R1 for routes not connected to R1D.R1 no longer replies to R2‘s Query messagesE.R2n o longer sends to R1 Query messages
考题
有阻值分别为R1和R2的两个负载，其中R1的电阻值是R2的N倍，把它们并联后接到电源上，则：（”x＾m”表示“x的m次方”）（）A、流过R1的电流是R2的N倍，R1消耗的功率是R2的N＾2倍B、流过R1的电流是R2的1/N，R1消耗的功率是R2的1/NC、流过R1的电流与R2的相同，R1消耗的功率是R2的1/N＾2D、流过R1的电流与R2的相同，R1消耗的功率是R2的N倍
考题
有阻值分别为R1和R2的两个负载，其中R1的电阻值是R2的N倍，把它们并联后接到电源上，则：（”x＾m”表示“x的m次方”）（）A、R1两端的电压与R2的相同，R1消耗的功率是R2的1/NB、R1两端的电压与R2的相同，R1消耗的功率是R2的N＾2倍C、R1两端的电压是R2的1/N，R1消耗的功率是R2的1/N＾2D、R1两端的电压是R2的N倍，R1消耗的功率是R2的N＾2倍
考题
Routers R1 and R2 are EIGRP neighbors. R1 has been configured with the eigrp stub connected command. Which of the following is true as a result？（）A、R1 can learn EIGRP routes from R2, but R2 cannot learn EIGRP routes from R1B、R1 can send IP packets to R2, but R2 cannot send IP packets to R1C、R2 no longer learns EIGRP routes from R1 for routes not connected to R1D、R1 no longer replies to R2's Query messagesE、R2n o longer sends to R1 Query messages
考题
Two directly connected routers， R1 and R2， are both configured for OSPF graceful restart. R2 is able to switch packets in hardware， but R1 is not. If a network administrator logs on to R2 and performs a system reload， which will be the result？（）A、Traffic forwarded from R2 to or through R1 will continue to be forwarded based on the forwarding table state at the time of the reload.B、R2 will continue to forward traffic to R1， but R1 will drop the traffic because its neighbor adjacency with R2 has failed.C、R2 will continue forwarding traffic to and through R1， but R1 will drop this traffic because it is not capable of maintaining its forwarding state.D、All the traffic R2 is forwarding to or through R1 will be dropped while OSPF rebuilds its neighbor adjacency and forwarding tables.
考题
Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）A、SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2B、SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2C、SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2D、SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
考题
单选题Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）A
SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2B
SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2C
SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2D
SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
考题
单选题Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）A
SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2B
SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2C
SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2D
SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
考题
单选题Two directly connected routers， R1 and R2， are both configured for OSPF graceful restart. R2 is able to switch packets in hardware， but R1 is not. If a network administrator logs on to R2 and performs a system reload， which will be the result？（）A
Traffic forwarded from R2 to or through R1 will continue to be forwarded based on the forwarding table state at the time of the reload.B
R2 will continue to forward traffic to R1， but R1 will drop the traffic because its neighbor adjacency with R2 has failed.C
R2 will continue forwarding traffic to and through R1， but R1 will drop this traffic because it is not capable of maintaining its forwarding state.D
All the traffic R2 is forwarding to or through R1 will be dropped while OSPF rebuilds its neighbor adjacency and forwarding tables.
考题
多选题对卵形曲线的要求，正确的有下列哪些选项？（ ）A卵形曲线的回旋线参数宜选R2/2≤A≤R2（R2为小圆曲线半径）B两圆曲线半径之比，以R2/R1＝0.2～0.8为宜C两端回旋线参数A1与A2之比不应大于2.5D两端回旋线参数A1与A2之比宜小于1.2
考题
多选题Routers R1 and R2 are EIGRP neighbors. R1 has been configured with the eigrp stub connected command. Which of the following is true as a result？（）AR1 can learn EIGRP routes from R2, but R2 cannot learn EIGRP routes from R1BR1 can send IP packets to R2, but R2 cannot send IP packets to R1CR2 no longer learns EIGRP routes from R1 for routes not connected to R1DR1 no longer replies to R2's Query messagesER2n o longer sends to R1 Query messages
考题
多选题在S形曲线中，设R1、R2分别为大小圆半径，A1、A2分别为大小圆的缓和曲线参数，关于S形曲线规定的说法，正确的有下列哪些选项？（ ）AS形曲线的两回旋线参数A1与A2宜相等BA1与A2之比应小于2.0，有条件时以小于1.5为宜C当A2≤200时，A1与A2之比应小于1.5D两圆曲线半径之比不宜过大，以R1/R2≤3为宜
考题
单选题S形曲线的两回旋线参数A1与A2宜相等。两圆曲线半径之比不宜过大，如果R1为大圆曲线半径，R2为小圆曲线半径，则R1/R2宜为以下哪个选项？（ ）A
1.5B
2.0C
2.5D
3.0
热门标签
最新试卷
