A. BLOB
B. DOUBLE
C. XML
D. DBCLOB
A. ROLLBACK
B. DROP
C. ALTER
D. DELETE
A. A sequence will never generate duplicate values.
B. The MAXVALUE of a sequence can be equal to the MINVALUE.
C. It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero.
D. When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries.
A. Projected
B. Historical
C. Current
D. Current and projected
A. An error will occur.
B. User IDs and passwords are passed to the server unencrypted.
C. User IDs and passwords are encrypted before they are passed to the server.
D. Data passed between the client and the server is encrypted.
A. To configure clients so they can access databases stored on remote servers
B. To replicate data between a DB2 database and another relational database
C. To present a graphical representation of a data access plan and recommend design changes that will improve performance
D. To analyze workloads and make recommendations for indexes and MQTs
A. Performance Advisor
B. Design Advisor
C. Configuration Assistant
D. Visual Explain
A. Restrict users' access to a subset of table data
B. Provide users with an alternate view of table data
C. Ensure that rows inserted remain within the scope of a definition
D. Produce an action as a result of a change to a table
