有如下SQL语句 CREATE VIEW kh-view AS SELECT*FROM kh WHERE 职业=“教师”执行该语句产生的视图包含的记录个数是( )。
A.1
B.2
C.3
D.4
第1题:
有SQL语句:SELECT * FROM 教师 WHERE NOT(工资>3000 OR 工资<2000)与如下语句等价的SQL语句是A)SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资>2000 AND 工资<3000C)SELECT*FROM 教师 WHERE 工资>2000 OR 工资<3000D) SELECT*FROM 教师 WHERE 工资<=2000 AND 工资>3000
第2题:
有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")
第3题:
有SQL语句: SELECT*FROM教师WHERENOT(工资>30000R工资<2000)与如上语句等价的SQL语句是
A.SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000
B.SELECT*FROM 教师 WHERE 工资>2000 AND工资<3000
C.SELECT*FROM 教师 WHERE 工资>2000 OR工资<3000
D.SELECT*FROM 教师 WHERE 工资<=2000 AND工资>3000
第4题:
有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”)
第5题:
有SQL语句: SELECTDISTINCT系号FROM教师WHERE工资>=; ALL(SELECT工资FROM教师WHERE系号="02") 与如上语句等价的SQL语句是
A.SELECTDISTINCT系号FROM教师WHERE工资>=; (SELECTMAX(工资)FROM教师WHERE系号="02")
B.SELECTDISTINCT系号FROM教师WHERE工资>=; (SELECTMIN(工资)FROM教师WHERE系号="02")
C.ELECTDISTINCT系号FROM教师WHERE工资>=; ANY(SELECT工资FROM教师WHERE系号="02")
D.SELECTDISTINCT系号FROM教师WHERE工资>=; SOME(SELECT工资FROM教师WHERE系号="02")
第6题:
有SQL语句: SELECT DISTINCT 系号 FROM 教师 WHERE 工资>=; ALL(SELECT 工资 FROM 教师 WHERE 系号="02") 该语句的执行结果是系号A) "01"和"02" B)"01"和"03" C)"01"和"04" D)"02"和"03"
第7题:
有SQL语句 SELECT * FROM 教师 WHERE NOT(工资>30000R工资<2000) 与如上语句等价的SQL语句是
A.SELECT * FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000
B.SELECT * FROM 教师 WHERE 工资>2000 AND工资<3000
C.SELECT * FROM 教师 WHERE 工资>2000 OR工资<3000
D.SELECT * FROM 教师 WHERE 工资<=2000 AND工资>=3000
第8题:
有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")
第9题:
有SQL语句: SELECT * FROM 教师 WHERE NOT (工资>3000 OR 工资<2000) 与如上语句等价的SQL语句是
A.SELECT*FROM 教师 WHERE 工资BETWEEN 2000 AND 3000
B.SELECT*FROM 教师 WHERE 工资>2000 AND 工资<3000
C.SELECT*FROM 教师 WHERE 工资>2000 OR 工资<3000
D.SELECT*FROM 教师 WHERE 工资<=2000 AND 工资>3000
第10题:
有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")