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?()

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.


相关考题:

在Servlet里,能正确获取session的语句是()。 A、HttpSessionsession=request.getSession(true)B、HttpSessionsession=request.getHttpSession(true)C、HttpSessionsession=response.getSession(true)D、HttpSessionsession=response.getHttpSession(true)

在一个JSP页中,session=true是默认值。()

A Windows Communication Foundation (WCF) client and service share the following service contract interface:[ServiceContract]public interface IContosoService{[OperationContract]void SavePerson(Person person);}They also use the following binding:NetTcpBinding binding = new NetTcpBinding() { TransactionFlow = true };The client calls the service with the following code:using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)){IContosoService client = factory.CreateChannel();client.SavePerson(person);Console.WriteLine(Transaction.Current.TransactionInformation.DistributedIdentifier);ts.Complete();}The service has the following implementation for SavePerson:public void IContosoService.SavePerson(Person person){person.Save();Console.WriteLine(Transaction.Current.TransactionInformation.DistributedIdentifier);}The distributed identifiers do not match on the client and the server.You need to ensure that the client and server enlist in the same distributed transaction. What should you do?()

GivenanHttpServletRequestrequestandanHttpServletResponseresponse:41.HttpSessionsession=null;42.//insertcodehere43.if(session==null){44.//dosomethingifsessiondoesnotexist45.}else{46.//dosomethingifsessionexists47.}Toimplementthedesignintent,whichstatementmustbeinsertedatline42?()A.session=response.getSession();B.session=request.getSession();C.session=request.getSession(true);D.session=request.getSession(false);E.session=request.getSession(jsessionid);

Youwanttoenabletheuser,Scott,tochangetotheGRP1consumergroupbyissuingthefollowingcode:SQLEXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP(’SCOTT’,’GRP1’,FALSE);Howwillyougranttheswitchprivilegetotheuser,Scott?()A.byusingtheDBMS_SESSIONpackageB.bygrantingtheDBAroleC.byusingtheDBMS_RESOURCE_MANAGERpackageD.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage

Youupdatedtheresourceplandirectivefortheresourceconsumergroup,DSS_USERS.TheresourceplandirectiveisassignedtotheDSS_PLANbyusingthefollowingstatement:SQLEXECDBMS_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?()

WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?() A.YoucanfindinformationaboutonlyactivetransactionsfromtheviewB.YoucanfindinformationaboutreadonlytransactionsfromtheviewC.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheviewD.YoucanfindinformationaboutbothactiveandcommittedtransactionsfromtheviewE.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview

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.

下列选项中,关于page指令中指明需要内置Session对象的设置是()。A.session=”false”B.session=”0”C.session=”1”D.session=”true”