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 is the difference between QMF & SPUFI?

What is the restriction on using UNION in embedded SQL?

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?

Why would you receive a command response of NORMAL when the attachment facility is not available?

Which statement about an index is NOT true?