雨课堂学堂在线学堂云《Database Technology and Programming（南开）》单元测试考核答案

第1题Oneormoreassociateddatasetsarecalled（）.ADatabaseBDatabasesystemCDatabasemanagementsystemDDatastructure第2题Thedatabasesystemisaman-machinesystemcomposedofahardwaresystem,adatabase,adatabasemanagementsystem,asoftwaresystem,(),andusers.ADatabaseadministratorBProgrammerCSeniorprogrammerDSoftwaredeveloper第3题()isnotthecharacteristicofdatabasesystem。AHigherdataindependenceBLowestdataredundancyCDatadiversityDBetterdataintegrity第4题Therearethreecommondatamodelsfordatabasemanagementsystems.Theyare（）.Anetworkmodel,relationalmodelandsemanticmodelBHierarchical

model,relationalmodel,andnetworkmodel,CLoopmodel,HierarchicalmodelandrelationalmodelDRelationalmodel,object-orientedmodelanddatamodel第5题TherelationshipbetweenDB,DBSandDBMSis（）.ADBMSincludesDBandDBSBDBSincludesDBandDBMSCDBincludesDBSandDBMSDNoneofabove第6题Thecoreofthedatabasesystemis（）.ADatamodelBDatabaseadministratorCDatabaseDDatabasemanagementsystem第7题Dataincludes（）.AWordsBGraphicsCAudioDAllofabove第8题Themainproblemsinthemanualdatamanagementdonotinclude（）.ADataisnotstoredforalongtimeBDataisnotindependentCLowdatasecurityDLargedataredundancy第9题Accordingtothedatamodelclassification,Accessdatabasebelongsto（）.AHierarchicalmodelBNetworkmodelCRelationalmodelDObject-relationalmodel第10题Thehierarchicalmodelreflectswhichkindofrelationshipbetweenentities?（）.AMany-to-manyBOne-to-manyCOne-to-oneDAllofabove第11题Thenetworkmodelofthethreedatamodelsreflectswhichrelationshipbetweenentities?（）.AMany-to-manyBOne-to-manyCOne-to-oneDAllofabove第12题TheThree-Tiermodelofthedatabasesystemis（）.AUpmode,mode,DownmodeBFrontmode,mode,RearmodeCExternalmode,mode,internalmodeDLargemode,Mediummode,Smallmode第13题Themainfeaturesofthedatabasesystemdonotinclude（）.ADatastructuredBDatasharing,dataindependenceCRuninparallelDUnifieddatacontrolfunction第14题Therearefivestagesinthedevelopmentofdatamanagementtechnology,whicharehumanmanagement,(),(),distributeddatabasesystemandobject-orienteddatabasesystem.ARelationaldatabaseandhierarchicaldatabaseBFilesystemanddatabasesystemCNetwork,relationalsystemDTableprocessinganddiskprocessing第15题Alldatabasesystemscanrealizedatasharingandavoidallthedataredundancy.第16题Thedatabasesystemhasconceptualmode,internalmodeandexternalmode.Thereisamappingbetweenanytwoofthem.第17题SomeDBMSsarenotbasedonacertaindatamodel.第18题Intherelationalmodel,arelationcorrespondstoatwo-dimensionaltable.第19题AdatabasemanagementsystemiscalledDBMSforshort,anditsmaincomponentsaredatabasesanddatabaseapplicationsystems.第1题Itis()thatdeterminesthevaluerangeoftheattribute.AEntityBDomainCCodeDRelationship第2题Indatabase,thetableisa/an().ARelationBRecordCIndexDDatabase第3题Arelationisequivalenttoatwo-dimensionaltable,andeachcolumninthetwo-dimensionaltableisequivalenttotherelation's().AAttributeBTupleCStructureDDataItem第4题Inthefollowingrelationalschema,thecorrectoneis().AStudent（sname，gender，birthday）BStudent（sno，sname，gender，birthday，age）CStudent（sno，sname，gender，birthday，cname，score）DStudent（sno，sname，gender，birthday，photo，resume）第5题Whichofthefollowingstatementaboutthetwo-dimensionaltableiswrong?().AThecolumnsinthetwo-dimensionaltablearecalledattributesBThevaluerangeoftheattributeiscalledtheDomainCTherowsinthetwo-dimensionaltablearecalledtuplesDAnycollectionofattributesiscalledarelation第6题Therearetwoentities,projectandvolunteer,oneprojecthasmultiplevolunteers,andonevolunteercanparticipateinmultipleprojects,thentherelationshipbetweentheprojectandvolunteeris().AMany-to-manyBOne-to-manyCMany-to-oneDOne-to-one第7题Oneormoreattributesthatcanuniquelyidentifyatupleinthedatabaseiscalled().ARecordBFieldCKeyDDomain第8题Assumethatthetable"employee"hasfieldssuchasnumber,name,age,title,andnationality.Thefieldthatcanbeusedaskeyis().AnumberBnameCageDtitle第9题Schoolregulations:adormitoryroomcanaccommodate4undergraduatesor2postgraduates.Theaccommodationrelationshipbetweendormitoryroomandstudentsis().AMany-to-oneBOne-to-fourCOne-to-manyDMany-to-many第10题Astudentcanchooseseveralcourses,andacoursecanbechosenbyseveralstudents,sotherelationshipbetweenstudentsandcoursesis().AOne-to-oneBOne-to-manyCMany-to-manyDunknow第11题IfonerecordinTableAmatchesmultiplerecordsinTableB,andonerecordinTableBmatchesonlyonerecordinTableA,therelationshipbetweenTableAandTableBis().AOne-to-oneBOne-to-manyCMany-to-oneDMany-to-many第12题Intherelationalmodel,akeyis().ACanbecomposedofmultiplearbitraryattributesBCanbecomposedofoneormoreattributeswhosevalues​​canuniquelyidentifyanytuplesCAtmostoneattributeDNoneoftheabove第13题Thingsthatexistobjectivelyareentities.第14题Entitiesaredescribedbyoneormoreattributes.第15题Therecanbeseveralprimarykeysinonetable.第16题Arelationisatwo-dimensionaltable,andatwo-dimensionaltableisarelation.第17题ThestructureofthedataisdeterminedbytheDBMSdatamodel.第18题InACCESS2010,eachtablehasonlyoneprimarykey,sothe"studentnumber"fieldisstoredinthestudenttable,youcannolongerstorethe"ID"field.第19题Inarelationalmodel,theorderofcolumnscanbeadjustedatwill.第20题Twoidenticalrecordscanbestoredinonetableofdatabase.Exercise第1题()cannotbedefinedasaprimarykeyinatable.AAutoNumberBSinglefieldCLongtextDMultiplefields第2题InAccess,thecompositionofthetableis().AFieldandRecordBQueryand

FieldCRecordandFormDReportandField第3题Inthetable,youcandefinethreekindsofkey,whichare().ASinglefield,DoublefieldsandMultiplefieldsBSinglefield,DoublefieldsandAutoNumberCSinglefield,MultiplefieldsandAutoNumberDDoublefields,MultiplefieldsandAutoNumber第4题Thedatatypeofthefieldinthetabledoesnotincludethe()type.ALongtextBAutoNumberCDate/TimeDFont第5题TherelationshipbetweentablesanddatabasesinAccessis().AThedatabaseisthetableBOnedatabasecanincludeoneormultiple

tablesCOnedatabasecanincludeonlyonetablesDOnetable

canincludemultipledatabase第6题Toprocessanintegerwithavalueof50000,whichdatatypeshouldbeused.Ainteger

BLonginteger

CSingleDShorttext第7题Thedatatypeofthefieldstoringthesounddatais().AShorttextBLongtextCHyperlinkDOLEobject第8题Thereferentialintegrityrulesbetweentablesdonotinclude().AUpdaterulesBDeleterulesCInsertrulesDIndexrules第9题Toestablishanrelationshipbetweeneachtableinthedatabase,parenttablemustestablish().APrimarykeyBCandidatekeyCNormalindexDUniqueindex第10题Thefollowingdatatypesthatcannotbeindexedare:().AShortTextBCurrencyCDateDOLEobject第11题Inthetable,themainfunctionofindexis().ASavestoragespaceBImprovequeryspeedCEasytomanagementDPreventdataloss第12题Whencreatingthetable"CommodityInformation",ifthevalidationruleofthe"Price"is:

price>0,then(

)canbeguaranteed().AEntityintegrityBDomain

integrityCReferentialintegrityDTableintegrity第13题InthetabledesignviewofAccess,theoperationthatcannotbeperformedis().AModifyfieldtypeBSetindexCAddfieldDDeleterecord第14题TheonenotbelongstoAccessobjectis().ATableBFolderCFormDQuery第15题Adjustingtheappearanceofatableincludeschangingthedisplayorderoffields,rowheight,columnwidth,hidingcolumns,unfreezingcolumns,changingfonts,andsoon.第16题Thefieldmustenteranumber(0~9),noplusorminussignsareallowed,indicatedbymask6.第17题Usethemask"L"toindicatethatthefieldcanentercharactersornumbers.第18题AfterAccess2010,thedatabasefileextensionis“.lab”第19题Thefieldnamecancontainletters,numbers,spaces,andothercharacters,buttheycannotbeginwithaspace.第20题BothlongandshorttextfieldsinAccesscanbesortedorindexed.第21题Thelengthofthedate/timeandcurrencyfieldsinAccessareboth8bytes.第22题Thevaluerangeofdatatypessuchasinteger,longinteger,singleisdifferent.

第23题Therecordsofthetablecanonlybetypedandcannotbeimportedfromotherfiles.第24题Doubleclickthetablenamedirectlytoopenthedesignviewofthetable.第25题DatasortingandfilteringoperationscanberealizedintheDatasheetview.第26题Tablesareusedtostoredata,andqueriesareusedtoprocessdata.第27题PresstheAlt,FandXkeysatthesametimetoexittheACCESSsystem.Exercise第1题Thefollowingexpressionsthatdonotmeettheexpressionwritingspecificationsare().A04/07/2001BT+TCVAL("1234")D2X>15第2题Inthefollowingexpressions,whichresultischartype().AMID("123.45"，5，1)BAsc("Computer")CInstr("IBM"，"Computer")DYear(Date)第3题Theoperationresultoftheexpression5+5Mod2*2is().AErrorB6C10D7第4题TheoutputresultoftheVBAexpression3*3\3/3is().A1B3C9正确答案：第5题Themathematicalexpression1≤X≤6canbeexpressedas().A1=<XORX=<6BX>=1ANDX<=6CX>=1，X<=6DX>=1ORX=<6第6题Thestringfunctiontoget4charactersfromthesecondcharacterinthestringSis().AMid(s，2，4)BLeft(s，2，4)CRight(s，4)DLeft(s，4)第7题TheresultsoftheexpressionsFix(-3.25)andFix(3.75)are().A-3，3B-4，3C-3，4D-4，4第8题Inthefollowingexpressions,thereturnresultislogicallytrue().A"120">"15"B#08-11-2018#>#08-11-2019#C"08/11/18">"07/11/19"D"35"+"40">"70"第9题AssumingthatthevalueofthevariableCJis78,thefunction:IIF(CJ>=60,IIF(CJ>=85,"Excellent","Good"),"Poor")returnsresultis().AExcellentBPoorCGoodD85第10题Thepriorityorderoflogicaloperationsis().AAND、OR、NOTBOR、NOT、ANDCNOT、AND、ORDNOT、OR、AND第11题Afterexecutingthefollowingtwocommands:BOOKS="University"?LEN(MID(BOOKS,5)),theoutputresultis().A16B6C12DGrammaticalerrors第12题InAccess,use"1"for"TRUE"and"0"for"FALSE"Exercise第1题Thefollowing()doesnotbelongtotheoperationquery.AParameterqueryBGeneratetablequeryCUpdatequeryDDeletequery第2题AddtherecordsofTableAtoTableB.IfyoukeeptheoriginalrecordsinTableB,thequerywhichyoucanuseis().ASelectqueryBGeneratetablequeryCAppendqueryDUpdatequery第3题Ifthereisalreadyatablewiththesamenameexistedinthedatabase,tooverwritetheoriginaltablebyquery,thequerytypethatshouldbeusedis().ADeleteBAppendCGeneratetableDUpdate第4题InAccess2016,thedatasourceofthequerycanbe().ATableBQueryCTable,queryandreportDTableandquery第5题Thereisafield"professional"inthedatatableofAccess2016.Tofindrecordscontainingtheword"information",thecorrectqueryconditionexpressionis().A=left([professional],1)="information"Blike"*information*"Cinformation*DMid([professional],1,1)="information"第6题UsethewizardtocreateaqueryintheAccess2016database,anditsdatasource().AFromseveraltablesBFromatableCFromapartofatableDAllofabove第7题Whencreatingaparameterquery,theparameterprompttextshouldbeplaced()intheconditiongridofthequerydesignview.Ain{}Bin()Cin[]Din<>第8题Toquerythestudentinformationwithascoreof85to100points(including85points,butnotincluding100points),thecorrectsettingoftheconditiongridofthequerydesignviewis().A>84or<100BBetween85And100CIn(85,100)D>=85and<100第9题Ifyouwanttofindthe"101"and"102"coursesinthecourseselectiontable,youshouldenter()intheconditiongridofthequerydesignview.A"101"and"102"BNOT("101","102")CNOTIN("101","102")DIN("101","102")第10题Toperformafull-textsearchonatextfield,querythestringthatbeginswith"Access",andthecorrectconditionalexpressionis().ALike"Access*"BLike"Access"CLike"*Access*"DLike"*Access"第11题Ifthewildcard'[]'isusedinthequerycondition,itcanmatchanysinglecharacterlistedinthesquarebrackets.第12题Aquerythatusesrowsandcolumnsinatableforstatisticsisacross-tabquery.第13题The"scoretable"hasthefieldsofstudentnumber,coursenumberandscorefield,tosetthevalueofthe"score"fieldofallrecordsto0,thequerythatshouldbeusedistheupdatequery.第14题Thedatasourceofthesummaryqueryisthefield.第15题Themostconvenientwaytoincreasetheproductpriceintheproducttableistousetheappendquery.Exerise第1题IntheSelectstatementoftheSQLlanguage,theclausethatusedtoindicatetheorderofthequeryresultis().AFromBWhileCGroupByDOrderBy第2题IntheSQLquerystatement,thephraseusedtoselectthedatacolumnis().AWhereBFromCSelectDGroupBy第3题Inthefollowingnarrativeaboutnullvalues,()iswrong.AAnullvalueindicatesthatthefieldhasnotbeendeterminedBAccess2016usesNULLtorepresentnullvaluesCNullvalueisequivalenttoemptystringDNullvalueisnotequaltothevalue0第4题ThereisthefollowingSQL-SelectstatementSelect*FromsalaryWherebasicsalary<=2000Andbasicsalary>=1500,thefollowing()isequivalenttothisstatement.ASelect*FromsalaryWherebasicsalaryBetween1500And2000BSelect*FromsalaryWherebasicsalaryBetween2000And1500CSelect*FromsalaryWherebasicsalaryIn(1500,2000)DSelect*FromsalaryWhereNOT(basicsalary>=1500Orbasicsalary<=2000)第5题TocreateanewtableintheAccess2016database,theSQLstatementthatshouldbeusedis().ACreateTableBAlterTableCCreateIndexDCreateDatabase第6题Inthefollowingquery,()hasthesamefunctionasSelect*FromStudentWhereInStr([resume],"Basketball")<>0.ASelect*FromStudentWhereresumeLike"Basketball"BSelect*FromStudentWhereresumeLike"*Basketball"CSelect*FromStudentWhereresumeLike"*Basketball*"DSelect*FromStudentWhereresumeLike"Basketball*"第7题Thestudentwiththesno9922011hastakenthe103courseandthescoreis85.Thecorrectcommandtoaddthisnewrecordtotheelectivecoursescoretableis().AINSERTINTOcoursescoreVALUES("9922011","103",85)BINSERTTOcoursescoreVALUES("9922011","103",85)CINSERTcoursescoreVALUES("9922011","103",85)DINSERTTOcoursescore(sno,cno,score)VALUES("9922011","103","85")第8题RegardingthesortclauseoftheSQLlanguageSELECTcommand,thefollowingstatement()iswrong.AThesuffixDESCindicatesdescendingorderBThesuffixASCindicatesascendingorderCThedefaultsuffixindicatesascendingorderDThedefaultsuffixindicatesdescendingorder第9题Ifyouwanttocustomizethealiasforthefield,youcanusethekeyword().AASBFORCFROMDON第10题Whethertherecommendfieldinthestudenttableislogical(T/F),querytheinformationoftherecommendedstudent,theconditionalphraseofitsSQLstatementcannotbewrittenas().AWHERErecommendBWHERErecommend=TRUECWHERErecommend=-1DWHERErecommend=1第11题TheHAVINGclausemustfollowaftertheGROUPBYclausetoqualifytheconditionsthatthegroupmustmeet.第12题TheSQLcommandtoquerythestudentnumber,coursenumberandscoreoftheselected5creditscourseis:SELECTsno,cno,gradeFROMscWHEREcno=(SELECTcnoFROMcourseWHEREcredit=5)第13题TheSQLcommandtoquerythestudentnumber,name,coursenumberandscoreis:SELECTXS.Sno,XS.Name,KCCJ.Cno,KCCJ.ScoreFROMstudentasXS,scasKCCJWHEREXS.Sno=KCCJ.Sno第14题INSERTstatementinsertsanewrecordintoatable.Thenewrecordmustincludeallfields.第15题ALTERTABLETeacherADDRemarksMEMO;thefunctionistoaddaMEMOfieldforthetable“teacher”.第16题ThefunctionoftheDROPclauseoftheALTERTABLEcommandistodeletethecurrenttable..第17题ThefunctionoftheDROPcommandistodeletetablesfromthedatabase.Exercise第1题Intheform,theinteractivecontrolerthatusedtoenteroreditdatais().ATextBoxBLabelCChechBoxDListBox第2题Tochangetheoutputcontentofthetextboxcontrolerontheform,theattributethatshouldbesetis().ATitleBQueryconditionCControlsourceDRecordSource第3题ThefunctionoftheCaptionattributeoftheformis().AEnsurethetitleoftheformBEnsurethenameoftheformCEnsuretheboundarytypeoftheformDEnsurethefontoftheform第4题Supposethataformcanbeusedtoinputteacherinformation,inwhichthetitlefieldshouldprovide"Professor","AssociateProfessor","Lecturer"andotheroptionsfortheusertodirectlyselect,sothecontrolerthatshouldbeusedis().ALabelBChechBoxCTextBoxDComboBox第5题Ifyouwanttooutputinformationattheendoftheentirereport,youneedtoset().APagefooterBReportfooterCPageheaderDReportheader第6题Tooutputinformationatthebottomofeachpageofthereport,youneedtoset().APagefooterBReportfooterCPageheaderDReportheader第7题Whendesigningthereport,ifyouwanttooutputthefinalstatisticaldata,youshouldputthecalculationexpressionin().AGroupfooterBPagefooterCReportfooterDMainbody第8题Whatcanbeusedastherecordsourceofthereportis().ATableBQueryCSQLDAllofabove第9题Inthereport,tocalculatethehighestscoreinthe"achievement"field,the"ControlSource"attributeofthecontrolershouldbesetto().AMax(achievement)B=Max([achievement])C=Max[achievement]D=Max{achievement}第10题Thedatasourceofaformcanbeamulti-tablequery.第11题Theformheaderisgenerallyusedtodisplaythetitleatthetopofeachpage.第12题FormisanimportantobjectintheAccess,throughwhichuserscaninput,editandstore.第13题Thelabelismainlyusedtodisplaydescriptivetextonaformorreport,ithasnodatasource.Exercise第1题ThereturnvaluetypeofInputBox()functionis().AValueBStringCVariantsDValueorstring（uptotheinput）第2题ThereturnvaluetypeofMsgBox()functionis().AIntegerBVariantsCStringDValueorstring第3题Toreturntworesultsafterbeingcalledfromasub-process,thefollowingsub-processstatement()indicatesthatisalegalone.APublicSubf2(byvaln%,byvalm%)BPublicSubf1(byrefn%,byvalm%)CPublicSubf1(byrefn%,byrefm%)DPublicSubf2(byvaln%,byrefm%)第4题TheparameterthatmustbewrittenintheInputBox()functionis().APromptBTitleCDefalutResponseDXPos,YPos第5题Ifx=1theny=1,whichofthefollowingstatementiscorrect().Ax=1andy=1arebothassignmentstatementBx=1andy=1arebothrelationalexpressionCx=1isarelationalexpression，y=1isanassignmentstatementDx=1isanassignmentstatement，y=1isanrelationalexpression第6题IntheSelectCasestatement,theexpressionisthefollowingfourforms,theincorrectis().Aexpression，suchas"a"BAsetofenumeratedvalues​​separatedbycommas,suchas"a","b"CExpression1toExpression2,forexample1to10DRelationaloperatorexpression,forexample>=60第7题Thekeywords()canbeusedtodefinesymbolicconstantsinVBA.AConstBDimCPublicDStatic第8题IntheprocessofVBAcodedebugging,itis()thatcandynamicallyunderstandthechangesofvariablesandexpressions.AMonitoringwindowBLocalwindowCImmediatewindowDQuickmonitoringwindow第9题TheSelectCasestructurefirstcalculatesthevalueof().AExpressionBExecutestatementCConditionDParameter第10题TheresultofthestatementIsNumeric("3+2")isFalse第11题TheresultofthestatementIsDate(2016/7/12)isTrue第12题Theresultofstatement123&1is124Exercise第1题Ifitisrequiredtodisplaythepassword"*"whenenteringtextinthetextbox,theattributethatshouldbesetis().A"Default"attributeB"Title"attributeC"Password"attributeD"Inputmask"attribute第2题ThecontrolobjectofAccess2016cansetacertainattributetocontrolwhethertheobjectisavailable(displayedingraywhenitisnotavailable).Theattributewhichneedstobesetis().ADefaultBCancelCEnabledDVisible第3题Whentheformisstarted,theeventprocessfirstexecutedbythesystemis().ALoadBClickCUnloadDGotFocus第4题Ontheform,theattributethatsetsCommand0toinvisibleis().ACommand0.NameBCommand0.CaptionCCommand0.EnabledDCommand0.Visible第5题Thereisanalready-builtform,withacommandbuttonintheform,clickthisbuttontoopenthe"Student"table.IftheVBAcodeisused,thefollowingstatement()iscorrect.ADoCmd.openform"Student"BDoCmd.openview"Student"CDoCmd.opentable"Student"DDoCmd.openreport"Student"第6题()isthemostbasicentityofprogramrunninginobject-orientedprogramming.AObjectBClassCMethodDFunction第7题Whichofthefollowingoptionsdoesnotbelongtotheclasscharacteristics().AHierarchicalBStabilityCInheritanceDEncapsulation第8题Whichofthefollowingoptionsdoesnotbelongtothecontrolerofform().ATableBLabelCTextBoxDComboBox第9题Whichofthefollowingpropertiescandeterminethenumberofcolumnscontainedinthelistboxobject().AButtonCountBColumnCountCPageCountDListCount第10题Thereisanalready-builtformwithacommandbuttonintheform,clickthisbuttontoopenthe"tEmployee"table.IftheVBAcodeisused,thefollowingstatement()iscorrect.ADoCmd.OpenTable"tEmployee"BDoCmd.OpenView"tEmployee"CDoCmd.OpenForm"tEmployee"DDoCmd.OpenReport"tEmployee"第11题Supposethatwhenthe"TeacherInformationInput"formisrunning,the"Professor","AssociateProfessor","Lecturer"andotheroptionsareprovidedforthetitlefield