吉大18春学期《数据库应用技术》在线作业二-0003试卷总分:100得分:0一、单选题(共25道试题,共100分)1.Whichofthefollowingisabenefitofuser-definedfunctions?A.ImprovesapplicationconcurrencyB.ImprovesblockingofresultsetsC.SimplifiesapplicationmaintenanceD.Reducesmemoryrequirementsontheserver正确答案:C2.当FROM子句中出现多个基本表或视图时，系统将执行什么操作？A.并B.等值联接C.自然联接D.笛卡儿积正确答案:D3.在SELECT语句的下列子句中，通常和HAVING子句同时使用的是以下哪项？A.ORDERBY子句B.WHERE子句C.GROUPBY子句D.均不需要正确答案:C4.数据库系统的并发控制的主要方法是采用（）制。A.拒绝B.改为串行C.锁D.不加任何控制正确答案:C5.要对应用程序预编译并生成绑定文件，需要什么特权？A.数据库上的CONNECT特权B.数据库上的BINDADD特权C.程序包上的BIND特权D.程序包上的CONTROL特权正确答案:A6.下面哪个工具可以帮助用户对语句性能进行分析？A.可视化解释工具B.性能监视器C.命令行处理器D.控制中心正确答案:A7.Thefollowingcommandsareissuedagainstadatasourcecontainingtableuser2.org:CREATEALIASuser1.orgFORsample.orgCREATETABLEorg.sample(cCHAR(1))CREATEALIASsample.orgFORuser2.orgCREATEALIASuser2.sampleFORsample.orgGiventheuserSAMPLEissuesthefollowingstatement:SELECT*FROMsampleForwhichofthefollowingdatabaseobjectswillaccessbeattempted?A.user2.orgB.org.sampleC.sample.orgD.sample.sample正确答案:D8.在客户端直接连接到DB2UDB服务器的环境中，服务器端的认证类型为以下哪个时，在编目时指定的认证类型不一定要与服务器端认证参数的值相匹配。A.SERVER_ENCRYPTB.DCEC.DCE_SERVER_ENCRYPTD.KERBEROS正确答案:C9.创建一个DMS类型的表空间，可以使用以下哪两种文件系统对象作为容器？A.目录B.文件C.DEVICE正确答案:B10.ToprepareanembeddedSQLprogramforusewithahost-languagecompiler,whichofthefollowingdatabasecomponentsisrequired?A.BinderB.PrecompilerC.StoredProcedureBuilderD.ApplicationDevelopmentCenter正确答案:B11.Giventhecode:EXECSQLWITHmost_citiesAS(SELECTb.id,b.name,a.citiesFROMcountrya,staffbWHEREa.person=b.idANDcities>:threshold)SELECTid,name,citiesFROMmost_citiesINTO:id,:name,:citiesWHEREcitiesIN(SELECTMAX(cities)FROMmost_cities)WhichofthefollowingcanreferenceMOST_CITIES?A.ThecurrentstatementB.StatementsfromanyapplicationC.AllstatementswithinthisapplicationD.Allstatementswithinthecurrentunitofwork正确答案:A12.下列SQL语句中，能够实现“收回用户U4对学生表（STUD）中学号（XH）的修改权”这一功能的是（）A.REVOKEUPDATE(XH)ONTABLEFROMU4B.REVOKEUPDATE(XH)ONTABLEFROMPUBLICC.REVOKEUPDATE(XH)ONSTUDFROMU4D.REVOKEUPDATE(XH)ONSTUDFROMPUBLIC正确答案:C13.AnapplicationusesembeddeddynamicSQLtoconnecttoaremoteDB2serverandinsertsdataintotheCUST.ORDERStableonthatremoteDB2server.ToenableaccessoftheremoteDB2server,AdministratorFOOneedstocreateapackagewithdefaultoptionssuchthatBARistheonlynon-administrativeuserthatcanusethispackageontheremoteDB2server.Whichstatementdescribestheprivilegesthatmustbegrantedand/orrevokedbyFOOtoaccomplishthis?A.BARrequiresEXECUTEprivilegeonthepackageandUPDATEprivilegeonCUST.ORDERS,andtheEXECUTEprivilegeforthepackagemustberevokedfromPUBLIC.B.BARrequiresEXECUTEprivilegeonthepackageandINSERTprivilegeonCUST.ORDERS,andtheEXECUTEprivilegeforthepackagemustberevokedfromPUBLIC.C.BARrequiresEXECUTEprivilegeonthepackageandINSERTprivilegeonCUST.ORDERS,andtheREFERENCESprivilegeforthepackagemustberevokedfromPUBLIC.D.BARrequiresEXECUTEprivilegeonthepackageandUPDATEprivilegeonCUST.ORDERS,andtheREFERENCESprivilegeforthepackagemustberevokedfromPUBLIC.正确答案:B14.对于那些需要...
