网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Examinethecode:CREATEROLEreadonlyIDENTIFIESUSINGapp.chk_readwrite;CREATEROLEreadwriteIDENTIFIEDUSINGapp.chk_readwrite;CREATEORREPLACEPROCEDUREapp.chk_readwriteAUTHIDCURRENT_USERISipchkSTRING(30);BEGINIFsys_context(‘USERENV’,’ISDBA’)=’TRUE’THENDBMS_SESSION.SET_ROLE‘READWRITE’);ELSEDBMS_SESSION.SET_ROLE(‘READONLY’);END;/WhichthreestatementscorrectlydescribetheSecureApplicationroledefinition?()

A.Nouserorapplicationhastorememberorhideapassword.

B.ItpreventseveryoneexceptatrueDBAsessionfromacquiringtheREADWRITErole.

C.app.chk_readwriteiscalledwheneverausertriestoaccessrowsprotectedbytheREADONLYorREADWRITElabel.

D.app.chk_readwriteiscalledbyusersorapplicationswhentheywanttoenabletheREADONLYor READWRITErole.


参考答案

更多 “ Examinethecode:CREATEROLEreadonlyIDENTIFIESUSINGapp.chk_readwrite;CREATEROLEreadwriteIDENTIFIEDUSINGapp.chk_readwrite;CREATEORREPLACEPROCEDUREapp.chk_readwriteAUTHIDCURRENT_USERISipchkSTRING(30);BEGINIFsys_context(‘USERENV’,’ISDBA’)=’TRUE’THENDBMS_SESSION.SET_ROLE‘READWRITE’);ELSEDBMS_SESSION.SET_ROLE(‘READONLY’);END;/WhichthreestatementscorrectlydescribetheSecureApplicationroledefinition?()A.Nouserorapplicationhastorememberorhideapassword.B.ItpreventseveryoneexceptatrueDBAsessionfromacquiringtheREADWRITErole.C.app.chk_readwriteiscalledwheneverausertriestoaccessrowsprotectedbytheREADONLYorREADWRITElabel.D.app.chk_readwriteiscalledbyusersorapplicationswhentheywanttoenabletheREADONLYor READWRITErole. ” 相关考题