Check sibling questions

Which of the following method reflects the changes made in database permanently?

(A) <connection>.done()

(B) <connection>.final

(C) <connection>.reflect()

(D) <connection>.commit()

 

Answer:

The commit( ) method in python is used to confirm the changes made by the user to a database.

Checking the options

  • (A) <connection>.done( ) - It is not a valid method used to reflect changes made in the database permanently.  
  • (B) <connection>.final( ) -  It is not a valid method used to reflect changes made in the database permanently.    
  • (C) <connection>.reflect( ) -  It is not a valid method used to reflect changes made in the database permanently.    
  • (D) <connection>.commit( ) -  This method used to reflect changes made in the database permanently .  

So, the correct answer is (D)

  1. Computer Science - Class 12
  2. Chapter 15 - Interface of Python with SQL Database

About the Author

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo