Ans -  Smallint
             Integer
             DECIMAL
             FLOAT
             Character,Varcharacter
             Graphic,Vargraphic
             Date
             Time
             Timestamp

Q2 -  What is a view ? What are the advantages and restrictions of using a view ?

Ans -  A view is a virtual table derived from one or more base tables. It prevents unauthorized users from having access to sensitive data. Cannot insert, delete or update a view, which is based on more than one base table.

Q3 - What do you mean by referential Integrity?

 Ans -  Referential integrity is a condition wherein all references from one table to another are valid. It is the enforcement of all referential constraints(a rule that the value of a foreign key must appear as the value of a primary key of some other specific table.)

Q4 -  What is a Subquery ?

Ans -  A subquery is a query that is written as part of another query's WHERE clause.

Q5 - What is corrleated subquery ?

Ans - A correlated subquery is one that has a correlation name as a table or view designator in the FROM clause of the outer query and the same correlation name as qualifier of a search condition in the WHERE clause of the subquery.

Q6 - How does the processing of correlated subquery differ from a noncorrelated ?

Ans - The subquery in a correlated subquery is reevaluated for every row of the table or view named on the outer query, while the subquery Of a noncorrelated subquery is evaluated only once.

Q7 - What is DB2 bind ?

Ans - A bind is a process that builds 'access paths' to DB2 tables. A bind uses the Database Request module(s) from the DB2 precompile step as input and produces an application plan. It also checks the user's authority and validates the SQL Statements in the DBRM.

Q8 - What is a plan?

Ans - A plan in db2 produced during the bind process. One or more database request modules with a plan name.

Q9 - What is a synonym? How is it used?

Ans - A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities when the code is migrated.The synonym is linked to the AUTHID that created it.

Ans - An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.