Python Data Access MCQs

Question 1: The character * is used in ________.

• SELECT query
• Insert Query
• Delete query
• All of the above

Check Answer

Question 2: Python DB-API

• Is a Python module
• Specification for database connectivity modules
• is used to access SQLite database
• None of these

Check Answer

Question 3: What is a cursor in the context of database programming?

• It is an indicator showing the current position for user interaction on a computer monitor.
• It acts as a handle for a given SQL query using which records are traversed.
• It stores the list of rows in a table.
• None of these

Check Answer

Question 4: Which of the following statements is true about connect() function

• Creates a new database or opens the existing database
• Is Function in SQLite3 module
• Returns connection object
• All of above

Check Answer

Question 5: Commit() method should be executed to

• Finalize transactions
• Close database
• Close table
• Refresh data after execution of the query

Check Answer