What is the restriction on using UNION in embedded SQL?

Why is SELECT * not preferred in embedded SQL programs?

When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set.

How would you find out the total number of rows in a DB2 table?

What is the use of FREE command?

What are correlated subqueries?

What is a lightweight web application created from multiple sources?

Which of the following can be accomplished with a single UPDATE statement?

When coding in a language that requires a host variable declaration, what must precede it?

What is the name of the effect when a system continues to receive work, but is down?

Consider the following: DECLARE MYCURS CURSOR FOR SELECT * FROM MYTABLE WHERE COL1 > :NUM Which of the following embedded SQL statements will NOT generate an error?