单选题Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A Applications A and B will

题目

单选题

Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）

Applications A and B will cause a deadlock situation

Application B will read the previous version of the row

Application B will read the row and see uncommitted changes made by application A

Application B will be placed in a lock-wait state until application A releases its lock

更多“单选题Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A Applications A and B will”相关问题

第1题

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.

点击查看答案
第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题

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）A、null lock on the row being updatedB、null lock on the table containing the rowC、ROW SHARE lock for the row being updatedD、ROW EXCLUSIVE lock for the row being updatedE、shared row-exclusive lock for the row being updatedF、a shareable table lock for the table containing the rowG、exclusive table-level lock for the table containing the row

点击查看答案
第4题

You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5. You deploy the application on a Microsoft IIS 6.0 Web server. The server runs on a worker process isolation mode， and it hosts the .NET Framework version 1.1 Web applications. When you attempt to browse the application， the following error message is received： "It is not possible to run different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process." You need to ensure that the following requirements are met： all the applications run on the server all the applications remain in process isolation mode all the applications do not change their configuration. Which two actions should you perform？（）A、Create a new application pool and add the new application to the pool. B、Configure the IIS 6.0 to run the WWW service in the IIS 5.0 isolation mode. C、Configure the new application to use the .NET Framework version 2.0 in the IIS 6.0 Manager. D、Set autoConfig="false" on the property in the machine.config file. E、Disable the Recycle worker processes option in the Application Pool Properties dialog box.

点击查看答案
第5题

You create a Microsoft ASP.NET Web application by using the Microsoft .NET Framework version 3.5. You deploy the application on a Microsoft IIS 6.0 Web server. The server runs on a worker process isolation mode， and it hosts the .NET Framework version 1.1 Web applications. | English | Chinese | Japan | Korean | - 108 - Test Information Co.， Ltd. All rights reserved. When you attempt to browse the application， the following error message is received： "It is not possible to run different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process." You need to ensure that the following requirements are met： ¡；¤All the applications run on the server ¡；¤All the applications remain in process isolation mode ¡；¤All the applicatios do not change their configurations. Which two actions should you perform？（）A、Create a new application pool and add the new application to the pool.B、Configure the IIS 6.0 to run the WWW service in the IIS 5.0 isolation mode.C、Configure the new application to use the .NET Framework version 2.0 in the IIS 6.0 Manager. D、Set autoConfig="false" on the property in the machine.config file.E、Disable the Recycle worker processes option in the Application Pool Properties dialog box.

点击查看答案
第6题

You create Windows Forms applications by using the .NET Framework 3.5.You plan to deploy a new application.You need to ensure that on deployment， the application meets the following requirements：（1）It is executed on the client computer （2）It is removed from the client computer after the application is closed （3）It is not displayed in theAdd/Remove programs panel on the client computer What should you do？（）A、Deploy the application to a central network server.Access the application by using the Remote Desktop Connection tool.B、Deploy the application by using the ClickOnce technology.Use the Mage exe tool to set the Online Only option in the deployment manifest.C、Deploy the application by using the ClickOnce technology.Set the Install attribute of the deployment tag to true in the deployment manifest.D、Deploy the application to a CDROM by using the ClickOnce technology.Execute the application from the CDROM

点击查看答案
第7题

TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application. You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do？（）A、Trace the Lock：Timeout event by using SQL Server Profiler.B、Observe the SQLServer：Locks - Number of Deadlocks/sec counter by using System Monitor.C、Trace the Lock：Deadlock event by using SQL Server Profiler.D、Trace the Lock：Deadlock Chain event by using SQL Server Profiler.

点击查看答案

单选题Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A Applications A and B will

题目

更多“单选题Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?（）A Applications A and B will”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容