If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）

相似题目

• An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?（）

  A . GRAPHIC B . BINARY C . IMAGE D . BLOB

  查看最佳答案

• Which of the following actions should be taken if during a routine maintenance inspection of a centrifugal pump, localized scoring on a pump shaft sleeve is detected?（）

  A . Correct the cause of the scoring and repair the sleeve or replace with a new one B . Reassemble the unit and provide more water leak off for proper lubrication C . Check for parallel alignment of the sleeve radial faces to the sleeve bores D . Reassemble the unit and adjust the governor to obtain a slower speed

  查看最佳答案

• Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）

  A . DB2 Express Edition B . DB2 Personal Edition C . DB2 Workgroup Server Edition D . DB2 Enterprise Server Editio

  查看最佳答案

• Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）

  A . The cursor is only protected from updates and deletes by concurrent applications. B . The row is only protected from positioned updates and deletes that reference another cursor of the same application. C . The cursor is protected from positioned updates and deletes that reference another cursor of a different application. D . The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

  查看最佳答案

• Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）

  A . Visual Explain B . Activity Monitor C . SQL Performance Monitor D . DB2 Performance Monitor

  查看最佳答案

• A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

  A . Table B . Columns C . Table and Alias D . Columns and Alia

  查看最佳答案

• In a scale-out environment，what is a benefit of running DB2 pureScale compared to other solutions？（）

  A . Provides a highly available cluster of Power Systems enabling near linear scalability and disaster recovery across different sites. B . Incorporates a hardware locking mechanism which resembles the Parallel Sysplex on the mainframe， delivering performance and scalability. C . Enables near linear scalability by partitioning and clustering the database across multiple nodes， and adding nodes dynamically when needed. D . Provides scalability by employing a highly available cluster of servers interconnected by an Infiniband network and a central locking mechanism.

  查看最佳答案

• Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）

  A . examine the trace file and kill the session that caused the deadlock B . examine the trace file and kill both the sessions responsible for the deadlock C . examine the trace file for details and ask the user who caused the deadlock to roll back the transaction D . examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database E . examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

  查看最佳答案

• Once a fire is detected the engine should be slowed downOn no account （）.

  A . the trunking should be opened up B . should the trunking be opened up C . the trunking should not be opened up D . should the trunking not be opened u

  查看最佳答案

• Once a scavenge fire is detected the engine （）.

  A . will be speeded up B . should be slowed down C . must slow down D . have to be slow dow

  查看最佳答案

• Which space(s) on your cargo vessel must have a fire detection system?（）

  A . Any compartment containing explosives B . Any compartment adjacent to one containing explosives C . Enclosed spaces which are specially suitable for vehicles D . All of the above

  查看最佳答案

• How can rescue personnel detect that a SART is transmitting in the immediate vicinity?（）

  A . The SART's blips on the PPI will begin arcing and eventually become concentric circles B . The DSC unit will react to the SART's signal and respond with the two-tone alarm C . The SART can provide an approximate location to within a two nautical mile radius，per IMO standards D . The SART signal appears as a target which comes and goes; the effect of heavy swells on a SART

  查看最佳答案

• If you detect oil in the water around your vessel while discharging fuel, the FIRST thing to do is（）.

  A . try to find out where the oil is coming from B . call the Master C . have the pump man check the discharge piping D . shutdown operatio

  查看最佳答案

• Your alert log file has the following information： Tue May 25 17：43： 38 2004  ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）

  A . examine the trace file and kill the session that caused the deadlock B . examine the trace file and kill both the sessions responsible for the deadlock C . examine the trace file for details and ask the user who caused the deadlock to rollback the transaction D . examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database E . examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

  查看最佳答案

• A dirty diesel engine oil filter element can best be detected by （）.

  A . visual inspection of the elements B . the pressure drop across the filter C . high lube oil sump temperature D . decrease in oil viscosity from the filter

  查看最佳答案

• In restricted visibility, a vessel which detects by radar alone the presence of another vessel shall determine if a close quarters situation is developing or risk of collision exists. If so, she shall（）.

  A . sound the danger signal B . when taking action, make only course changes C . avoid altering course toward a vessel abaft the beam D . All of the above

  查看最佳答案

• When you enter the interface command auto qos voip cisco-phone on a port at the edge of a network,how does the Cisco Catalyst switch detect if a Cisco IP Phone is connected to the port?（）

  A . by snooping the CoS marking on the incoming frames B . by using RTP hello messages between the switch port and the Cisco IP Phone C . by using CDP D . by using DHCP snooping E . by snooping the incoming 802.1Q VLAN tag

  查看最佳答案

• Which fire detection system is actuated by sensing a heat rise in a compartment?（）

  A . Manual fire detection system B . Automatic fire detection system C . Smoke detection system D . Watchman's supervisory system

  查看最佳答案

• Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）

  A . CLOB B . BLOB C . Hierarchically D . Rows and colum

  查看最佳答案

• 以下哪只狗是人类的朋友？80db2f2f46a25b77c57454a126d21b90.jpgcc5c3901989e6fd4fa6785febbb746bf.jpg

  查看最佳答案

• “A Rose for Emily” could be called a “detective story.”

  正确 错误

  查看最佳答案

• In PTN wrapping ring network protection, when a node detects network failure, through

  A．A.MPLS B．B.OAM C．C.APM D．D.APS

  查看最佳答案

• Passage 1Its one of our common beliefs that mice are afraid of cats. Scientists have long known that even if a mouse has never seen a cat before, it is still able to detect chemical signals released f

  A、 mice s inborn terror of cats B、 the evolution of Toxoplasma C、 a new study about the effects of a parasite on mice D、 a harmful parasite called Toxoplasma gondii

  查看最佳答案

• 请阅读Passage l。完成第21—25小题。Passage 1Its one of our common beliefs that mice are afraid of cats. Scientists have long known that even if a mouse has never seen a cat before, it is still able to detect che

  A、Toxoplasma gondii causes people strange and deadly diseases. B、With certain infection the infectious disease cannot be cured completely. C、Human beings infected by toxoplasma gondii will have permanent brain damage. D、Toxoplasma gondii is harmful to human beings, but it does no harm to mice.

  查看最佳答案