雨课堂学堂在线学堂云《MySQL Database Programming（昆明理大 ）》单元测试考核答案

注：不含主观题第1题判断题(1分)Thedatainthedatabasecanbesharedbymultipleusers.()第2题判断题(1分)Theprimarykeyisnotallowedtotakenullvalues.()第3题判断题(1分)Theprimarykeycannotbeusedasaforeignkeyinanotherrelation.()第4题判断题(1分)Theprimarykeycantakeduplicatevalues.()第5题判断题(1分)Two-dimensionaltablesareusedtorepresententitiesandconnectionsinrelationmodel.()第6题判断题(1分)TSQLlanguageisusedinMySQLinteractiveoperation.()第7题判断题(1分)Themainfunctionofthedatabasemanagementsystemiscalculation.()第8题判断题(1分)Indatabasedesign,E-Rdiagramsareusuallyusedtobuildaconceptualmodelofthedatabase.()Indatabasedesign,E-Rdiagramsareusuallyusedtobuildaconceptualmodelofthedatabase.()第9题判断题(1分)MySQLisadatabasebasedonahierarchicalmodel第10题判断题(1分)Adatabaseisanorganizeddatasetstoredinacomputerforalongtime.第11题单选题(1分)Thecoreofthedatabasesystemis____.AdatabaseBdatabaseapplicationsystemCdatabasemanagementsystemDdatabaseadministrator第12题单选题(1分)Thedatamodeloftherelationaldatabaseis____.AhierarchicalmodelBmeshmodelCrelationalmodelDstructuralmodel第13题单选题(1分)Thecoreofthedatabasesystemis____.ADBMSBDatabaseCdatabaseapplicationsystemDusers第14题单选题(1分)____structureisusedtodescribetheconnectionamongdataintherelationalmodel.Atwo-dimensionaltableBhierarchyCthree-dimensionaltableDstereoscopictable第15题单选题(1分)____aretherelationshipsamongentities.Aonetoone,onetomany,manytomanyBonetoone,manytooneConetomany,manytooneDonetoone,manytomany第16题单选题(1分)ThefunctionsofSQLlanguageare____.Arelationnormalization,datamanipulation,datacontrolBdatadefinition,datamanipulation,datacontrolCrelationnormalization,datadefinition,datacontrolDrelationnormalization,datamanipulation,datadefinition第17题单选题(1分)Inthedesignofrelationaldatabase,designofrelationalpatternsbelongsto____ofdatabasedesign.ArequirementanalysisBconceptualdesignClogicaldesignDphysicaldesign第18题单选题(1分)TheSQLlanguageisalsocalled____.AstructureddefinitionlanguageBstructuredcontrollanguageCstructuredquerylanguageDstructuredmanipulationlanguage第19题单选题(1分)TheE-Rdiagramprovidesmethodsforrepresentingentities,attributes,and____intheinformationworld.AdataBconnectionCtableDmodel第20题单选题(1分)E-Rdiagramisoneofthetoolsfordatabasedesign,whichisgenerallyusedtobuild____indatabase.A概念模型BconceptualmodelC结构模型DstructuralmodelE物理模型FphysicalmodelG逻辑模型Hlogicalmodel第21题多选题(2分)Thedatabasesystemcanbedividedinto()AcomputerhardwareBdatabaseadministratorCcomputersoftwareDdatabase正确答案：ABCD第22题多选题(2分)()arethebasicmodelsofdata.AHierarchicalmodelBMeshmodelCStructuralmodelDRelationalmodel正确答案：ABD第23题多选题(2分)()constraintscanensuretheuniquenessofrecordsindatabasetables.APrimarykeyBForeignkeyCUniquenessDNonempty正确答案：AC第24题多选题(2分)Therelationshipamongentitiesis()Aone-to-oneBone-to-manyCmany-to-manyDone-to-two正确答案：ABC第25题多选题(2分)ThefunctionsofSQLlanguageare()ArelationnormalizationBdatadefinitionCdatamanipulationDdatacontrol正确答案：BCD第26题多选题(2分)Relationaldatabasedesignincludes()ArequirementanalysisBconceptualdesignClogicaldesignDphysicaldesign正确答案：BCD第27题多选题(2分)Thedatabasesystemcanadoptdifferentdatamodelsaccordingtoitsdifferentlevels.Thethree-layerstructureincludes()AphysicallayerBlogiclayerCsystemlayerDconceptuallayer正确答案：ABD第28题多选题(2分)Amongthefollowingoptions,()belongtoentity.AbooksBstudentsCcoursesDnames正确答案：ABC第29题多选题(2分)Themainfunctionsofthedatabasemanagementsystemare()AdatabasemaintenanceBdatacalculationCdatamanipulationDdatadefinition正确答案：ACD第30题多选题(2分)()arecorrectdescriptionaboutdata.ADataisnumbers.BDataisthebasicobjectstoredinthedatabase.CDataanditssemanticsareinseparable.DDataisthesymbolicrecordtodescribethings.正确答案：BCDAssignmentforChapter2第1题判断题(1分)MySQLcanonlyberunontheWindowsoperatingsystem.()第2题判断题(1分)Itisadatabasemanagementsystemthatsupportsmultipleusers.()第3题判断题(1分)TheconfigurationfileofMySQLismy.ini.()第4题判断题(1分)YoucanusetheclienttooltologintoMySQLasthesuperadministratorsa.()第5题判断题(1分)TocreateachoosedatabaseinMySQL,youshouldusethecommand“createtablechoose;”.()第6题判断题(1分)ThedefaultstorageengineinMySQL5.6isMyISAM.()第7题判断题(1分)UsingtheimportandexportfunctionsinphpMyadmin,youcanbackupthedatabasewiththelogicalbackup.()第8题判断题(1分)Theclientandservermustbeinstalledandconfiguredondifferentcomputers.()第9题判断题(1分)Theclientintheclient/serverstructurereferstotheapplication.()第10题判断题(1分)Comparedwiththeclient/serverstructure,theapplicationprogramofthebrowser/serverstructureiseasytobeinstalledanddeployed.()第11题判断题(1分)PHPismainlyusedtodevelopapplicationsbasedonbrowser/serverstructure.()第12题判断题(1分)TheApacheserverandMySQLservercanbeinstalledusingtheWAMPServersuite.第13题判断题(1分)TheMySQLserverworksbasedontheC/Smodeandoccupiesport3306.第14题单选题(1分)ThelanguageusedduringtheinteractiveoperationofMySQLis__.AT-SQLBSQLCPL/SQLDESQL第15题单选题(1分)InMySQL,thecommandtospecifyanexistingdatabaseasthecurrentworkingdatabaseis___.AUSEBSELECTCCREATEDUSING第16题单选题(1分)AfterMySQLissuccessfullyinstalled,thesystemwillcreateadirectorynamed____,tostoredatabasefiles.AdataBfileCiniDmysql第17题单选题(1分)WhenoperatingMySQLdatabasewithgraphicalmanagementtool“phpMyAdmin”,thedatabaseapplicationstructureis___.AServer/BrowserBClient/ServerCParallelstructureDcentralizedstructureAssignmentforchapter3第1题判断题(1分)Onappearance,thestringtypeisenclosedinsinglequotationmarksandthedatetypeindoublequotationmarks.()第2题判断题(1分)InMySQL,thefunctionofthe【update】statementInMySQL,thefunctionofthe【update】statementistoinsertarecordintothedatabase.()第3题判断题(1分)Theprimaryconstraintkeyisprimarykey.()第4题判断题(1分)InMySQL,theinsertstatementcannotinsertmultiplerowsintothetableatonce.第5题单选题(1分)Thefollowing______typeisnotthedatatypecommonlyusedinMySQL.AintBvarCcharDtime第6题单选题(1分)TheCREATTABLEstatementisusedtoestablishthe______.AdatabaseBdatatableCviewDindex第7题单选题(1分)ThekeywordtocreateauniqueindexinMySQLis______.AfulltextindexBprimaryindexCuniqueindexDonlyindex第8题单选题(1分)ThecommandtodeletearecordinMySQLis______.AdeleteBdropCclearDcut第9题多选题(2分)MySQLdataintegrityincludes()AentityintegrityBreferentialintegrityCuser-definedintegrityDdesignintegrity正确答案：ABC第10题多选题(2分)Thefollowing()isthekeywordforconstraints.AprimarykeyBdefaultCuniqueDengine正确答案：ABCAssignmentforchapter4第1题判断题(1分)AfterSELECT,onlythefieldnameofthetablecanappear,notanexpression.()第2题判断题(1分)

IntheSELECT

statement,afterthefieldnameorexpression,AS

keywordcanbeused

toreferto

the

aliasofagivencolumn.

()第3题判断题(1分)The

conditionalqueryisusedtofilterdata,thatis,thequeryresultsonlycontainrecordsthatmeettheconditions.

()第4题判断题(1分)

Inthe

WHERE

clause,onecanuserelationaloperatorsandlogicaloperators

toconstructqueryconditions.

()第5题判断题(1分)

IntheSELECT

statement,

LIKE

canbeusedtodescribefuzzydataitemsandtoformfuzzyquery.

()第6题判断题(1分)

Inthe

SELECT

querystatement,onecanuse

LIMIT

tolimitthenumberofqueryresults.

()第7题判断题(1分)

Muti-tablequerydoesnotneedconnectionconditionsbetweentables.

()第8题判断题(1分)

Thecommandtodeletetheviewis

DROPVIEW.()第9题判断题(1分)

Whenthedataseenthroughtheviewismodified,thedataofthecorrespondingbasetablewillalsochange.

()第10题判断题(1分)Aviewisadatabaseobject,avirtualtablederivedfromoneormoredatatablesorviews.

第11题单选题(1分)

Queryallinformationofstudents

fromthestudenttablethecorrectstatementis

____.ASELECT#FROMstudent;BSELECT?FROMstudent;CSELECT_FROMstudent;DSELECT*FROMstudent;第12题单选题(1分)

When

querying

with

SQL,the

WHERE

clauseindicates

____.AQueryresultsBQueryconditionsCQueryViewsDQuerytargets第13题单选题(1分)

IntheSELECT

query,

INNERandJOIN

areusedfortheconnectionbetweentwotables,thecorrespondingconnectorfieldsshouldappearinwhichofthefollowingphrases?

____.AWHEREBONCHAVINGDORDERBY第14题单选题(1分)

Onlyrecordsthatmeetthequeryconditionsareincludedinthequeryresults;thisjoinis

_____.ALeftjoinBRightjoinCInnerjoinDFulljoin第15题单选题(1分)ThequeryexpressionequivalenttotheWHEREdnoIN('IM','CS')conditionis____.AWHEREdnoBETWEEN'IM'OR'CS'BWHEREdnoBETWEEN'IM'AND'CS'CWHEREdno='IM'ORdno='CS'DWHEREdno='IM'ANDdno='CS'第16题单选题(1分)Forthegivenquerystatement:SELECTcnameFROMtb_courseWHEREcnameLIKE'Da%';SELECTcnameFROMtb_courseWHEREcnameLIKE'Da%';Whichofthefollowingoptionsdoesnotmeettheconditions?____ADal_analysisBDataCDatabaseDData_cueb第17题单选题(1分)Amongthe

followingfunctions,____isnotanencryptionfunction.APASSWORD()BMD5()CENCODE()DDECODE()第18题单选题(1分)Amongthefollowingfunctions,____isnotastringclippingfunction.ALPAD()BLEFT()CLTRIM()DRIGHT()第19题单选题(1分)InMySQL,thecommandtocreateaviewsu_viewis

____.ACREATETABLEsu_viewASSELECT...;BCREATEVIEWsu_viewASSELECT…;CCREATEDATABASEsu_viewASSELECT…;DCREATEFUNCTIONsu_viewASSELECT…;第20题单选题(1分)InMySQL,thecommandtodeleteaview

su_view

orderis

____.ADELETEsu_view;BDROPTABLEsu_view;CDROPVIEWsu_view;DDROPsu_view;第21题多选题(2分)Querythe

informationofstudentsbornin

1997

and

1999.

Thecorrect

SELECT

statementis

().ASELECT*FROMstudentWHEREYEAR(birthday)NOTIN(1997,1999)BSELECT*FROMstudentWHEREYEAR(birthday)=1997ORYEAR(birthday)=1999CSELECT*FROMstudentWHEREYEAR(birthday)IN(1997,1999)DSELECT*FROMstudentWHEREYEAR(birthday)EXISTS(1997,1999)正确答案：BC第22题多选题(2分)Inthe

SELECT

statement,thekeywordrelatedtosortingis

().AORDERBYBLIMITCDESCDASC正确答案：ACD第23题多选题(2分)Theoperatorrelatedtothenullvalue()queryis

().ASELECTMAX(score)FROMstudent_scoresBSELECTMIN(score)FROMstudent_scoresCSELECTAVG(score)FROMstudent_scoresDSELECTSUM(score)FROMstudent_scores正确答案：ABD第24题多选题(2分)TheoperatorthatcanbeusedintheSELECT

statementis

().ANULLBISNULLC=NULLD=ISNULL正确答案：AB第25题多选题(2分)Atpresent,

theconnectionformssupportedby

MySQL

are().ANOTBBETWEENANDCLIKED#正确答案：ABC第26题多选题(2分)To

retrieve

thefirst

3

records

inthe

student

table,whichoffollowing

SQL

statements

canyouuse?()AINNERJOINBLEFTJOINCRIGHTJOINDFULLJOIN正确答案：ABC第27题多选题(2分)In

MySQL,commonlyusedaggregationfunctionsinclude

().ASELECT*FROMstudentLIMIT0,3;BSELECT*FROMstudentLIMIT3,0;CSELECT*FROMstudentLIMIT1,3;DSELECT*FROMstudentLIMIT3;正确答案：AD第28题多选题(2分)Youcanuse

()to

view

thedefinitionof

course_view.AGROUPBYBMAXCSUMDCOUNT正确答案：BCD第29题多选题(2分)MySQLviewsinclude().ANormalviewBInspectviewCGeneralviewDVirtualTable正确答案：AB第30题多选题(2分)()canbeusedtocheckthedefinitionofcourse_viewview.ADESCcourse_view;BSHOWCREATEVIEWcourse_view;CSHOWCREATETABLEcourse_view;DDESCRIBEcourse_view;正确答案：ABCDAssignmentforchapter5第1题判断题(1分)Thevariable'@sno'belongstothesystemsessionvariable.()第2题判断题(1分)

Localvariablesmustbedefinedandusedinstoredprogram.()第3题判断题(1分)

'delimiter'canresettheendcommand.()第4题判断题(1分)

Alocalvariablemustbedefinedwith'declare'.()第5题判断题(1分)

Whenthevalue'NULL'involvesinoperationssuchasarithmetic,comparison,andlogic,theresultisgenerally'NULL'.()第6题判断题(1分)Usethe'iterate'statementforthecurrentloopstatementtojumpoutoftheloop.()第7题判断题(1分)

Systemvariablesincludesystemsessionvariablesandthewholesystemvariables,bothofwhichmustbedefinedbeforetheycanbeused.()第8题判断题(1分)BothusersessionvariablesandlocalvariablescanbedefinedandBothusersessionvariablesandlocalvariablescanbedefinedandassignedavalueatthesametimebyusingthe'set'commandandthe'select'statement.Butthe'select'statementcanonlyuse“':='”astheassignmentoperator.()第9题判断题(1分)Thefunctionofthe'Repeat'statementistorepeatedlyexecutetheloopbodywhentheloopconditionistrue,theloopwillnotstopuntilitisfalse.()第10题判断题(1分)Thefunctionofthe'while'statementistorepeatedlyexecutetheloopbodywhentheloopconditionistrue,theloopwillnotstopuntilitisfalse.()第11题判断题(1分)

Thefunctionofthe'loop'statementistoexecutetheloopbodyrepeatedlywithnoconditions,whichwillnotstopuntilthe'leave'statementisexecuted.()第12题判断题(1分)

Thefunctionof'if'and'case'statementistochoosetoexecutedifferentstatementsorstatementblocksaccordingtotheconditions.()第13题单选题(1分)

Theoperationresultoftheexpression'select((6%(7-5))+8)*9-2+(5%2)'is_____.A70B71C72D73第14题单选题(1分)UsersessionvariablesinMySQLshouldbeginwith______symbol?A!B#C@@D@第15题单选题(1分)______isthecorrectless-thanorequalsigninMySQL?A>=B=>C<=D=<'第16题单选题(1分)InMySQL,the_____operatorisrequiredtoperformequalcomparisonoperationontwo'NULLvalues'?A=B<>C<=>D==第17题单选题(1分)

InMySQL,thestatementtocontinuethenextloopis_____whenjumpingoutofthisloop.AleaveBgotoCjumpDiterate第18题单选题(1分)

RegardingtheLOOPstatements,description______inthefollowingiscorrect.ATheloopstatementistorepeatedlyexecutetheloopbodywhentheconditionistrue.BTheloopstatementistorepeatedlyexecutetheloopbodywhentheconditionisfalse.CTheloopstatementexecutestheloopbodyrepeatedlywithnoconditions.DNoneoftheaboveexpressionsiscorrect.第19题单选题(1分)Regardingtheifstatement,description_____inthefollowingiscorrect.AIftheconditionbetweenifandthenistrue,thenexecutethestatementblocksafterthen.BIftheconditionbetweenifandthenisfalse,thenexecutethestatementblocksafterthen.CIftheconditionbetweenifandthenisfalse,thenexecutethestatementblockafterelse.DNoneoftheaboveexpressionsiscorrect.第20题单选题(1分)Regardingthecasestatement,description______inthefollowingiscorrect.AThecasestatementscanrepeatedlyexecutedifferentstatementblocksaccordingtodifferentconditions.BThecasestatementsgenerallyneedtointegratestructurewithkeywordssuchaswhen,then,else,andend.CThecasestatementcanchoosetoexecutedifferentstatementsorstatementsblockswhetherthesameconditionistrueornot.DNoneoftheaboveexpressionsiscorrect.第21题单选题(1分)Regardingtherepeatloopstatement,description_____inthefollowingiscorrect.ATherepeatstatementistorepeatedlyexecutetheloopbodywhentheconditionistrue.BTherepeatstatementistorepeatedlyexecutetheloopbodywhentheconditionisfalse.CTherepeatstatementistoexecutetheloopbodyrepeatedlywithnoconditions.DNoneoftheaboveexpressionsiscorrect.第22题单选题(1分)InMySQL,______istheincorrectconstant?A2.1E5Bb’121’CnullD0x123abc第23题多选题(2分)

Usethe()commandcandefineandassignusersessionvariables.AsetBselectCdeclareDinsert正确答案：AB第24题多选题(2分)

TheinequalityinMySQLcomparisonoperatorscanbewrittenas().A≠B<>C!=D<=>正确答案：BC第25题多选题(2分)

Thecorrectdateandtimeconstantsare().A‘4:30:30’B‘2016-05-04’C‘2016-02-31’D‘2016-04-2112:30:00’正确答案：ABD第26题多选题(2分)Thecorrecthexadecimalconstantare().Ax’4D7953514C’B0x4D7953514CCx4D7953514CD4D7953514C正确答案：AB第27题多选题(2分)

Thefollowingstatementsthatdonotproducearesultsetare().Aset@a=5;Bselect@a:=5;Cselect5into@a;Dset@a:=5;正确答案：ACD第28题多选题(2分)

BooleanvaluesinMySQLinclude().ATRUEBFALSEC0D1正确答案：BC第29题多选题(2分)

Thecomparisonresults()aretrue.A‘ab‘=‘ab’B‘ab’=‘ab’C‘ab’=‘ab’DNULL=NULL正确答案：BD第30题多选题(2分)TheoperationresultofthecomparisonoperatorinMySQLcanbe().AtrueBfalseCnullDerror正确答案：ABC第31题多选题(2分)TheloopstatementsinMySQLinclude().AwhileBdo-whileCforDrepeat正确答案：AD第32题多选题(2分)InMySQL,theselectioncontrolstatementsinclude().AcaseBwhileCifDrepeat正确答案：ACAssignmentforchapter6第1题判断题(1分)Wecanuse“delimiter”toresetthecommandendmarker.()第2题判断题(1分)

Thestoredfunctionmustspecifythetypeofreturnvalue.()第3题判断题(1分)

Tocallthestoredfunctions,CALLstatementsmustbeused.()第4题判断题(1分)

CallstostoredfunctionscanonlyappearinSELECTstatements,notinUPDATEstatements.()第5题判断题(1分)

Bothstoredfunctionsandstoredproceduresarecalledstoredroutines.()第6题判断题(1分)Afterthecursorisdefined,thecursorcanbeopenedautomaticallybydirectlyusingtheFETCHstatement.()第7题判断题(1分)

TheCOMMITstatementisusedtocommittransactions.()第8题判断题(1分)Cursorsandtransactionsarenotallowedinthedefinitionoftriggers.()第9题判断题(1分)Multipletriggerscanbedefinedonatable.()第10题判断题(1分)Ifnotexplicitlyindicated,theeventisdisabledaftercreation.()第11题单选题(1分)

______statementneedstobeusedintheMySQLstoredfunctionbodytoreturntheoperationresult.AreturnBreturnsCbackDgoto第12题单选题(1分)In

thefeaturedescriptionsoftheMySQLstoredfunction,______indicatesthatthefunctionbodycontainsthe“select”querystatement,butnottheupdatestatement.AcontainssqlBnosqlCreadssqldataDmodifiessqldata第13题单选题(1分)______isnotaMySQLstoredprogram.AstoredfunctionBtriggerCeventDview第14题单选题(1分)

______isthecommandtocallthestoredprocedure.ASELECTBDECLARECEXECDCALL第15题单选题(1分)SupposethereisadefinitionofstoredprocedureSPinthedatabase,anditneedsanintegerparameter.______isthelegalcallingform.ACALLsp(1);BCALLsp1;CSELECTsp(1);DSELECTsp1;第16题单选题(1分)

______iscorrectaboutthecomparisonbetweenstoredproceduresandstoredfunctions.ABothcanbecalleddirectly,butthecallingmethodisdifferent.BBothsupportOUTparameters.CStoredprocedurescanincludeRETURNstatements,butstoredfunctionscannot.DBothcanuseSELECTstatementstoreturnresultsetsinthedefinitionbody.第17题单选题(1分)

AbouttheuseofcursorsinMySQL,

______isincorrect.ADeclarecursorswithDECLARECURSOR.BThecursormustbestartedwiththeOPENstatementandclosedwiththeCLOSEstatement.CWithFETCH...INTOstatement,onecanextractthevalueofthecurrentrecordtostoreitinavariable.DMovethecursortothenextrecordusingtheNEXTstatement.第18题单选题(1分)Inthe

followingstatements,______iscorrect

abouttriggers.ATriggersaresimilartostoredfunctionsandbothcanhavereturnvalues.BMySQLonlyprovidestriggersforBEFOREtiming,whichcanonlybetriggeredbeforeaspecificevent.CMySQLallowsINSERT,UPDATEorDELETEeventtotriggeratrigger.DTriggersaresimilartostoredfunctionsandbothcanhaveparameters.第19题单选题(1分)______isusedtodeletetriggers.ADROPTRIGGERSBDROPTRIGGERCCANCELTRIGGERDDELETETRIGGER第20题单选题(1分)______isnotacorrectexplanationfordefiningthetimeandperiodoftheevent.AATclausecanbeusedtodeclarethemomentwhentheeventisscheduledtoexecute.BEVERYclauseisusedtodeclaretheperiodfortheexecutionofeventscheduling.CWecanusetheSTARTSandENDSclausestodeclarethetimeforfirstschedulingDTheATclauseandEVERYclausecanappearatthesametime,toindicatethetimeandperiodofschedulingexecution.第21题多选题(2分)

()ofthefollowingoptionsisaMySQLstoredprogram.AStoredfunctionBTriggerCStoredProcedureDEvent正确答案：ABCD第22题多选题(2分)

()ofthe

followingstoredprogramsbelongtostoredroutines.AStoredfunctionBTriggerCStoredProcedureDEvent正确答案：AC第23题多选题(2分)

()ofthefollowingstoredprogramscannotbecalleddirectlybyname.AStoredfunctionBStoredProcedureCTriggerDEvent正确答案：CD第24题多选题(2分)()ofthefollowingcanbeusedtomodifytheparametersofastoredproceduretoindicatethedirectionofparameterpassing.AINBOUTCINOUTDRETURN正确答案：ABC第25题多选题(2分)

Assumingthatthereisalreadyadefinitionofastoredprocedure“sp”withoutparametersandadefinitionofastoredfunction“fn”withanintegerparameter,()ofthefollowingcallsareappropriate?.ACALLsp()BCALLspCCALLfn(1)DSELECTfn(1)正确答案：ABD第26题多选题(2分)

()ofthefollowingoptionscanbeusedtoexplainthedataaccessselectivityofthestoredroutine.ANOSQLBCONTAINSSQLCREADSSQLDATADMODIFIESSQLDATA正确答案：BCD第27题多选题(2分)

Afterthecursorisdeclaredasnormal,()ofthefollowingstatementsisareasonableuseofthecursor.AOPENBFETCHCCLOSEDDROP正确答案：BCD第28题多选题(2分)()ofthefollowingareMySQLtransactioncontrolstatements.ASTARTTRANSACTIONBCOMMITCROLLBACKDCLOSETRANSACTION正确答案：ABC第29题多选题(2分)()ofthefollowingoptionsexpresslegaltriggertimingandevents.ABEFOREINSERTBAFTERDELETECAFTERCREATEDBEFOREMODIFY正确答案：AB第30题多选题(2分)Theglobalvariable“event_scheduler”reflectsthestateoftheeventscheduler.Itspossiblevaluescantake().AENABLEDBDISABLEDCONDOFF正确答案：BCDAssignmentforChapter7第1题判断题(1分)WiththeCREATEUSERstatement,wecanonlyaddonenewuseratatime.()第2题判断题(1分)WecanuseRENAMEUSERtomodifythenameofanexistingSQLuser.()第3题判断题(1分)Whencreatingauser,ifthekeyword'password'isused,thepasswordneedstobespecifiedincleartext.()第4题判断题(1分)Whenthepermissiontableisupdatedmanually,theserverwillautomaticallymonitorthechangeofpermissions.()第5题判断题(1分)AfterMySQLusesgrantandrevokestatements,theserverwillautomaticallyreadthegranttable.()第6题判断题(1分)AllMySQLstorageenginessupporttransactionprocessing.()第7题判断题(1分)TheMyISAMstorageengineofMySQLsupportstransactionprocessing.()第8题判断题(1分)InMySQL,whenasessionstarts,thevalueofthesystemvariableautocommitis1.()第9题判断题(1分)Theatomicityoftransactionmeansthateverytransactionmustberegardedasanindivisibleunit.()第10题判断题(1分)InnoDBtabletypesautomaticallyperformtablelockingintransactions.()第11题判断题(1分)TheMyISAMtabletypeonlysupportstablelocking.()第12题判断题(1分)Themysqldumpcommandistobackupthedatabaseintoabinaryfilecontainingseveralcreateandinsertstatements.()第13题判断题(1分)WithInnoDBstorageengine,wecandirectlycopytothedatabasedirectorytorestorethebackupdatabase.()第14题判断题(1分)ErrorloggingcanalsobedisabledinMySQL.()第15题判断题(1分)Youcanusethe‘purgemasklogs’statementtocleanupbinarylogfiles.()第16题单选题(1分)WhatstatementcanbeusedtoadduserstothespecifieddatabaseinMySQL?____ArevokeBgrantCinsertDcreate第17题单选题(1分)WhatstatementcanbeusedtoauthorizeusersinMySQL?____ArevokeBgrantCinsertDcreate第18题单选题(1分)WhatstatementcanbeusedtodeleteusersinMySQL?____ArevokeBgrantCdeleteuserDdropuser第19题单选题(1分)WhatisthetablethatstoresglobalpermissionsoftheuserinMySQL?____Atables_privBprocs_privCcolumns_privDUser第20题单选题(1分)WhichofthefollowingcommandsisusedtorevokepermissionsonMySQLuserobjects?____ArevokeBgrantCdenyDcreate第21题单选题(1分)Whichofthefollowingwild-cardsrepresentsasetofhosts?____A*B?C%D-第22题单选题(1分)WhatisthecommandtochangeyourMySQLserverpassword?____AmysqlBgrantCsetpasswordDchangepassword第23题单选题(1分)WhatisthestatementthatgiveusersinXiaowangtherighttoquery,update,andinsertdatatothestudenttableincourse?____Agrantselect,update,insertoncourse.studentfor‘xiaowang@localhost’;Bgrantselect,update,insertoncourse.studentto‘xiaowang@localhost’;Cgrant‘xiaowang@localhost’toselect,update,insertforcourse.student;Dgrant‘xiaowang@localhost’tocourse.studentonselect,update,insert;第24题单选题(1分)Whatstatementtousetoviewthepermissionsfortheuserof‘student1@localhost’?____Ashowgrantsforstudent1@localhostBshowgrantforstudent1@localhostCshowgrantsonstudent1@localhostDshowgrantonstudent1@localhost第25题单选题(1分)Whatthefollowingfailuresarenotincludedinthepossibledisastersinthelifecycleofadatabasesystem?____AsystemfailureBTransactionfailureCPowerfailureDMediafailure第26题单选题(1分)Whichofthefollowingbackupsisnotincludedaccordingtowhethertheserverisonlineatthetimeofbackup.____AHotbackupBFullbackupCColdbackupDWarmbackup第27题单选题(1分)Whenrestoringdatabase,Whatistheoperationwemustperformatfirst?____ACreatedatatablebackupBCreateafulldatabasebackupCCreateacoldbackupDDeletethemostrecenttransactionlogbackup第28题单选题(1分)WhatshouldIdofirstwhenIcreateadatabasefileorfilegroupbackup?____ACreateatransactionlogBCreateafulldatabasebackupCCreateawarmbackupDDeletedifferentialbackup第29题单选题(1分)Whenthefollowingfailuresoccur,whatoperationsneedtobemanuallyrecoveredbythedatabaseadministrator?____APowerfailureBDeletingtabledatabymistakeCDeadlockDOperatingsystemerror第30题单选题(1分)WhichofthefollowingcharacteristicsdoesMySQLtransactionnothave?____AAtomicityBIsolationCConsistencyDSharing第31题单选题(1分)Whichofthefollowingstatementscannotopenanewtransaction?____ACOMMITstatementBSTARTTRANSACTIONstatementCASQLstatementwasexecutedaftertheROLLBACKstatementDBEGINWORKstatement第32题单选题(1分)ThecommonlocktypesinMySQLdonotincludewhichofthefollowing?____AShareBIntentionCFrameworkDExclusive第33题单选题(1分)Theisolationlevelofthetransactiondoesnotinclude____.AreaduncommittedBreadcommittedCrepeatablereadDrepeatableonly第34题单选题(1分)Whatarethereasonsfordeadlock?______AconcurrencycontrolBServerfailureCdataerrorDOperationerror第35题单选题(1分)WhatdoyouneedtodoafterMySQLissuesadeadlock?______AUsermanualprocessingBSystemautomaticprocessingCModifydatasourcesDCanceltransaction第36题单选题(1分)Bydefault,onlythe______ofMySQLisenabled.ABinarylogBErrorlogCGeneralquerylogDSlowquerylog第37题单选题(1分)InMySQL,exceptfor____,theotherlogsaretextfiles.ABinarylogBErrorlogCGeneralquerylogDSlowquerylog第38题单选题(1分)IntheMySQL,____filesaremainlyusedtorecordquerystatementsthattakealongtimetoexecute.ABinarylogBErrorlogCGeneralquerylogDSlowquerylog第39题单选题(1分)Ifthedatabaseisdamagedunexpectedly,youshouldfirstrestorethedatabasebyusingthelatestbackupfile____torestore.ABinarylogBErrorlogCGeneralquerylogDSlowquerylog第40题单选题(1分)Whichofthefollowin