第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