) Can you use MAX on a CHAR column

YES.

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are ...

How do you retrieve the first 5 characters of FIRSTNAME column of EMP table

SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name

SELECT FIRSTNAME ? ? LASTNAME FROM EMP;

What is the use of VALUE function

1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations 2. Substitute a numeric value for...

What is UNION,UNION ALL

UNION : eliminates duplicates
UNION ALL: retains duplicates Both these are used to combine the ...

What is the restriction on using UNION in embedded SQL

It has to be in a CURSOR.

In the WHERE clause what is BETWEEN and IN

BETWEEN supplies a range of values while IN supplies a list of values.

Is BETWEEN inclusive of the range values specified

Yes.

What is 'LIKE' used for in WHERE clause What are the wildcard characters

LIKE is used for partial string matches. ?%? ( for a string of any character ) and ?_? (for any sing...

When do you use a LIKE statement

To do partial search e.g. to search employee by name, you need not specify the complete name; using ...

What do you accomplish by GROUP BY ... HAVING clause

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HA...

Why SELECT * is not preferred in embedded SQL programs

For three reasons: If the table structure is changed ( a field is added ), the program will have to ...

What is a cursor why should it be used

Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a...

How would you retrieve rows from a DB2 table in embedded SQL

Either by using the single row SELECT statements, or by using the CURSOR. Apart from cursor, what ot...

Where would you specify the DECLARE CURSOR statement

See answer to next question.

How do you specify and use a cursor in a COBOL program

Use DECLARE CURSOR statement either in working storage or in procedure division(before open cursor),...

What happens when you say OPEN CURSOR

If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement....

Is DECLARE CURSOR executable

No.

Can you have more than one cursor open at any one time in a program

Yes.