Code the application to issue a LOCK TABLE statement.
Code the application to issue a LOCK ROW statement.
Decrease the number of I/O servers.
Increase the locklist parameter.
第1题:
You have the following requirements: - Ensure that the business tier can be updated without affecting the application tier. - Use the minimum role instance size that meets or exceeds the current server specifications. You need to recommend a topology for hosting the application in Windows Azure. What should you recommend?()
第2题:
Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?()
第3题:
A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?()
第4题:
A customer needs to ensure that the number of threads servicing an application does not exceed the number of database connections available to the application. What step must you take to address this situation?()
第5题:
You are creating a client application and configuring it to call a Windows Communication Foundation (WCF) service.When the application is deployed, it will be configured to send all messages to a WCF routing service. You need to ensure that the application can consume the target service after the application is deployed. What should you do?()
第6题:
A Windows Communication Foundation (WCF) service has a callback contract. You are developing a client application that will call this service.You must ensure that the client application can interact with the WCF service. What should you do?()
第7题:
A
B
C
D
第8题:
Use the ServiceController class.
Use the ServiceBase class.
Use the ServiceProcessInstaller class.
Use the ServiceInstaller class.
第9题:
In the client application, add a service reference to the router service. In the client binding configuration, specify the address of the router service.
In the client application, add a service reference to the target service. In the client binding configuration, specify the address of the target service.
In the client application, add a service reference to the router service. In the client binding configuration, specify the address of the target service.
In the client application, add a service reference to the target service. In the client binding configuration, specify the address of the router service.
第10题:
Configure a Max Threads Constraint and add your application to the list of applications for the Constraint.
Configure a Work Manager with a Maximum Threads Constraint tied to the Connection Pool and configuration your application to use the Work Manager.
Configure a Work Manager with a Minimum Threads Constraint tied to the Connection Pool and configure your application to use the Work Manager.
Configure a global MaxThreads constraint and target it to the server or clusters where your application is deployed.
Configure the startup parameter -Dwls-maxThreads to be the same as the number of database connections configured.
第11题:
Code the application to issue a LOCK TABLE statement.
Code the application to issue a LOCK ROW statement.
Decrease the number of I/O servers.
Increase the locklist parameter.
第12题:
The database manager will rollback the transaction in both applications.
The database manager will rollback the transaction in one of the two applications.
Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
第13题:
Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?()
第14题:
Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?()
第15题:
To enhance the availability of an application running under HACMP, a decision was made to use The application monitoring facility. The application consists of several components and can take several minutes to initialize. The components use socket communication and can be initialized in any order as long as it is a serial order. The customer’s concern is that if the application stop and start scripts are used during application monitoring recovery,it may take an extraordinary length of time to reset all of the application components. What can be done to ensure the best recover time?()
第16题:
Your network consists of a single Active Directory domain. The network contains a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has an application that runs as a service. The application uses a domain service account to access other servers in the domain. Security policies require that users reset their passwords every 30 days. After the application runs for a month, the application fails.You need to ensure that the application starts and can access the remote servers. What should you do?()
第17题:
You develop a Windows Communication Foundation (WCF) service. It is used exclusively as an intranet application and is currently unsecured. You need to ensure that the service meets the following requirements: The service now must be exposed as an Internet application. The service must be secured at the transport level. Impersonation and delegation cannot be enabled. What should you use? ()
第18题:
Use a process monitor that restarts the named processes in the original start order.
Use the defined application start and stop scripts to control the application if there is a failure.
Use multiple application monitors for this resource group to enable the monitoring of the specific components of the resource group.
Use application cleanup and restart scripts designed to determine the state of the various components of the application and start only the parts required.
第19题:
In the Services snap-in, set the service to log on as the Local System account and start the service.
In the Services snap-in, set the service to log on as the Local Administrator account and start the service.
In Active Directory Users and Computers, reset the servers computer account. In the Services snap-in, start the service.
In Active Directory Users and Computers, set the Account Expires option to Never. In the Services snap-in, start the service.
第20题:
On the OperationContractAttribute, set the AsyncPattern property value to true.
On the OperationContractAttribute, set the ReplyAction property value to the endpoint address of the client.
On the client, create a proxy derived from DuplexClientBase<TChannel >.
On the client, use GetCallbackChannel<T >.
第21题:
Deploy the application tier and the business tier to one role with two Medium instances.
Deploy the application tier and the business tier to one role with two Large instances.
Deploy the application tier role to a Medium instance. Deploy the business tier role to a medium instance.
Deploy the application tier role to a Large instance. Deploy the business tier role to a Large instance.
第22题:
A
B
C
D
第23题:
basicHttpBinding and HTTP
basicHttpBinding and Kerberos
wsHttpBinding and Kerberos
wsHttpBinding and HTTPS
第24题:
An application process acquires at least a share lock on the current row of every cursor.
Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.
Any row changed by another application process can be read, even if the change has not been committed by that application process.
An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.