Question 4 - MCQ questions - Chapter 15 - Interface of Python with SQL Database

Which method of cursor class is used to get the number of rows affected after any of the insert/ update/delete database operation executed from Python?

(A) cursor.rowcount

(B) cursor.getaffectedcount

(C) cursor.rowscount

(D) cursor.rcount

Answer:

Checking the options

• (A) cursor.rowcount - It returns the number of rows affected by DML statements.  
• (B) cursor.getaffectedcount  - It is not a method of cursor class.
• (C) cursor.rowscount - It is not a method of cursor class.
• (D) cursor.rcount - It is not a method of cursor class.

From the options given above, the function cursor.rowcount is used to get the  number of rows affected after any of the insert/update/delete database operations executed from Python.

So, the correct answer is (A)