已知如下关系:学生Student(S#,Sname),课程Course(C#,Cname,T#),选课SC(S#,C#,Score),教师T(T#,Tname)。其中S#为学号,Sname为学生命名,C#为课号,Cname为课程名,T#为教师编号,Score为成绩,Tname为教师名。阅读SQL语句SELECTSnameFROMStudentWHERES#NOTIN(SELECTS#FROMSC,CourseWHERET#=‘03’andSC.C#=C.C#);关于其查询结果,下列说法正确的是()。
A
已知如下关系:学生Student(S#,Sname),课程Course(C#,Cname,T#),选课SC(S#,C#,Score),教师T(T#,Tname)。其中S#为学号,Sname为学生命名,C#为课号,Cname为课程名,T#为教师编号,Score为成绩,Tname为教师名。阅读SQL语句SelectS#FromSCSC1WhereSC1.C#=‘C01’ANDS#IN(SelectS#FromSCSC2WhereSC2.C#=‘C02’ANDSC1.S#=SC2.S#ANDSC1.Score>SC2.Score);关于其查询结果,下列说法正确的是()。
C
ProfessorAshokGoelofGeorgiaTechdevelopedanartificiallyintelligentteachingassistanttohelphandletheenormousnumberofstudentquestionsintheonlineclass,Knowledge-BasedArtificialIntelligence.ThisonlinecourseisacorerequirementofGeorgiaTech’sonlineMasterofScienceinComputerScienceprogram.ProfessorGoelalreadyhadeightteachingassistants,butthatwasn’tenoughtodealwiththeoverwhelmingnumberofdailyquestionsfromstudents.Manystudentsdropoutofonlinecoursesbecauseofthelackofteachingsupport.Whenstudentsfeelisolatedorconfusedandreachoutwithquestionsthatgounanswered,theirmotivationtocontinuebeginstofade.ProfessorGoeldecidedtodosomethingtoremedythissituationandhissolutionwastocreateavirtualassistantnamedJillWatson,whichisbasedontheIBMWatsonplatform.GoelandhisteamdevelopedseveralversionsofJillWatsonbeforereleasinghertotheonlineforums.Atfirst,thevirtualassistantwasn’ttoogreat.ButGoelandhisteamsourcedtheonlinediscussionforumtofindallthe40,000questionsthathadeverbeenaskedsincetheclasswaslaunched.ThentheybegantofeedJillwiththequestionsandanswers.Aftersomeadjustmentsandsufficienttime,Jillwasabletoanswerthestudents’questionscorrectly97%ofthetime.Thevirtualassistantbecamesoadvancedandrealisticthatthestudentsdidn’tknowshewasacomputer.Thestudents,whowerestudyingartificialintelligence,wereinteractingwiththevirtualassistantandcouldn’ttellitapartfromarealhumanbeing.Goeldidn’tinformthemaboutJill’strueidentityuntilApril26.Thestudentswereactuallyverypositiveabouttheexperience.ThegoalofProfessorGoel’svirtualassistantnextyearistotakeoveranswering40%ofallthequestionsposedbystudentsontheonlineforum.ThenameJillWatsonwill,ofcourse,changetosomethingelsenextsemester.ProfessorGoelhasamuchrosieroutlookonthefutureofartificialintelligencethan,say,ElonMusk,StephenHawking,BillGatesorSteveWozniak.WhatdowelearnaboutJillWatson?