What is the retriction on using UNION in embedde

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the retriction on using UNION in embedded SQL?

It has to be in a CURSOR.

(Continued on next question...)

Other Job Interview Questions

• What is minimum authority required for one to create a tablespace?
• Can one add columns to a table after it has been defined?
• How do you select a row using indexes?
• What is the use of VALUE function?
• What is normalization and what are the five normal forms?
• What is meant by locking?
• What is the meaning of underscore ...
• What is an index key?
• What are the wildcard characters ?
• What is meant by locking?
• More...