题目4单选题
设有学生表student,包括name、sex、age三个字段,sex的默认值为"男",执行SQL语句INSERT INTO student(name,age) VALUES("Lily",25),下面说法正确的是A. 执行后,插入一条记录("Lily",NULL,25)B. 执行后,插入一条新记录,name、sex、age的值分别为"Lily","男",25C. 执行后,插入一条新记录,name、sex、age的值分别为"Lily",'',25D. 语句有误,不执行
题目5单选题
设有学生表student,包括name、sex、age三个字段,sex的默认值为"男",插入一条新记录("Matthew","男",20),以下不正确的是A. INSERT INTO student(name,age) VALUES("Matthew",20)B. INSERT INTO student VALUES("Matthew",DEFAULT,20)C. INSERT INTO student VALUES("Matthew",20)D. INSERT INTO student SET name="Matthew",age=20
题目9单选题
对于学生表student,执行命令REPLACE INTO student SET name="Amy",age=30A. 将表中所有记录均修改为("Amy","男",30)B. 若表中存在name为"Amy"的记录,则将该记录其他字段进行更新C. 插入一条新记录("Amy","男",30)D. 插入一条新记录("Amy",null,30)