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

Which method of cursor class is used to fetch limited rows from the table?

(A) cursor.fetchsize(SIZE)

(B) cursor.fetchmany(SIZE)

(C) cursor.fetchall(SIZE)

(D) cursor.fetchonly(SIZE)

Answer:

Checking the options

• (A) cursor.fetchsize(SIZE) - It is not a method of cursor class.
• (B) cursor.fetchmany(SIZE) - It returns the number of rows specified by the size argument.
• (C) cursor.fetchall(SIZE) - It returns all the rows of a query result.   
• (D) cursor.fetchonly(SIZE) - It is not a method of cursor class.

From the options given above, the function cursor.fetchmany(SIZE) is used to fetch limited rows from the table.

So, the correct answer is (B)