Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

• A.Sequence
• B.Row Identifier
• C.Identity Column
• D.Insert time clustering table

Comment: *

Name: *

Email: *

Verification: *

The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?

• A.SYSCAT.USER_TAB_PRIVS
• B.SYSIBMADM.PRIVILEGES
• C.SYSIBMADM.GRANTS
• D.SYSCAT.DBAUTH

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

• A.View
• B.Alias
• C.Table
• D.Schema

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

• A.No other applications can access the table
• B.Only uncommitted read (UR) applications can access the table
• C.The lock owner and other applications can read, but not update, the locked table
• D.The lock owner can both read and update data. Other applications can read the table
• E.This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Comment: *

Name: *

Email: *

Verification: *