预览加载中，请您耐心等待几秒...
在线预览结束，喜欢就下载吧，查找使用更方便
如果您无法下载资料，请参考说明：
1、部分资料下载需要金币，请确保您的账户上有足够的金币
2、已购买过的文档，再次下载不重复扣费
3、资料包下载后请先用软件解压，在使用对应软件打开
浙江财经学院期中考试试卷浙江财经学院期中考试试卷线《数据库原理及应用（英）》课程试卷考核方式：闭卷考试日期：2012年11月21日适用专业、班级：10电子商务题号一二三四五六七八九十总分得分评卷人（共7大题）：1.名ForeachofthefollowingquestionstherearefourchoicesmarkedA,B,Cand姓D.Onlyoneofthemiscorrect.Youshoulddecideonthecorrectchoiceandwritedownitsmarkontheanswersheet.（Points:20）(1)WhichofthefollowingoperationsisnotsupportedbyDDL?CA．creatingsomeviewsinadatabaseB．modifyingtablestructuresinadatabase封C．findingsomerowsfromatableD．creatingsometablesinadatabase(2)Inrelationalmodel,entityintegritymeansthatB.A．theremustnotbeemptyrowsineveryrelation：号B．noattributeofaprimarykeycanbenull学C．attributesareallowedtobenull．Dforeignkeysareallowedtobenull(3)WhichofthefollowingoperationsisnotsupportedbyDML?D．．AinsertingsomerowsintoatableBdeletingsomerowsfromatable．．CfindingsomerowsfromatableDcreatingsometablesinadatabase(4)IfFisaforeignkeyofrelationRthatreferencestheprimarykeyKofrelationS,thenFcanonlytakeB.A．nullvaluesB．nullvaluesorvaluesthatequaltooneofthevaluesofK：C．valuesthatappearinKD．valuesthatappearinR级班(5)Whichofthefollowingoperationscanretrievefromarelationallrecordsthatsatisfya、conditiontoformanewrelation?C业专A．ProjectionB．JoinC．SelectionD．Division(6)Arelationschema__C____.A．canhaveexactlyonecandidatekeyB．canhavemanyprimarykeysC．canhaveoneormanycandidatekeysD．canhaveoneormanyprimarykeys(7)InSQL,inordertoaddanewcolumnCNintobasetableS,weuseCstatement.密A．ADDTABLES(CNCHAR(8))B．ADDTABLESALTER(CNCHAR(8))C．ALTERTABLESADDCNCHAR(8)D．ALTERTABLES(ADDCNCHAR(8))，浙江财经学院期中考试试卷(8)Forarelation,eachcandidatekeyC.A．canonlyhaveatleasttwoattributesB．canonlyhaveatmostoneattributesC．mayhaveoneormoreattributesD．mustcontainalltheattributesoftherelation(9）SupposeRelationR1,R2andR3haveK1,K2andK3tuples,respectively,thenthenumberoftuplesinR1R2R3willbe__A____.．．．)．)÷AK1K2K3BK1+K2+K3C(K1+K2K3D(K1+K2K3(10）InSQL,viewsarecorrespondingtothe__A___schemaofadatabase.A．externalB．conceptualC．innerD．storage2.Giventhefol
