1302221142-51j

《1302221142-51j》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle管理员面试题39道(英文)Oracle面试题专栏,数据库面试题专栏1.DifferentiatebetweenTRUNCATEandDELETE2.WhatisthemaximumbuffersizethatcanbespecifiedusingtheDBMS_OUTPUT.ENABLEfunction?3.Canyouuseacommitstatementwithinadatabasetrigger?4.WhatisanUTL_FILE.Whataredifferentproceduresandfunctionsassociatedw

2、ithit?5.Differencebetweendatabasetriggersandformtriggers?6.WhatisOCI.Whatareitsuses?7.WhatareORACLEPRECOMPILERS?8.Whatissyntaxfordroppingaprocedureandafunction?Aretheseoperationspossible?9.CanafunctiontakeOUTparameters.Ifnotwhy?10.Canthedefaultvaluesbeassignedtoactualparameter

3、s?11.Whatisdifferencebetweenaformalandanactualparameter?12.Whataredifferentmodesofparametersusedinfunctionsandprocedures?13.Differencebetweenprocedureandfunction.14.CancursorvariablesbestoredinPL/SQLtables.Ifyeshow.Ifnotwhy?15.HowdoyoupasscursorvariablesinPL/SQL?16.Howdoyouope

4、nandcloseacursorvariable.Whyitisrequired?17.Whatshouldbethereturntypeforacursorvariable.Canweuseascalardatatypeasreturntype?18.Whatisuseofacursorvariable?Howitisdefined?19.WhatWHERECURRENTOFclausedoesinacursor?20.DifferencebetweenNODATAFOUNDand%NOTFOUND21.Whatisacursorforloop?

5、22.Whatarecursorattributes?23.Differencebetweenanimplicit&anexplicitcursor.24.Whatisacursor?25.Whatisthepurposeofacluster?26.HowdoyoufindthenumbertofrowsinaTable?27.DisplaythenumbervalueinWords?28.Whatisapseudocolumn.Givesomeexamples?29.Howyouwillavoidyourqueryfromusingindexes

6、?30.WhatisaOUTERJOIN?31.Whichismorefaster–INorEXISTS?32.WhendoyouuseWHEREclauseandwhendoyouuseHAVINGclause?33.Thereisa%signinonefieldofacolumn.Whatwillbethequerytofindit?34.WhatisdifferencebetweenSUBSTRandINSTR?35.Whichdatatypeisusedforstoringgraphicsandimages?36.Whatisdiffere

7、ncebetweenSQLandSQL*PLUS?37.WhatisdifferencebetweenUNIQUEandPRIMARYKEYconstraints?38.WhatisdifferencebetweenRenameandAlias?39.WhatarevariousjoinsusedwhilewritingSUBQUERIES?109道SQLServer面试题SQLServer面试题专栏,数据库面试题专栏Thisonealwaysgetsasked.Forawhilethedatabaseinterviewquestionswerel

8、imitedtoOracleandgenericdatabasedesignquestions.Thisisasetofm