公安边防消防警卫部队院校统考
单选题Who can apply for a premium ticket from SAL according to the passage?A A passenger who has traveled several times by plane.B A passenger who wants to travel on any airlines flights.C A passenger who has traveled on Shanghai Airlines flights.D A passeng
题目
A passenger who has traveled several times by plane.
A passenger who wants to travel on any airlines flights.
A passenger who has traveled on Shanghai Airlines flights.
A passenger who has accumulated enough air miles on SAL flights.
相似问题和答案
第1题：
According to the passage, which of the following is NOT true?
A. One can know his friends better from their color preference.
B. Workers can work better in a room with bright colors.
C. The person who prefers dark colors can not be successful.
D. We can change our mood by changing our clothes.
39．答案为C 从第一段可知颜色的喜好与性格相关，是天生的，A、B、D选项都是文中提到的，因此选C。
第2题：
According to the townsfolk, the RSC deserves no subsidy because ________.
[A] ticket prices can be raised to cover the spending
[B] the company is financially ill-managed
[C] the behavior. of the actors is not socially acceptable
[D] the theatre attendance is on the rise
第3题：
求每个终点的平均票价的SQL语句是A）SELECT终点，avg（票价）FROM ticket GROUP BY票价B）SELECT终点，avg（票价）FROM ticket ORDER BY票价C）SELECT终点，avg（票价）FROM ticket ORDER BY终点D）SELECT终点，avg（票价）FROM ticket GROUP BY终点
根据题目的要求，求每个终点的平均票价，则按不同的终点分组查询，用AVGQ函数计算每组的平均票价值，故正确的SQL语句应该是：
SELECT 终点 ，avg（票价）FROM ticket GROUP BY 终点
故选项D为正确答案。
第4题：
Then people,()are interested, can apply for the job.
A. those
B. they
C. who
答案：C
解析：本句意思：然后有兴趣的人就可以申请这份工作。本句考查定语从句，who引导的非限制性定语从句，对people进行附加说明，而those，they都没有这种引导作用，因此选C。
第5题：
以下说法错误的是( )
A.SELECT max(sal),deptno,job FROM EMP group by sal;
B.SELECT max(sal),deptno,job FROM EMP group by deptno;
C.SELECT max(sal),deptno,job FROM EMP;
D.SELECT max(sal),deptno,job FROM EMP group by job;
第6题：
求每个终点的平均票价的SQL语句是
A．SELECT终点，avg(票价)FROM ticket GROUP BY票价
B．SELECT终点，avg(票价)FROM ticket ORDER BY票价
C．SELECT终点，avg(票价)FROM ticket ORDER BY终点
D．SELECT终点，avg(票价)FROM ticket GROUP BY终点
解析：根据题目的要求，求每个终点的平均票价，则按不同的终点分组查询，用AVG()函数计算每组的平均票价值，故正确的SQL语句应该是： SELECT终点，avg(票价)FROM ticket GROUP BY终点
第7题：
以下语句错误的是( )
A.select sal+1 from emp;
B.select sal*10,sal*deptno from emp;
C.不能使用运算符号
D.select sal*10,deptno*10 from emp;
第8题：
在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是A）SELECT *FROM ticket WHERE票价＜100B）SELECT车次、始发站、终点FROM ticket WHERE票价>100C）SELECT车次、始发站、终点FROM ticket WHERE票价<100D）SELECT*FROM ticket WHERE票价＞100
本题考查条件查询语句的书写。SQL的语法格式是：
SELECT<目标字段达式> FROM表名＞
所以在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是SELECT车次、始发站、终点FROM ticket WHERE票价<100,故选项C为正确答案。
第9题：
A、they
B、those
C、who
第10题：
It is a simple idea: an individual pays a small amount of money called a premium (保险费) to an agent who acts on behalf of an insurance company, or underwriter, which holds the individual′s premium and the premiums paid by thousands of others. The individual receives an insurance policy, a promise that if there is a loss to the individual as defined in the policy the insurance company will pay for it. The funds will come from the individual′s premium, the premium paid by others who did not have losses, and money from the company′ s investment of all the premiums. An individual who does not have a loss loses the premium money but purchases what insurance underwriters call "peace of mind". It is a gamble for the customer and the underwriter, but it is built on the first rule of risk that losses are small when shared by many.
According to the passage, insurance company will protect individuals from the losses EXCEPT
B.fires
C.accidents
D.getting old