已知如下关系:学生Student(S#,Sname),课程Course(C#,Cname,T#),选课SC(S#,C#,Score),教师T(T#,Tname)。其中S#为学号,Sname为学生命名,C#为课号,Cname为课程名,T#为教师编号,Score为成绩,Tname为教师名。阅读SQL语句:SELECTSnameFROMStudent,SC,CourseWHEREStudent.S#=SC.S#ANDCourse.C#=SC.C#ANDT#=‘T01’ANDScore
C
已知如下关系:学生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
Imagineyouenteracarwithnosteeringwheel,nobrakeoracceleratorpedals(踏板).Underavoice-activatedcommand,yousayanaddress“Thefastestroutewilltakeus15.3minutes.ShouldItakeit?”Yousay“yes”andyouareonyourway.Thecarrespondsandstartsmovingallbyitself.Allyouhavetodoissitbackandrelax.Howweirdwoulditbeif,onedayinthefuture,everyonehadsuchacar?Nocrazydiving,noinsults,nocuttingin;trafficlawswouldberespectedanddrivingmuchsafer.Ontheotherhand,imaginethecostsavingsforlocalpoliceenforcementandtownbudgetswithoutallthosespeedingandparkingtickets.Anewtechnologyhasthepotentialtochangemodernsocietyinradicalways.There’snoquestionthatself-drivingvehiclescouldbeanenormousbenefit.Thepotentialforsafercarsmeansaccidentstatisticswoulddrop:some94%ofroadaccidentsintheU.S.involvehumanerror.Olderdriversandvisually-orphysically-impairedpeoplewouldgainanewleveloffreedom.Maintainingsafespeedsandbeingelectric,self-drivingcarswoulddrasticallyreducepollutionlevelsanddependencyonnon-renewablefuels.Roadswouldbequieter,peoplesafer.Butwemustalsoconsidertheimpactofthenewtechnologyonthosewhonowdependondrivingfortheirlivelihoods.AccordingtotheU.S.DepartmentofLabor,inMay2015therewere505,560registeredschoolbusdrivers.TheAmericanTruckingAssociationlistsapproximately3.5millionprofessionaltruckdriversintheU.S.Thecompaniesdevelopingself-drivingvehiclesshouldbepartneringwithstateandfederalauthoritiestoofferretrainingforthismassiveworkforce,manyofwhomwillbedisplacedbythenewtechnology.Thisissimilartowhat’shappeninginthecoalandoilindustries,asituationthatfuelsmuchofthecurrentpoliticaldiscontentinthiscountry.Newtechnologieswill,andshould,bedeveloped.Thisishowsocietymovesforward.However,progresscan’tbeone-sided.Itisnecessaryforthecompaniesandstateagenciesinvolvedtoconsidertheethicalconsequencesofthesepotentialchangestobuildabetterfutureforall.Howwouldtheelderlyandthedisabledbenefitfromdriverlesscars?