1.
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?
2.
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?
3.
Which of the following is NOT true about XML columns?
4.
Which of the following actions may cause a trigger to be fired?
5.
If an application issues the same query more than once in the same unit of work, which isolation level will not permit this application to see additional rows inserted by other applications?
6.
What is the maximum size that can be specified when creating an XML column in a DB2 table?
7.
Which of the following DB2 data types has a fixed length?
8.
Which of the following will DELETE all of the rows from the table T03?
9.
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?
10.
Which of the following is a typical data warehouse query?