Where is the woman from?
A. Japan.
B. England.
C. Australia.
第1题:
以下删除记录正确的( )
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';
第2题:
检索那些城市至少有一个仓库的职工年龄在60以上的正确语句是( )。
A.SELECT城市FROM仓库WHERE仓库号 IN; SELECT仓库号FROM职工WHERE年龄>60
B.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仓库号)
第3题:
Where did the woman come from ? ( )
A.London
B.Amside
C.Lancaster
第4题:
“学生”表中学生号为主索引,若用SQL命令检索所有比“孙静”年龄大的同学,下列语句正确的是( )。
A. SELECT*FROM学生; WHERE 年龄>(SELECT 年龄 FROM学生; WHERE 姓名=“孙静”)
B.SELECT*FROM学生; WHERE 姓名=“孙静”
C. SELECT*FROM 学生: WHERE 年龄>(SELECT 年龄; WHERE 姓名=“孙静”)
D.SELECT*FROM 学生: WHERE 年龄>“孙静”
第5题:
对由SELECT—FROM—WHERE—GROUP—ORDER组成的SQL语句,其在被DBMS处理时,各子句的执序次序(43)。
A.SELECT—FROM—GROUP—WHERE—ORDER
B.FROM—SELECT—WHERE—GROUP—ORDER
C.FROM—WHERE—GROUP—SELECT—ORDER
D.SELECT—FROM—WHERE—GROUP—ORDER
第6题:
Where did the woman come from?
A. London.
B. Arnside.
C.Lancaster.
第7题:
—_____? —She's our history teacher.
A.Where is she from
B.Where does the woman work
C.Who is she
D.How is the woman
第8题:
Where did the woman come from?
A.London.
B.Arnside.?
C.Lancaster.
第9题:
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 ANG (SALARY));
第10题:
在学生表中查找没有选课的学生,下列语句正确的是( )。
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 学生号=学生号)