You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this c

题目

You have applications that have frequently executed queries, and produce small and static result sets.You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?（）

A. to avoid round trips to the server by enabling caching of query results in client memory

B. to improve performance by storing a copy of the data from the private SQL area of the PGA

C. to enhance the query performance by creating a cache in the client memory for sorting operations

D. to avoid the storing of query plans and results in the server by creating a cache in the client memory

相似考题

1.You look(). What () you () ?A、tire, did…doB、tiring, have…doneC、tired, do…doD、tired, have…been doing

2.Where ________ you ________?A.are/beB.have/beC.is/beD.have/been

3.9． _______you _______ stay at home today?A． Do ; have toB． Must; have toC． Have; toD． Do ; must

4.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

参考答案和解析
参考答案：A
更多“You have applications that have frequently executed queries, and produce small and static ”相关问题

  • 第1题：

    And they can ______their passports______，making leaving or “escaping” virtually impossible.

    A. have…remove

    B. had…remove

    C. have…removing

    D. have…removed


    正确答案：D
    [解析] 考查have sth. done，故D项是正确的。

  • 第2题：

    What a waste! Why do you () the water () all the time ?

    A、have…flowing

    B、have…flow

    C、have…to flow

    D、have…flowed


    参考答案：A

  • 第3题：

    You look（） What（）you（）?

    Atire；did；do

    Btiring；have；done

    Ctired；do；do

    Dtired；have；been doing


    D
    略

  • 第4题：

    —Where____you____lunch?

    —Athome．Therewasnoschoollunch

    A．did；have

    B．are；having

    C．will；have

    D．do；have


    正确答案：A

  • 第5题：

    Neither Tom nor John__a bike of__own.

    A.have,their
    B.has,his
    C.have,his
    D.has,their

    答案：B
    解析：
    主语由neither…nor…连接时，谓语形式由最邻近的主语的单复数形式决定。

  • 第6题：

    查看MySQL中支持存储引擎的语句是 。

    A．SHOW ENGINS; 和 SHOW VARIABLES LIKE 'have%';

    B．SHOW VARIABLES; 和 SHOW VARIABLES LIKE 'have%';

    C．SHOW ENGINS; 和 SHOW ENGINS LIKE 'have%';

    D．SHOW ENGINS; 和 SHOW VARIABLES from 'have%';


    SHOW ENGINS; 和 SHOW VARIABLES LIKE 'have%';

相关内容