CMS专题
单选题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
题目
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.
相似问题和答案
第1题：
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）
A. A template needs to be associated with the task.
B.A workload needs to be associated with the task.
C. The partial or complete workload scope needs to be associated with the task.
D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
第2题：
When designing a PC, which of the following components would help a large application load theFASTEST?（）
- A、Solid state drive
- B、1 MB L2 cache memory
- C、High-end graphics card
- D、Dual core CPU
正确答案:A
第3题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）
A.
B.
C.
D.
第4题：
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）
- A、Task Center
- B、Command Editor
- C、Developer Workbench
- D、Command Line Processor
正确答案:B
第5题：
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 cause a deadlock situation
- B、Application B will read the previous version of the row
- C、Application B will read the row and see uncommitted changes made by application A
- D、Application B will be placed in a lock-wait state until application A releases its lock
正确答案:D
第6题：
You perform an in-place upgrade on a Microsoft Windows XP Service Pack 2 (SP2) computer to Windows Vista.After the upgrade, you attempt to run a custom application. You receive the following error message: This application is only designed to run on Windows XP or later.”You need to run the application on Windows Vista.What should you do?（）
A.A
B.B
C.C
D.D
第7题：
Which of the following servers would execute SQL？（）
- A、 Database Server
- B、 DNS Server
- C、 NAS Server
- D、 Web Server
正确答案:A
第8题：
You are working with a Windows Communication Foundation (WCF) client application that has a generated proxy named SampleServiceProxy.When the client application is executing, in line 04 of the following code, the channel faults (Line numbers are included for reference only.)01 SampleServiceProxy proxy = new SampleServiceProxy();02 try03 {04 proxy.ProcessInvoice(invoice);05 }06 catch07 {08 if(proxy.State == CommunicationState.Faulted)09 {10 ...11 }12 }13 proxy.UpdateCustomer(customer);You need to return proxy to a state in which it can successfully execute the call in line 13.Which code segment should you use at line 10?（）
A. proxy.Close();
B. proxy = new SampleServiceProxy();
C. proxy.Abort();
D. proxy.Open();
第9题：
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.
正确答案:B
第10题：
A step in the HACMP test plan is to gracefully stop the cluster on a node and to verify that the Shared resources fallover to the standby node. To prepare for this testing step， both nodes in the two-node cluster are in a stable state with the single resource group active on Node ’A’. Which of the following is the best way to execute this portion of the test plan？（）
- A、 Execute "lssrc -g cluster stop" on Node ’A’
- B、 Execute "cat /etc//motd >/dev/kmem" on Node ’A’
- C、 Execute "/usr/es/sbin/cluster/utilities/sclstop -gr" on Node ’A’
- D、 Find the pid of cluster manager daemon on Node ’A’ and issue a "kill-9" against the pid
正确答案:C