數(shù)據(jù)庫(kù)系統(tǒng)原理ppt課件(參考版)
2025-05-03 18:24本頁(yè)面
【正文】 Argentina武漢大學(xué)國(guó)際軟件學(xué)院52答案： 總分（答對(duì)題數(shù)）：武漢大學(xué)國(guó)際軟件學(xué)院題 號(hào) 1 2 3 4 5 6 7 8 9 10答案 C B D C B ABD B B C ABC對(duì)錯(cuò)題 號(hào) 11 12 13 14 15 16 17 18 19 20答案 C C D BCD D C D B BC C對(duì)錯(cuò)題 號(hào) 21 22 23 24 25 26 27 28 29 30答案 B E C E A C AB D C C對(duì)錯(cuò)題 號(hào) 31 32 33 34 35 36 37 38 39 40答案 A B B A A A B B C D對(duì)錯(cuò)題 號(hào) 41 42 43 44 45 46 47 48 49 50答案 D A C A A A C D B C對(duì)錯(cuò)53。E.CanadaC.Cuba A.table?fromnamethefollowingof FETCHc1c1c1person_id,ORDERFROMSELECTHOLDCURSOR DECLARE7 France Germany 1 2 3 20 2 10 1 CITIESPERSON_ID NAME below:COUNTRYIDtheCOUNTRYthecountryALL D.FROMDELETEcountryDELETEcountryA.COUNTRY?tablefromallcanSQLthe武漢大學(xué)國(guó)際軟件學(xué)院50問(wèn)題 49：Which joinedsubselectontableUpdatingclauseabasedmultipleC.joinedconsistingaB.multipleA.UPDATEaacplishedcanthe武漢大學(xué)國(guó)際軟件學(xué)院49問(wèn)題 48：Whichdef39。(NULL,c2)t1INSERTNULL)abc39。VALUES(c1,INTOC.def39。NULL,VALUESINTOB.,39。VALUESINTOA.willINSERTthe)Whichc2NULL,CHAR(10)ASGENERATEDNOTINTEGERTABLEcreatedtableDESC 武漢大學(xué)國(guó)際軟件學(xué)院 48問(wèn)題 47：GivenBYmBY5000mFROMm,SELECTDESCD.BYmBY5000mstaffCOUNT(*)SELECTDESCC.BY5000mdeptGROUPFROMdept,2ORDERBY5000mstaffCOUNT(id)SELECTleast.A.mostcountthesortedshouldThe5000.greateraemployeeleastwithreturnconditions:theidcorrespondingandeachemployeesnumberthewillSQLthe m DECIMAL(10,2)Which salary DECIMAL(10,2) years INTEGER jobCHAR(20) dept INTEGER name CHAR(20)id INTEGERSTAFFtablethemyears,id,name,ORDERFROMSELECTmD.years,id,name,GROUPFROMSELECTjobC.BYstaffnameSELECTjobB.ORDERFROMSELECTA.thetogetheralltogetherallmanagerswiththewillfollowingofandmanager,jobcontainsjobDECIMAL(10,2) m DECIMAL(10,2) salary INTEGER years CHAR(20) job INTEGER dept CHAR(20) name INTEGER id STAFFtabletheONJOINRIGHTFROM,SELECTONJOINLEFTFROM,SELECTONJOINFULLFROM,SELECTONJOINnames,A.tables?inanplayersforandNames,thewillfollowingofSakic 121Mario93Brett129Bobby 168BobbyGretzky 244JaromirfollowingtheSundin MessierLemieuxYzermanLemieuxHull Hull Orr Jagr NumberWayneBY=ba,FROM,D. GROUPWHEREstaffSUM()SELECTBY=ba,FROM,B. ORDERWHEREstaffSUM()SELECTdepartment?inallsalarythename,department,displaystatementstheDECIMAL(10,2)WhichsalaryCHAR(30) location CHAR(20)CHAR(30) division INTEGER managerCHAR(30)CHAR(30) idINTEGER definitions:followingtheE.D.C.B.A.COUNT(*)theresultisthetab2)Whichcol1col1FROMSELECT(NULL),(1)tab2INSERT(NULL),(1)tab1INSERTINT)tab2CREATEINT)tab1CREATEstatements:following武漢大學(xué)國(guó)際軟件學(xué)院43問(wèn)題 42：GivenONJOINLEFTFROMSELECTc1=cxtab2OUTERtab1*C.ONJOINtab1*B.WHEREtab1,*A.desiredyieldjoinstheC1 C2 CX CY A 11 A 21B 12 C 13 C 22Whicharefollowingfollowing:武漢大學(xué)國(guó)際軟件學(xué)院42問(wèn)題 41：Given assamecolumnsD. TAB1keysamehasTAB1populatedNEWTAB1B.TAB1triggershasstatementofaoccurfollowingofLIKETABLEDDLtheTABLE1.addednulls,cannotCOL2,columnE. Awith andtoiscallednewzeros.populatedTABLE1addedCOL2columnC. Aisdefaultbecausestatementcode.negativewithstatementDEFAULTINTADDTABLESQLtheresultisthe武漢大學(xué)國(guó)際軟件學(xué)院40問(wèn)題 39：WhichaCONNECTcontainoperationsbutaconnectionan
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1