Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain subsets of the data?

What is a stored procedure?

Which eliminates all but one of each set of repeated rows in the 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

Besides on TABLE and TABLESPACE level, on what level can implicit locks be placed by DB2?

Consider the following embedded SQL statement: SELECT CLASSNAME INTO :CLASSNAME:IND FROM CLASS WHERE STUDNAME = :STUDNAME In which order should the following program variables be evaluated by the part of the program just after this SQL statement?

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?