What are the disadvantages of using VARCHAR?

How can you quickly find out the number of rows updated after an update statement?

Under which circumstance would you create an index on a table?

What is the statistics collected during RUNSTATS?

When will you use curser with hold option?

What is a thread?

What must a SELECT statement be coded within?

What's the output of a DB2 Bind

How many indexes will be created by the following statement? Create table Smarterer { Col1 int not null primary key, Col2 char (64), Col3 char (32), Col4 int not null, Constraint c4 unique (Col4,Col1) }

What are two examples of steps that must be taken before coding an application with embedded static or dynamic SQL statements?

Before executing SQL statements, you want to know whether the CICS attachment facility is available. How do you check?