1) How would you find out the total number of rows in a table? A. Use SELECT COUNT(*) … Allstate uses DB2v6. and QMF V3.3. 2) How do you eliminate duplicate values in SELECT? A. Use SELECT DISTINCT … 3) How do you select a row using indexes? A. Specify the indexed columns in the WHERE clause. 4) Can you use … Continue reading 20 Top DB2 Frequently Asked Questions