How would you retrieve row from a DB2 table in e

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

(Continued from previous question...)

How would you retrieve row from a DB2 table in embedded SQL?

Either by using the single row SELECT statements, or by using the CURSOR.

(Continued on next question...)

Other Job Interview Questions

• Describe a primary key?
• What is UNION, UNION ALL?
• What are the wildcard characters ?
• What is meant by null?
• What authority is required to create a table?
• How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?
• What is a NULL value? What are the pros and cons of using NULLS ?
• What is the difference between static and dynamic SQL?
• What is a tuple?
• What is the difference between IN subselects and EXISTS subselect?
• More...