[单选]
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.

TSM实现LAN-Free方式需要购买如下那个TSM 组件（） TSM for SAN。 TSM for Mail。 TSM for Database。黄油枪是加注（）的工具。燃料油。导热油。润滑油。机油。 An administrator is moving a volume group from one server to another. The disks will be physically moved between the two systems. Which two operations are required on the volume group prior to the physical disk switch?（） 'varyoffvg' and 'exportvg'。 'varyofflv' and 'importvg'。 'varyofflv' and 'migratepv'。 'varyoffvg' and 'migratevg'。 TS3310物理带库最多支持396个磁带槽位，最多18个驱动器，这个说法是否正确？某河道工程项目法人按照《水利水电工程标准施工招标文件》（2009年版）编制了施工招标文件，招标文件规定不允许联合体投标。某投标人递交的投标文件由投标函及附录、授权委托书（含法定代表人证明文件）、投标保证金、项目管理机构、施工组织设计、资格审查资料、拟分包情况表、已标价工程量清单组成。投标文件拟将渠道混凝土砌块衬砌项目分包，填报了拟分包情况表。经评标委员会评审，该投标人中标，并签订合同。施工期第一个月完成的项目和工程量（或费用）如下：（1）80m<sup>3</sup>/h挖泥船施工，河道疏浚（5km，断面积48m2）；（2）施工期自然回淤清除（断面积2m2）；（3）河道疏浚超挖断面积（4m2）；（4）排泥管安装拆除，费用10万元；（5）开工展布，费用4万元；（6）施工辅助工程，包括浚前扫床和障碍物清除及其他辅助工程，费用50万元。根据《关于建立水利建设工程安全生产条件市场准入制度的通知》（水建管[2005]80号），投标文件中资格审查资料须提供的企业和人员证书有哪些？

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

参考答案：

● 参考解析

本题暂无解析

当前位置：IBM(000-730)题库

相关题目: