
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.
第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
第2题:
A.Youcanfindinformationaboutonlyactivetransactionsfromtheview
B.Youcanfindinformationaboutreadonlytransactionsfromtheview
C.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheview
D.Youcanfindinformationaboutbothactiveandcommittedtransactionsfromtheview
E.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview
第3题:
下列选项中,关于page指令中指明需要内置Session对象的设置是()。
A.session=”false”
B.session=”0”
C.session=”1”
D.session=”true”
第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?()
第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.