In UCSM, where are Call Home conditions for monitoring configured?()
第1题:
A.that; that
B.where; that
C.where; where
D.that;where
第2题:
查找条件为:姓名不是NULL的记录( )
A.WHERE NAME ! NULL
B.WHERE NAME NOT NULL
C.WHERE NAME IS NOT NULL
D.WHERE NAME!=NULL
第3题:
A.where was the supermarket
B.where to the supermarket
C.where the supermarket was
D.where to get to the supermarket
第4题:
有如下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)
第5题:
A. Immediately after the SELECT clause
B. Before the WHERE clause
C. Before the FROM clause
D. After the ORDER BY clause
E. After the WHERE clause
第6题:
有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")
第7题:
Would you tell me ________?
A、where is the post office
B、where stands the post office
C、where the post office is
D、where stood the post office
第8题:
A.from which; that
B.from where; what
C.where; all
D.where; that
第9题:
在学生表中查找没有选课的学生,下列语句正确的是( )。
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 学生号=学生号)
第10题:
与WHERE AGE BETWEEN 18 AND 23完全等价的是( )。
A.WHERE AGE>18AND AGE
B.WHERE AGE>=18AND AGE
C.WHERE AGE>18AND AGE
D.WHERE AGE>=18AND AGE