Select the true statements about the sqlite3 module. (Choose two.)

Question

Options

• AThe fetchall method returns None when no rows are available.
• BThe execute method allows you to perform several queries at once.
• CThe execute method is provided by the Cursor class This statement is true because the
• DThe fetchone method returns None when no rows are available This statement is true because

• A
  3% (2)
• B
  4% (3)
• C
  93% (64)

Explanation

execute method is one of the methods of the Cursor class in the sqlite3 module. The Cursor class represents an object that can execute SQL statements and fetch results from a database connection. The execute method takes an SQL query as an argument and executes it against the database. For example, cur = conn.cursor (); cur.execute ("SELECT * FROM table") creates and executes a cursor object that selects all rows from a table. the fetchone method is another method of the Cursor class in the sqlite3 module. The fetchone method fetches the next row of a query result set and returns it as a single tuple or None if no more rows are available. For example, row = cur.fetchone () fetches and returns one row from the cursor object or None if there are no more rows.

No community discussion yet for this question.