从学生信息表（student）中提取姓名（name）列值为NULL的记录，下列选项正确的是（）C A SELECT name FROM student WHERE name = '' B SELECT name FROM student WHERE name = NULL C SELECT * FROM student WHERE name IS NULL D SELECT * FROM student WHERE name IS NOT NULL