數(shù)據(jù)庫(kù)系統(tǒng)原理ppt課件-文庫(kù)吧資料
2025-05-06 18:24本頁(yè)面
【正文】 createdcannotApoundsuchatomicallowedaremitreleased,toexplicitrequiresAafailsucceedoperationswhiletobeworkofaimpliesAsingleonwhichoftoarebutmultipleworkunitswork?A.unitanallowedarewhyfollowingofstatetoworkunit D.remainsofCurrentbackisofCurrentmittedworkunit A.ofactiveduringendsanoccurstheconstraint武漢大學(xué)國(guó)際軟件學(xué)院38問(wèn)題 37：WhichconstraintD.indexC.A.particularinainsertedfromspecifictobefollowingof31C.t1?A.forarenonunique)Howt2KEY(c2)KEY(c1), INTEGER,NULL,INTEGER (t1CREATEtheindexusingWhentheselectingindexC.updatingindexB.dropping A.statement?annamereferencedbeindexesdescribesthe武漢大學(xué)國(guó)際軟件學(xué)院35問(wèn)題 34： Whichbedatawhenaandconfidentialhasonesee,alloweduserthattheonetwobedatawhenaandconfidentialhasonesee,alloweduserthattheonetwobasenottheaccessthesee.allowedusercolumnsincludesthatasee.B.allowed userthatacolumnstograntacolumnsubsettousertobestistheVALUES(300,2,3)武漢大學(xué)國(guó)際軟件學(xué)院34問(wèn)題 33：WhichINTOD.VALUES(300,2,3)INTOVALUES(200,2,3)C.INTOB.VALUES(200,2,3)INTOwillINSERTtheOPTIONWhichWITHat1ca,ASVIEWcINTINT,t1( CREATEstatementsfollowingc2)武漢大學(xué)國(guó)際軟件學(xué)院33問(wèn)題 32：GivenonINDEXCREATEc2)D.c1onUNIQUEONINDEXCREATEONINDEXCREATEcolumn(c1)A.valuestherowsorcontainingT1preventindexcreatestatementsthe武漢大學(xué)國(guó)際軟件學(xué)院32問(wèn)題 31：Whichrecord(s)241COL2COL1nameD.an“”indicatingSQLCODErecord(s)2COL2selected0COL2COL1?A.*thereturnedwouldtheWhich ROLLBACKVALUES(4,3)INTOVALUES(1,2)INTOINT)INT,TABLEtransaction:thetables.queryfrequentlyAvoidtableofaaccessRestrictdefineabilitywithProvidedatabaseB.spacemoreAvoidfollowing?A.ofdouserstableofusedviewint) varchar(100),varchar(2),int,tablecol4col3col2tab1(col1createcol4col3col2(col1tableint)B. col3col2(col1tableofaverageDescriptionifthetospacethewillthesecondsWhichJobLengthLengthCol4characterstoDescriptionVariable,Col3charactertoCodeVariable,Col210000001IdentifierCol1columntheMODEINTENTE.READREADMODESHAREstatement?A.lockonbemodesthetwonulls.cannotforeignkeysfornotThisallowcolumnscolumnoverbeindexAnulls.D.cannotPrimaryallowcolumnscolumnoverbeindexAbekeysorder.orinbeindexesindex.B.athingthekeysufficientaItkey?A.acreationsufficientindexaINCLUDE(age)武漢大學(xué)國(guó)際軟件學(xué)院27問(wèn)題 26：WhyDESC)ONINDEX ageONINDEXstudent(name,youngestCREATEname)B.ONINDEXqueryimprovetablethestatementsindexthewhichyoungestthenameslistageCHAR(30),TABLEtable武漢大學(xué)國(guó)際軟件學(xué)院26問(wèn)題 25：GivenE.D.5B.rows?A.howwillFROMSELECTstatement2CanadaJones2NAME tableCOUNTRYfollowinguser1武漢大學(xué)國(guó)際軟件學(xué)院25問(wèn)題 24：Giventable1ONGRANTTOTABLESELECTtable1C.ONTOGRANTTABLEuser1VIEWtable?A.fromreadabilityUSER1explicitlystatementstheWhichtablecreates武漢大學(xué)國(guó)際軟件學(xué)院24問(wèn)題 23：AE.NUMERIC(15,2)C.CLOBpurpose?A.forcolumnfordatamostistheWhicharithmeticusedisThiscustomeruniquelyvalue15usesAnfollowing武漢大學(xué)國(guó)際軟件學(xué)院23問(wèn)題 22：GivenBufferTriggerTableViewbecandatabasethewhich 刪除沒(méi)有課程名的課程的正確語(yǔ)句是哪個(gè)？A． DELETE FROM C WHERE 對(duì)應(yīng)的操作為：SELECT S, COUNT(C) FROM SC HAVING AVG(GRADE)80 武漢大學(xué)國(guó)際軟件學(xué)院13問(wèn)題 12：向基本表增加一個(gè)新列后，原有元組在該列上的值是什么？A． TRUEB． FALSEC． 空值D． 不確定武漢大學(xué)國(guó)際軟件學(xué)院1
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1