What is read-only cursor?

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

(Continued from previous question...)

What is read-only cursor?

A read-only cursor is one in which the result table was created by a query containing one of the following:
. DISTINCT keyword
. UNION operator
. column or scalar function
. GROUP bY clause
. ORDER BY clause
. HAVING clause
. read-only view in the FROM clause
. FROM clause identifying more than one table or view

(Continued on next question...)

Other Job Interview Questions

• EXPLAN has output with MATCHCOLS ...
• What is dynamic SQL?
• What is a recovery log?
• What are the three tyes of page locks that can be held?
• What is a thread?
• How is the SUBSTR keyword used in SQL?
• What are some SQL aggregates and other built-in functions?
• What is the COBOL picture clause of the following DB2 data types?
• How does DB2 store NULL physically?
• What is ALTER?
• More...