C语言项目开发基础与实战-章节测验答案 徐嵩松 项目5理论知识测评答案.docx

项目5理论知识测评答案

一、单项选择题

1-5ADBBB 6-10DDCCC

二、程序设计题

1.

DELETEFROMStudentWHEREage19;

2.

INSERTINTOStudent(st_name,class,age)VALUES(孙九,开发2022,29);

3.

UPDATECourseSelectionSETCourse_id=1WHEREStudent_id=5;

4.

SELECTCourseSelection.ID,Student.st_name,Course.Title,Student.class,Course.CreditFROMStudentINNERJOIN(CourseINNERJOINCourseSelectionONCourse.iNum=CourseSelection.Course_id)ONStudent.iNum=CourseSelection.Student_id