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?

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?

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

In what form is data physically stored in DB2

When can you not drop a database

Can you use MAX on a CHAR column?

Which eliminates all but one of each set of repeated rows in the final result table?

What is a stored procedure?

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

What is a host structure?

What is SQLCA used for?