期末试题-数据库技术与应用

《期末试题-数据库技术与应用》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、班级：学号：姓名：北京邮电大学2007——2008学年第一学期《数据库技术与应用》期末考试试题考试注意事项一、学生参加考试须带学生证或学院证明，未带者不准进入考场。学生必须按照监考教师指定座位就坐。二、书本、参考资料、书包等与考试无关的东西一律放到考场指定位置。三、学生不得另行携带、使用稿纸，要遵守《北京邮电大学考场规则》，有考场违纪或作弊行为者，按相应规定严肃处理。四、学生必须将答题内容做在专用答题纸上，做在试卷、草稿纸上一律无效。考试课程数据库技术与应用考试时间年月日题号一二三四五六七八总分满分2030103010得分阅卷教师Tr

2、ue-FalseQuestions（20）题号12345678910答案题号11121314151617181920答案12MultipleChoiceQuestions（30）题号12345678910答案题号11121314151617181920答案题号21222324252627282930答案FillintheBlankQuestions（10）题号答案12345678910EssayQuestions（30）112234125Giveyoursuggestionaboutthiscourse（10）12True-False

3、Questions（1point*20）1.Thepurposeofadatabaseistohelppeoplekeeptrackofthings.2.Therelationalmodelwasfirstproposedin1970byE.F.CoddatIBM.3.Arelationisathree-dimensionaltable.4.Anasterisk(*)followingtheSELECTverbmeansthatallcolumnsaretobeobtained.5.TheSQLkeywordGROUPBYinstru

4、ctstheDBMStogrouptogetherthoserowsthathavethesamevalueinacolumn.6.InanE-Rmodel,thethreetypesofmaximumcardinalityare1:1,1:NandN:M.7.Anullvalueisanattributevaluethathasbeensettozero.8.Adataconstraintisalimitationondatavalues.9.Inarelationaldatabasedesign,allrelationshipsa

5、reexpressedbycreatingaforeignkey.10.Atransactionisagroupofalternativedatabaseactionsfromwhichthedatabasecanchoosetoperformonlyoneofthem.11.Two-phasedlockinghasagrowingphaseandashrinkingphase.12."RepeatableReads"isolationisthemostrestrictivelevelofisolation.13.A"database

6、save"isusedtomarktheendofatransaction.14.ToaddaNULLcolumntoatable,wesimplyusetheMODIFYTABLEstatement.15.Deletingtablesandrelationshipsisbasicallyamatterofdroppingforeignkeyconstraintsandthendroppingthetables.16.TheSQLkeywordDELETEisusedtodeleteatable'sstructure.17.Joins

7、thatshowonlymatchingrowsfromthejoinedtablesintheirresultsarecalledinnerjoins.18.AnSQLvirtualtableiscalledaview.19.SQLtriggersareusedforprovidingdefaultvalues,validitychecking,updatingviews,andperformingreferentialintegrityactions.20.Storedprocedureshavetheadvantageofgre

8、atersecurity,decreasednetworktraffic,SQLoptimizedbytheDBMScompiler,andcodesharing.12MultipleChoiceQuestions（1p