单选题Where is the article most likely taken from?Afrom an advertismentBfrom a medical magazineCfrom a newspaperDfrom a biography
单选题
Where is the article most likely taken from?
A
from an advertisment
B
from a medical magazine
C
from a newspaper
D
from a biography
参考解析
解析：
全文都是在介绍人体所需的营养物质，因此最有可能摘自医学杂志（a medical magazine），应选B项。
全文都是在介绍人体所需的营养物质，因此最有可能摘自医学杂志（a medical magazine），应选B项。
相关考题：
SQL语句：SELECT*FROM班级WHERE班级号NOT IN;(SELECT班级号FROM学生)该语句等价于：SELECT*FROM班级WHERE NOT______;(SELECT*FROM学生WHERE班级号=班级.班级号)
以下删除记录正确的( )A.delete from emp where name='dony';B.Delete * from emp where name='dony';C.Drop from emp where name='dony';D.Drop * from emp where name='dony';
检索那些城市至少有一个仓库的职工年龄在60以上的正确语句是( )。A．SELECT城市FROM仓库WHERE仓库号 IN； SELECT仓库号FROM职工WHERE年龄＞60B．SELECT城市FROM仓库WHERE仓库号 IN； (SELECT仓库号FROM职工WHERE年龄＞60)C．SELECT仓库号FROM职工WHERE年龄＞60 IN； SELECT城市FROM仓库WHERE仓库号D．SEIECT仓库号FROM职工WHERE年龄＞60IN； (SELECT城市FROM仓库WHERE仓库号)
对由SELECT—FROM—WHERE—GROUP—ORDER组成的SQL语句，其在被DBMS处理时，各子句的执序次序(43)。A．SELECT—FROM—GROUP—WHERE—ORDERB．FROM—SELECT—WHERE—GROUP—ORDERC．FROM—WHERE—GROUP—SELECT—ORDERD．SELECT—FROM—WHERE—GROUP—ORDER
在学生表中查找没有选课的学生，下列语句正确的是( )。A．SELECT*FROM 学生 WHERE EXISTS； (SELECT*FROM 选课 WHERE学生号=学生.学生号)B．SELECT*FROM 学生 WHERE NOT EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生.学生号)C．SELECT*FROM 学生 WHERE EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生号)D． SELECT*FROM 学生 WHERE NOT EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生号)
假设所有学生都已选课，所有的选课成绩都已确定。检索所有选课成绩都在90分以上(含)的学生信息，正确的SQL命令是( )。A．SELECT*FROM学生WHERE学号IN(SELECT学号FROM选课WHERE成绩=90)B．SELECT*FROM学生WHERE学号NOT IN(SELECT学号FROM选课 WHERE成绩90)C．SELECT*FROM学生WHERE学号!=ANY(SELECT学号FROM选课 WHERE成绩90)D．SELECT*FROM学生WHERE学号=ANY(SELECT学号FROM选课 WHERE成绩=90)
有如下SQL语句： SELECT姓名FROM学生表WHERE学号IN； (SELECT学号FROM成绩表WHERE成绩＞90) 下列哪条命令与该SQL语句等价A．SELECT姓名FROM学生表WHERE EXISTS； (SELECT学号FROM成绩表WHERE成绩＞90)B．SELECT姓名FROM学生表WHERE EXISTS； (SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90)C．SELECT姓名FROM学生表WHERE学号EXISTS； (SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90)D． SELECT姓名FROM学生表WHERE学号=； (SELECT学号FROM成绩表WHERE成绩＞90)
有SQL语句： SELECT DISTINCT 系号 FROM 教师 WHERE 工资＞=； ALL(SELECT 工资 FROM 教师 WHERE 系号 =“02”) 与如上语句等价的SQL语句是A．SELECT DISTINCT 系号 PROM 教师 WHERE 工资＞=； (SELECT MAX(工资)FROM 教师 WHERE 系号=“02”)B．SELECT DISTINCT 系号 FROM 教师 WHERE 工资=； (SELECT MIN(工资)FROM 教师 WHERE 系号=“02”)C．SELECT DISTINCT 系号 FROM 教师 WHERE 工资＞=； ANY(SELECT 工资 FROM 教师 WHERE 系号=“02”)D．SELECT DISTINCT 系号 FROM 教师 WHERE 工资＞=； SOME(SELECT 工资 FROM 教师 WHERE 系号=“02”)
有SQL语句：SELECT DISTINCT系号FROM教师WHERE 工资=ALL （SELECT 工资FROM教师WHERE系号=\02\） 与如上语句等价的SQL语句是A．SELECT DISTINCT系号FROM教师WHERE工资=（SELECT MAX（工资）FROM教师WHERE 系号="02"）B．SELECT DISTINCT系号FROM教师WHERE工资=（SELECT MIN（工资）FROM教师WHERE 系号="02"）C．SELECT DISTINCT系号FROM教师WHERE工资=（ANY（SELECT（工资）FROM教师WHERE 系号="02"）D．SELECT DISTINCT系号FROM教师WHERE工资=（SOME （SELECT（工资）FROM教师WHERE 系号="02"）
SQL语句：SELECT木FROM班级WHERE班级号NOT IN；(SELECT班级号FROM学生)该语句等价于：SELECT﹡FROM班级WHERE NOT__________；(SELECT木FROM学生WHERE班级号=班级．班级号)
对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句，其在被DBMS处理时，各子句的执行次序为()A.SELECT—FROM—GROUP—WHERE—ORDERB.FROM——SELECT--WHERE——GROUP——ORDERC.FROM——WHERE——GROUP——SELECT——ORDERD.SELECT——FROM——WHERE——GROUP——ORDER
Where did the noise come from? __________A.From the small houseB.From Mrs．JanesC.From the tyresD.From the engine
对由SELECT--FROM—WHERE—GROUP--ORDER组成的SQL语句，其在被DBMS处理时，各子句的执行次序为（）A、SELECT—FROM—GROUP—WHERE—ORDERB、FROM--WHERE——GROUP——ORDER——SELECTC、FROM——WHERE——GROUP——SELECT——ORDERD、SELECT——FROM——WHERE——GROUP——ORDER
下面哪条语句可以取出薪水最高的前三个人：（）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；
有如下SQL语句：下列哪条命令与该SQL语句等价（） SELECT姓名FROM学生表WHERE学号IN； （SELECT学号FROM成绩表WHERE成绩＞90）A、SELECT姓名FROM学生表WHEREEXISTS；（SELECT学号FROM成绩表WHERE成绩＞90）B、SELECT姓名FROM学生表WHEREEXISTS；（SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90）C、SELECT姓名FROM学生表WHERE学号EXISTS；（SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90）D、SELECT姓名FROM学生表WHERE学号=；（SELECT学号FROM成绩表WHERE成绩＞90）
Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）A、SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C、SELECT distinct department_id FROM employees WHERE salary ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D、SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E、SELECT last_name FROM employees WHERE salary ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F、SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
单选题有如下SQL语句：下列哪条命令与该SQL语句等价（） SELECT姓名FROM学生表WHERE学号IN； （SELECT学号FROM成绩表WHERE成绩＞90）ASELECT姓名FROM学生表WHEREEXISTS；（SELECT学号FROM成绩表WHERE成绩＞90）BSELECT姓名FROM学生表WHEREEXISTS；（SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90）CSELECT姓名FROM学生表WHERE学号EXISTS；（SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90）DSELECT姓名FROM学生表WHERE学号=；（SELECT学号FROM成绩表WHERE成绩＞90）
单选题下列SELECT语句语法正确的是（）。ASELECT*FROM教师表WHERE性别=男BSELECT*FROM教师表WHERE性别=男CSELECT*FROM教师表WHERE性别=男DSELECT*FROM教师表WHERE性别=男
单选题根据客户表和订单表查询2011年没有签订任何订单的客户信息，错误的SQL语句是（ ）。ASELECT*FROM客户WHERE客户号NOT INSELECT客户号FROM订单WHERE YEAR(签订日期)=2011)BSELECT*FROM客户WHERE NOT EXISTSELECT*FROM订单WHERE客户号=客户.客户号AND YEAR(签订日期)=2011)CSELECT*FROM客户WHERE客户号！=ANYSELECT客户号FROM订单WHERE YEAR(签订日期)=2011)DSELECT*FROM客户WHERE客户号！=ALLSELECT客户号FROM订单WHERE YEAR(签订日期)=2011)
多选题Examine the data in the EMPLOYEES table: Which three subqueries work? （）ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
单选题Where is the article most likely taken from?Afrom an advertismentBfrom a medical magazineCfrom a newspaperDfrom a biography
单选题查询出EMP表中COMM字段为空的记录（）Aselect * from emp where comm='';Bselect * from emp where comm=null;Cselect * from emp where nvl(comm)=0;Dselect * from emp where comm is null;Eselect * from emp where nvl(comm,0)=0;
单选题Which types of prefixes will a router running BGP most likely advertise to an IBGP peer， assuming it is notconfigured as a route reflector？（）Aprefixes received from any other BGP peer and prefixes locally originated via network statements or redistributedBall prefixes in its routing tableCprefixes received from EBGP peers and prefixes locally originated via network statements or redistributedDprefixes received from EBGP peers and prefixes received from route reflectorsEprefixes received from other IBGP peers， prefixes received from EBGP peers，and prefixes redistributedto BGPFprefixes received from other IBGP peers and prefixes received from route reflectors
单选题查询出所有名字以’S’开始的员工（）Aselect * from emp where ename in 'S%';Bselect * from emp where ename='S%';Cselect * from emp where ename like 'S%';Dselect * from emp where ename like 'S_';
单选题与“SELECT DISTINCT产品号FROM产品WHERE单价=ALL（SELECT单价FROM产品WHERE SUBSTR（产品号1，1）=2）”等价的SQL命令是（ ）。ASELECT DISTINCT产品号FROM产品WHERE单价=（SELECT MAX（单价）FROM产品WHERE SUBSTR（产品号1，1）=2）BSELECT DISTINCT产品号FROM产品WHERE单价=（SELECT MIN（单价）FROM产品WHERE SUBSTR（产品号1，1）=2）CSELECT DISTINCT产品号FROM产品WHERE单价=ANY（SELECT单价FROM产品WHERE SUBSTR（产品号1，1）=2）DSELECT DISTINCT产品号FROM产品WHERE单价=SOME（SELECT单价FROM产品WHERE SUBSTR（产品号1，1）=2）
单选题与“SELECT DISTINCT歌手号FROM歌手WHERE最后得分＞＝ALL（SELECT最后得分FROM歌手WHERE SUBSTR（歌手号1，1）＝″2″）”等价的SQL语句是（ ）。ASELECT DISTINCT歌手号FROM歌手WHERE最后得分＞＝（SELECT MAX（最后得分）FROM歌手WHERE SUBSTR（歌手号1，1）＝″2″）BSELECT DISTINCT歌手号FROM歌手WHERE最后得分＞＝（SELECT MIN（最后得分）FROM歌手WHERE SUBSTR（歌手号1，1）＝″2″）CSELECT DISTINCT歌手号FROM歌手WHERE最后得分＞＝ANY（SELECT最后得分FROM歌手WHERE SUBSTR（歌手号1，1）＝″2″）DSELECT DISTINCT歌手号FROM歌手WHERE最后得分＞＝SOME（SELECT最后得分FROM歌手WHERE SUBSTR（歌手号,1，1）＝″2″）
单选题This passage is probably taken from ______.Aa story bookBa posterCa science fictionDa medical magazine
单选题下面哪条语句可以取出薪水最高的前三个人：（）ASELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；BSELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM=3；CSELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM=3；DSELECT * FROM EMPLOYEES WHERE ROWNUM=3 ORDER BY SALARY DESC；