When writing a query with a primary key, how would the DISTINCT clause be applied?

Why would you want to specify an optimization class when compiling an SQL query?

Which is required to use the IMPORT utility to import data into a table?

On the client side, what is linked with the DB2 Universal Database client library?

When would phantom read phenomenon occur?

Which of the following are fields from SQLCA

Which COPY utility statements will backup table space DBTAB1.TS1 preparing 2 copies for local use and 2 copies for disater recovery use?

Which index type will cause the rows of the table to be arranged on the disk according to the ordering of their index keys?

Which function does QUIESCE perform?

What are segmented table spaces?

Can you use LOCK TABLE on a view?