若想查询出所有姓张的、且出生日期为空的学生信息，则WHERE条件应为（）

A.姓名 LIKE '张%' AND 出生日期 = NULL

B.姓名 LIKE '张_' AND 出生日期 IS NULL

C.姓名 LIKE '张*' AND 出生日期 = NULL

D.姓名 LIKE '张%' AND 出生日期 IS NULL

A.StName LIKE ’张%’ AND Birthdate = NULL

B.StName LIKE ’张*’ AND Birthdate = NULL

C.StName LIKE ’张%’ AND Birthdate IS NULL

D.StName LIKE ’张_’ AND Birthdate IS NULL

A.StName LIKE '张%'

B.StName LIKE '张*'

C.StName LIKE '张？'

D.StName LIKE '张_'

A.select 姓名,year(getdate())-year(出生日期) from 职工表 where 姓名=‘张%’

B.select 姓名,year(getdate())-year(出生日期) from 职工表 where 姓名 like‘张%’

C.select 姓名,year(出生日期) from 职工表 where 姓名 like‘张%’

D.select 姓名,year(出生日期) from 职工表 where 姓名='张%’

A.select * from student where name like ‘张%’;

B.select * from student where name like ‘张_’;

C.select * from student where name like ‘张*’;

D.select * from student where name like ‘%张%’;

A.sname LIKE “**”  

B.sname LIKE ”##” 

C.sname LIKE “？？”  

D.sname =“？？”