Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?()A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.B. It perfo

题目
Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?()

A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500MB of data transfer for queries, but not for data manipulation language (DML) operations.


相似考题
更多“Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?() ”相关问题
  • 第1题:

    Youwanttoenabletheuser,Scott,tochangetotheGRP1consumergroupbyissuingthefollowingcode:SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP(’SCOTT’,’GRP1’,FALSE);Howwillyougranttheswitchprivilegetotheuser,Scott?()

    A.byusingtheDBMS_SESSIONpackage

    B.bygrantingtheDBArole

    C.byusingtheDBMS_RESOURCE_MANAGERpackage

    D.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage


    参考答案:D

  • 第2题:

    WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?()

    A.Youcanfindinformationaboutonlyactivetransactionsfromtheview

    B.Youcanfindinformationaboutreadonlytransactionsfromtheview

    C.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheview

    D.Youcanfindinformationaboutbothactiveandcommittedtransactionsfromtheview

    E.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview


    参考答案:C, D

  • 第3题:

    下列选项中,关于page指令中指明需要内置Session对象的设置是()。

    A.session=”false”

    B.session=”0”

    C.session=”1”

    D.session=”true”


    namespace

  • 第4题:

    Youupdatedtheresourceplandirectivefortheresourceconsumergroup,DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement:

    SQL>EXECDBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(PLAN=>’DSS_PLAN’,

    GROUP_OR_SUBPLAN=>’DSS_USERS’,

    NEW_CPU_P1=>80,

    NEW_SWITCH_GROUP=>’CANCEL_SQL’,

    NEW_SWITCH_ESTIMATE=>TRUE,

    NEW_SWITCH_TIME=>600);

    Auserconnectstothedatabaseandstartsanoperation.WhatistheoutcomeifOracleestimatesthattheexecutiontimeforthisoperationwillexceed600seconds?()


    参考答案:B

  • 第5题:

    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.


    参考答案:A, B, D