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?（）A、Application B will read the row.B、Applications A and B will cause a d

题目

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?（）

A、Application B will read the row.
B、Applications A and B will cause a deadlock situation.
C、Application B will wait until application A releases the Update lock.
D、Application A will be terminated so that application B can read the row.

更多“Application A holds an Update lo”相关问题

第1题

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?（） A、The database manager will rollback the transaction in both applications.B、The database manager will rollback the transaction in one of the two applications.C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

点击查看答案
第2题

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?（）A、Code the application to issue a LOCK TABLE statement. B、Code the application to issue a LOCK ROW statement. C、Decrease the number of I/O servers. D、Increase the locklist parameter.

点击查看答案
第3题

A customer is developing a custom application that involves a multistep provisioning process for a new account. There is a custom Java client application that is generating multiple JMS messages as part of the process and sending them to the WebLogic tier where they are processed. Which three steps must you take to implement the solution to allow for scalability and parallel processing of multiple simultaneous provisioning requests while ensuring messages for an individual process are not delivered out of order?（）A、Update the client application that is creating the JMS messages to use Unit of Work.B、Configure a WebLogic Cluster for Distributed JMS.C、Update the client application that is creating the JMS messages to use Unit of Order.D、Enable XA Transactions on the JMS Connection Factory used by the client application.E、Enable Load Balancing on the JMS connection factory used by the client application.

点击查看答案
第4题

Your company uses Windows Update to download and install security updates on client computers. When Microsoft releases a security update， you have the following requirements： Establish which client computers require the security update. Identify what changes will occur as a result of the security update. Identify which applications might be affected by the security update. You need to select the appropriate tool to detect application-compatibility issues. What should you do？（）A、Use the Inventory Collector.B、Use the Setup Analysis Tool.C、Use the Update Compatibility Evaluator.D、Use the Windows Compatibility Evaluator.

点击查看答案
第5题

Your virtual environment includes Windows Server 2008 R2 Hyper-V servers. You manage the environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You are planning to install an application upgrade. Testing the production application requires access to the following three virtual machines （VMs）： a domain controller， a server that runs Microsoft SQL Server， and an IIS Web server. You need to test the application upgrade in a virtual environment that is isolated from the production network. Which two sets of actions should your plan include？（）A、Import the checkpoint into the test environment， and apply the application update for testingB、Create a checkpoint of the three VMs， and export the checkpoint to the test environmentC、Create three VMs in the test environment， attach the existing .vhd files， and apply the application update for testingD、Pause the three VMs， and copy the .vhd files to the test environment

点击查看答案
第6题

You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed. What should you do?（）A、In Event Viewer， examine the Application log.B、In Windows Update， examine the update history.C、At the command prompt， run Wusa.exe and specify the /kb parameter.D、At the command prompt， run Verifier.exe and specify the /query parameter.

点击查看答案
第7题

单选题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?（）A Application B will read the row.B Applications A and B will cause a deadlock situation.C Application B will wait until application A releases the Update lock.D Application A will be terminated so that application B can read the row.

点击查看答案

Application A holds an Update lo

题目

更多“Application A holds an Update lo”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容