Free IBM A2090-730 Exam Dumps Questions & Answers

Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to 30 and both applications were started at the same time, what action will the deadlock detector take when it "wakes up" and discovers the deadlock?

• A.  It will randomly pick an application and rollback its current transaction
• B.  Itwill rollback the current transactions of both applications
• C.  It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock has not been resolved
• D.  It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an application and rollback its current transaction

Which two of the following statements are true about the HAVING clause?

• A.  The HAVING clause is used in place of the WHERE clause.
• B.  The HAVING clause uses the same syntax as the WHERE clause.
• C.  The HAVING clause uses the same syntax as the IN clause.
• D.  The HAVING clause accepts wildcards.
• E.  The HAVING clause can only be used with the GROUP BY clause.

A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?

• A.  Uncommitted changes made by other transactions can be seen from one scan to the next.
• B.  Rows added by other transactions that did not appear in one scan can be seen in subsequent scans.
• C.  Rows that have been updated can be changed by other transactions from one scan to the next.
• D.  Rows removed by other transactions that appeared in one scan will no longer appear in subsequent scans.

Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

• A.  CREATE DISTINCT TYPE currency AS DOUBLE
• B.  CREATE DISTINCT TYPE currency AS BIGINT
• C.  CREATE DISTINCT TYPE currency AS SMALLINT
• D.  CREATE DISTINCT TYPE currency ASNUMERIC(7,2)

Which of the following DB2 products are required on an iSeries or System I server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?

• A.  DB2 for i5/OS SQL Development Kit
• B.  DB2 Runtime Client
• C.  DB2 ConnectEnterprise Edition
• D.  DB2 for i5/OS