设有学生表 student(sno ,sname,sage,smajor) ,要从 student 表中检索 sname字段值第 2 个字是 " 红" 的所有学生信息。以下能够按照上述条件进行检索的 WHERE表达式是 ______。
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
查看答案
正确答案: A 答案分析:无
包含此试题的试卷:
相关的试题
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
设有关系模式 SC( Sno, Sname, Sex, Birthday, Cno, Cname, Grade, Tno, Tname)满足函数 依赖集: {Sno→Sname, Sno→Sex, Sno→Birthday, Cno→Cname, (Sno, Cno)→Grade, Tno→ Tname}.SC 的主码和属性集( Sno, Tno)的闭包分别是
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"
A.sname LIKE "_ 红%"
B.sname LIKE "_ 红_"
C.sname LIKE "% 红%"
D.sname LIKE "% 红_"