中学特岗教师招聘
The number of Congressmen from each state varies depending on （）A、the size of the areaB、the size of the populationC、the traditionD、the wealth
题目
The number of Congressmen from each state varies depending on （）
- A、the size of the area
- B、the size of the population
- C、the tradition
- D、the wealth
相似问题和答案
第1题：
A. the number of consecutive TCP connections to the specified remote neig hbor
B. the number of total TCP connections that the router has
C. the number of times the router has established a TCP connection
D. the number of neighbors that the router has
第2题：
The House Speaker and the temporary President of the Senate are usually（）
Aelected by the majority party
Bchosen from the majority and minority parties
Cmembers of the majority party
Dchosen freely from the Congressmen and Senators
C
略
第3题：
A. on the rise
B. in the rise
C. at the rise
D. from the rise
第4题：
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);
正确答案:B,C
第5题：
数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键为Number。要求查询所有男同学信息，下列哪个SQL语句是正确的？（）
- A、Select* From Student Where Sex=’男’
- B、Select* From Student Where Number NotIn（Select Number From Student Where Sex<>=’男’）
- C、Select* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’）
- D、Select* From Student Where Sex<>’男’
正确答案:A,B
第6题：
The report from the US Department of Education shows that ______.
A. the number of the expulsions is not large
B. the number of the expulsion is wrong
C. there are soldiers hiding among the students
D. guns are out of control in US schools
47．答案为D。根据第一、二段内容作出该项选择。
第7题：
“球员”表包含以下列： 球员标识NUMBER（9） 姓氏VARCHAR2（20） 名字VARCHAR2（20） 球队标识NUMBER（4） 经理标识NUMBER（9） 位置标识NUMBER（4） 如果要显示“球队标识”列和“经理标识”列的唯一组合，应使用哪条SELECT语句？（）
- A、SELECT*FROM球员；
- B、SELECT球队标识，经理标识FROM球员；
- C、SELECTDISTINCT球队标识，经理标识FROM球员；（*）
- D、SELECT球队标识，DISTINCT经理标识FROM球员；
- E、SELECT球队标识，经理标识DISTINCTFROM球员；
正确答案:C
第8题：
Examine the structure of the EMP_DEPT_VU view:Column Name Type RemarksEMPLOYEE_ID NUMBER From the EMPLOYEES tableEMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES tableSALARY NUMBER From the EMPLOYEES tableDEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）
A. SELECT * FROM emp_dept_vu;
B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
D. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
E. None of the statements produce an error; all are valid.
第9题：
指出下面sql语句错误之处（） select id_number “Part Number”， sum（price） “price” from inventory where price >50 group by “Part Number” order by 2；
- A、order by 2
- B、from inventory
- C、where price＞50
- D、group by “Part Number”
正确答案:D
第10题：
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）
- A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';
- B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
- C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
- D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
- E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
正确答案:D