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

Popularity: unranked [?]

Related interview questions

• When is the results table for the query in a DECLARE CURSOR statement created?
• What is cursor stability?
• What is meant by a repeatable read?
• when does the sql statement gets executed when you use cursor in the application programming ?
• Interview Questions DB2 : Part – I