to avoid round trips to the server by enabling caching of query results in client memory
to improve performance by storing a copy of the data from the private SQL area of the PGA
to enhance the query performance by creating a cache in the client memory for sorting operations
to avoid the storing of query plans and results in the server by creating a cache in the client memory
第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?()
第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?()
第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?()
第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?()
第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?()
第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?()
第7题:
to avoid round trips to the server by enabling caching of query results in client memory
to improve performance by storing a copy of the data from the private SQL area of the PGA
to enhance the query performance by creating a cache in the client memory for sorting operations
to avoid the storing of query plans and results in the server by creating a cache in the client memory
第8题:
Edit the ASP.NET runtime version in IIS 6.0.
Edit the System.Web section handler version number in the machine.config file.
Add the requiredRuntime configuration element to the Web.config file and set the version attribute to v3.5.
Add the supportedRuntime configuration element in the Web.config file and set the version attribute to v3.5.
第9题:
Restart the client computer.
Instruct the user to log off and then log on to the client computer.
On the client computer, run the Gpupdate.exe command with the /Force parameter.
On the client computer, run the Gpupdate.exe command with the /Target:computer parameter.
第10题:
Set the CPU time per call in the users profile.
Set the CPU time per session in the users profile.
Set the CPU levels for the user’s group using Resource Manager.
Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
第11题:
to avoid round trips to the server by enabling caching of query results in client memory
to improve performance by storing a copy of the data from the private SQL area of the PGA
to enhance the query performance by creating a cache in the client memory for sorting operations
to avoid the storing of query plans and results in the server by creating a cache in the client memory
第12题:
register database
recover catalog
load backupset
synch metadata
catalog start with
第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?()
第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?()
第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()
第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? ()
第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? ()
第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?()
第19题:
Enable debug logging.
Enable automatic testing for simple queries.
Enable automatic testing for recursrve queries.
Configure event logging to log errors and warnings.
第20题:
Configure a MED-V revertible workspace policy.
Configure the Remote Desktop Connection Broker (RD Connection Broker). Create a Group Policy object (GPO) to configure the Configure server authentication for client setting.
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.
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
第21题:
Stop and Restart DNS client service.
Add 10.1.1.5 to DNS server list on TCP/IP advanced properties tab.
Add A (host) record for the computer to the DNS server zone file.
Configure DHCP server to have a DNS server address of 10.1.1.5
第22题:
You should set query governor cost limit
You should set cost threshold for parallelism
You should set priority boost
You should set precompute rank
第23题:
Grant usersFull Controlpermission to the C drive and all child folders
Use the Recovery Console to restore system files
Use Security Configuration and Analysis to apply the Secure security template to Client1
Use Security Configuration and Analysis to apply the Default security template to Client 1
第24题:
Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
Increase the value of the SGA_TARGET initialization parameter.