itgle.com

单选题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 thi

题目
单选题
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 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 memoryB. to improve performance by storing a copy of the data from the private SQL area of the PGAC. to enhance the query performance by creating a cache in the client memory for sorting operationsD. to avoid the storing of query plans and results in the server by creating a cache in the client memory

2.You have a domain controller that runs Windows Server 2008 and is configured as a DNS server. You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.

3. You have a domain controller that runs Windows Server 2008 R2 and is configured as a DNS  server.     You need to record all inbound DNS queries to the server.     What should you configure in the DNS Manager console（）A、Enable debug logging.B、Enable automatic testing for simple queries.C、Enable automatic testing for recursive queries.D、Configure event logging to log errors and warnings.

4. You have just finished aligning a Cisco Aironet 1400 Series Wireless Bridge link using installationmode. When you set the link back to operational mode you loose association to the root bridge. Which action will correct the problem？（）A、Configure the proper channel.B、Enable passwords on both bridges.C、Configure the distance parameter value.D、Configure the bridge to force infrastructure devices to associate only to the SSID parameter.

参考答案和解析
正确答案： 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 thi”相关问题

  • 第1题：

    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

    • A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
    • B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
    • C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
    • D、 Increase the value of the SGA_TARGET initialization parameter.

    正确答案:B

  • 第2题：

    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

    正确答案:A

  • 第3题：

    From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries.  You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message.  Which method would you follow to achieve this？（）

    • A、set the CPU time per call in the users profile
    • B、set the CPU time per session in the users profiles
    • C、set the CPU levels for the users’ group using Resource Manager
    • D、set the TIMED_STATISTICS parameter to TRUE in the parameter file

    正确答案:C

  • 第4题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?（）

    • A、You should set query governor cost limit
    • B、You should set cost threshold for parallelism
    • C、You should set priority boost 
    • D、You should set precompute rank

    正确答案:B

  • 第5题：

    A user named Marie uses a Windows 2000 Professional computer named Client1 to process payroll records. Marie reports that she can no longer run her financial applications. You determine that file permissions have been applied incorrectly to her computer. You want to configure Client1 to have the same security configuration and file permission settings that were applied when the computer was installed.  What should you do?（）

    • A、Grant usersFull Controlpermission to the C drive and all child folders
    • B、Use the Recovery Console to restore system files
    • C、Use Security Configuration and Analysis to apply the Secure security template to Client1
    • D、Use Security Configuration and Analysis to apply the Default security template to Client 1

    正确答案:D

  • 第6题：

    Client computers on your network run either Windows Vista or Windows 7. You plan to use Microsoft Application Virtualization （App-V） 4.5 with SP1 as an application virtualization platform. You need to virtualize applications by using mount point installations （MNT）.   What should you do？（）

    • A、Configure the App-V Sequencer to have two partitions
    • B、Configure the App-V Sequencer on a Windows 7 client computer
    • C、Configure virtualized applications to check for updates during installation. "A Composite Solution With Just One Click" - Certification Guaranteed 86 Microsoft 70-693 Exam
    • D、On the reference computer， install all software that typically runs on client computers

    正确答案:A

  • 第7题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You have a Microsoft ASP.NET Framework version 1.0 application. The application does not use any features that are deprecated in the Microsoft .NET Framework version 3.5. The application runs on Microsoft IIS 6.0.  You need to configure the application to use the ASP.NET Framework version 3.5 withoutrecompiling the application.  What should you do？ （）
    A

    Edit the ASP.NET runtime version in IIS 6.0.

    B

    Edit the System.Web section handler version number in the machine.config file.

    C

    Add the requiredRuntime configuration element to the Web.config file and set the version attribute to v3.5.

    D

    Add the supportedRuntime configuration element in the Web.config file and set the version attribute to v3.5.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You have a single Active Directory directory service domain. You use a Group Policy object （GPO） to apply security settings to your client computers. You configure the startup type for system services settings in a new GPO， and you link the GPO to an organizational unit （OU）.  You discover that the startup type for system services on one of the client computers has not been updated. You need to ensure that the Group Policy settings are applied to the client computer. What should you do？（）
    A

      Restart the client computer.

    B

     Instruct the user to log off and then log on to the client computer.

    C

     On the client computer， run the Gpupdate.exe command with the /Force parameter.

    D

     On the client computer， run the Gpupdate.exe command with the /Target：computer parameter.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
    A

     Set the CPU time per call in the users profile.

    B

     Set the CPU time per session in the users profile.

    C

     Set the CPU levels for the user’s group using Resource Manager.

    D

     Set the TIMED_STATISTICS parameter to TRUE in the parameter file.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）
    A

     register database

    B

     recover catalog

    C

     load backupset

    D

     synch metadata

    E

     catalog start with


    正确答案： C
    解析： 暂无解析

  • 第13题：

    You have just finished aligning a Cisco Aironet 1400 Series Wireless Bridge link using installation mode.When you set the link back to operational mode you loose association to the root bridge. Which action willcorrect the problem？（）

    • A、Configure the proper channel.
    • B、Enable passwords on both bridges.
    • C、Configure the distance parameter value.
    • D、Configure the bridge to force infrastructure devices to associate only to the SSID parameter.

    正确答案:C

  • 第14题：

    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

    正确答案:A

  • 第15题：

    You have a domain controller that runs Windows Server 2008 and is configured as a DNS server You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）

    • A、Enable debug logging.
    • B、Enable automatic testing for simple queries.
    • C、Enable automatic testing for recursrve queries.
    • D、Configure event logging to log errors and warnings.

    正确答案:A

  • 第16题：

    Your company has an Active Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2. All client computers run Windows 7. Your environment includes Microsoft Application Virtualization (App-V), Microsoft Enterprise Desktop Virtualization (MED-V), and Remote Desktop Services. You have three applications that are in one package and require authorization to run. You need to deploy the applications for offline use. What should you do? （）

    • A、Configure a MED-V revertible workspace policy.
    • B、Configure the Remote Desktop Connection Broker (RD Connection Broker). Create a Group Policy object (GPO) to configure the Configure server authentication for client setting.
    • C、Use Microsoft Application Virtualization for Desktops. On each client computer, set the client cache configuration settings to Use free disk space threshold and configure the ApplicationSourceRoot registry key.
    • D、Use Microsoft Application Virtualization for Desktops. On each client computer, configure the AutoLoad Triggers, AutoLoadTarget andRequireAuthorizationIfCached registry parameters. Then launch any one of the applications while logged in with the computer user is credentials

    正确答案:D

  • 第17题：

    You configure a W2kPro with static IP. You found an error in DNS server address. You configure DNS address to 10.1.1.5. But the W2kPro is still unable to connect to the network resource by name. You run ipconfig /all and see that DNS server address is：0.0.0.0 What do you do？ （）

    • A、Stop and Restart DNS client service.
    • B、Add 10.1.1.5 to DNS server list on TCP/IP advanced properties tab.  
    • C、Add A （host） record for the computer to the DNS server zone file.  
    • D、Configure DHCP server to have a DNS server address of 10.1.1.5

    正确答案:A

  • 第18题：

    Client computers on your network run either Windows Vista or Windows 7.  You plan to use Microsoft Application Virtualization （App-V） 4.5 with SP1 as an application virtualization platform. You need to virtualize applications by using mount point installations （MNT）.  What should you do？（）

    • A、Configure the App-V Sequencer to have two partitions
    • B、Configure the App-V Sequencer on a Windows 7 client computer
    • C、Configure virtualized applications to check for updates during installation
    • D、On the reference computer， install all software that typically runs on client computers

    正确答案:A

  • 第19题：

    单选题
    You have a domain controller that runs Windows Server 2008 and is configured as a DNS server You need to record all inbound DNS queries to the server. What should you configure in the DNS Manager console（）
    A

    Enable debug logging.

    B

    Enable automatic testing for simple queries.

    C

    Enable automatic testing for recursrve queries.

    D

    Configure event logging to log errors and warnings.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    Your company has an Active Directory Domain Services (AD DS) domain. All servers run Windows Server 2008 R2. All client computers run Windows 7. Your environment includes Microsoft Application Virtualization (App-V), Microsoft Enterprise Desktop Virtualization (MED-V), and Remote Desktop Services. You have three applications that are in one package and require authorization to run. You need to deploy the applications for offline use. What should you do? （）
    A

    Configure a MED-V revertible workspace policy.

    B

    Configure the Remote Desktop Connection Broker (RD Connection Broker). Create a Group Policy object (GPO) to configure the Configure server authentication for client setting.

    C

    Use Microsoft Application Virtualization for Desktops. On each client computer, set the client cache configuration settings to Use free disk space threshold and configure the ApplicationSourceRoot registry key.

    D

    Use Microsoft Application Virtualization for Desktops. On each client computer, configure the AutoLoad Triggers, AutoLoadTarget andRequireAuthorizationIfCached registry parameters. Then launch any one of the applications while logged in with the computer user is credentials


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You configure a W2kPro with static IP. You found an error in DNS server address. You configure DNS address to 10.1.1.5. But the W2kPro is still unable to connect to the network resource by name. You run ipconfig /all and see that DNS server address is：0.0.0.0 What do you do？ （）
    A

    Stop and Restart DNS client service.

    B

    Add 10.1.1.5 to DNS server list on TCP/IP advanced properties tab.  

    C

    Add A （host） record for the computer to the DNS server zone file.  

    D

    Configure DHCP server to have a DNS server address of 10.1.1.5


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are queries that have an estimated execution cost less than 3. You intend to configure the instance, make it use a single thread for these queries. In the options below, which sp_configure configuration option should you set?（）
    A

    You should set query governor cost limit

    B

    You should set cost threshold for parallelism

    C

    You should set priority boost 

    D

    You should set precompute rank


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    A user named Marie uses a Windows 2000 Professional computer named Client1 to process payroll records. Marie reports that she can no longer run her financial applications. You determine that file permissions have been applied incorrectly to her computer. You want to configure Client1 to have the same security configuration and file permission settings that were applied when the computer was installed.  What should you do?（）
    A

    Grant usersFull Controlpermission to the C drive and all child folders

    B

    Use the Recovery Console to restore system files

    C

    Use Security Configuration and Analysis to apply the Secure security template to Client1

    D

    Use Security Configuration and Analysis to apply the Default security template to Client 1


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
    A

     Increase the value of the FAST_START_MTTR_TARGET initialization parameter.

    B

     Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.

    C

     Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

    D

     Increase the value of the SGA_TARGET initialization parameter.


    正确答案： B
    解析： 暂无解析

相关内容