Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

• A.UPDATE TERMINATE
• B.ROLLBACK WORK
• C.SAVEPOINT
• D.COMMIT

Comment: *

Name: *

Email: *

Verification: *

Which of the following is fundamental to BLU acceleration?

• A.pureScale
• B.Column organized tables
• C.Multidimensional clustering
• D.Purchasing new hardware that is compatible with BLU acceleration and compression

Comment: *

Name: *

Email: *

Verification: *

The creator of an index or an index specification automatically receives which privilege on the index?

• A.SELECT
• B.DELETE
• C.UPDATE
• D.CONTROL

Comment: *

Name: *

Email: *

Verification: *

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

• A.Advanced Enterprise Server Edition
• B.DB2 Direct Advanced Edition
• C.Direct Standard Edition
• D.Workgroup Server Edition
• E.Enterprise Server Edition

Comment: *

Name: *

Email: *

Verification: *

Which of the following set operators can be used to find all rows that are common in 2 queries?

• A.UNION
• B.EXCEPT ALL
• C.INTERSECT ALL
• D.UNION ALL

Comment: *

Name: *

Email: *

Verification: *