AuserutilizinganaliastoupdateasubsetofcolumnsinatablemusthaveUPDATEprivilegesonwhichofthefollowingDB2objects?（）
A. Table
B. Columns
C. TableandAlias
D. ColumnsandAlias
查看答案
A"trusted"clientneedstocommunicatewithaserverthathasbeenconfiguredtouseCLIENTauthentication.Whichofthefollowingwillbeusedtoverifypasswords?（）
A. UserID/passwordfile
B. Communicationslayer
Clientapplications
D. Operatingsystem
TheEMPtablehassomediscrepancyindataentrywithaparticularemployeeID.YouexecutethequeryasshownintheExhibittoretrieveallversionsoftherowthatexistbetweentwoSCNs. ViewtheExhibit. WhichtwostatementsabouttheresultsofthequeryshownintheExhibitarecorrect?（）
A. TheLAST_SCNvalueinthefirstrowisNULL,whichmeansthattheversionsoftherowstillexistatSCN6636300.LAST_SCN
B. TheLAST_SCNvalueinthesecondrowinNULL,whichmeansthattheversionoftherowstillexistsatSCN6636300.
C. TheLAST_SCNvalueinthethirdrowis6636280,whichmeansthattheversionofrowexistsaboveSCN6636280.
D. TheLAST_SCNvalueinthesecondrowisNULL,whichmeansthattheversionoftherownolongerexistsbecauseitwasdeleted.LAST_SCN
AdatabaseinstanceisusinganAutomaticStorageManagement(ASM)instance,whichhasadiskgroup,DGROUP1,createdasfollows: WhathappenswhenthewholeCONTROLLER1Failuregroupisdamaged?（）
A. Thetransactionsthatusethediskgroupwillhalt.
B. ThemirroringofallocationunitsoccurswithintheCONTROLLER2failuregroup.
C. ThedataintheCONTROLLER1failuregroupisshiftedtotheCONTROLLER2failuregroupandimplicitrebalancingistriggered.
D. TheASMdoesnotmirroranydataandnewlyallocatedprimaryallocationunits(AU)arestoredintheCONTROLLER2failuregroup.
Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance： Identifythestatementthatcorrectlydescribesthissetting.（）
A. TheMANDATORYlocationmustbeaflashrecoveryarea.
B. Theoptionaldestinationsmaynotusetheflashrecoveryarea.
C. ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATOR
D. Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.
微信支付 
支付宝支付