What is a result table ?

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

(Continued from previous question...)

What is a result table ?

A result table is the product of a query against one or more tables or views (i.e. it is the place that holds the results of a query).

(Continued on next question...)

Other Job Interview Questions

• What is the syntax of SELECT statement when embedded in a COBOL program ?
• Explain the use of the WHERE clause?
• What is a clustering index ?
• What is QUIESCE ?
• What is the difference between join and union ?
• Name some of field from SQLCA?
• What is an inner join, and an outer join?
• Give some example of statistics collected during RUNSTATS?
• When can you be sure that a quary will return onlyl one row ?
• Why use RUNSTAT Utility?
• More...