How can you quickly find out the # of rows updat

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

(Continued from previous question...)

How can you quickly find out the # of rows updated after an update statement?

Check the value stored in SQLERRD(3).

(Continued on next question...)

Other Job Interview Questions

• What is a synonym ?
• Can you use MAX on a CHAR column?
• What is the meaning of underscore ( ‘_’ ) in the LIKE statement? –
• What does WITH HOLD option do ?
• When you COMMIT, is the cursor closed? - drona questions–
• A VARCHAR column REMARKS would be defined as follows:
• What is UNION,UNION ALL? –
• What is a synonym ?
• What is a synonym? How is it used?
• Can I use LOCK TABLE on a view?
• More...