Which of the following statements eliminates all but one of each set of repeated rows inthe final result table?

A role is a database entity that groups together one or more privileges. Which of the following is true for a 'role'

A declared temporary table is used for which of the following purposes?

What type of SQL operator would you use to combine the results of 2 Select statements while retaining the duplicates

Which occurs if a DB2 procedure or application ends abnormally during an active unit of work?

Which is an example of a programming method not used in DB2 programming?

Any database needs to go through a normalization process to make sure that data is represented only once. This will eliminate problems with creating or destroying data in the database. The normalization process is done usually in three steps which results in first, second and third normal forms. Which best describes the process to obtain the third normal form?

Which of the following is not a type of dynamic SQL?

When using JBDC, do you have to recode your Java application if you want to change between drivers?

Which represents a function that is performed for each row in a DB2 table

Which is an example of a column that would contain statistics necessary for programming?