Question 1

Question 10Which command is used for cleaning up the environment?my.closed()is.end()con.quit()mycon.close()

Accepted Answer

mycon.close()Reason — The mycon.close() command is used for cleaning up the environment by closing the database connection.

Source: This question is from Interface Python with SQL, Computer Science &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Interface Python with SQL: Question, Command, Cleaning, Environment, Closed, End. These are fundamental topics in Computer Science that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Science papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach MCQsMultiple choice questions test your ability to quickly recall facts and apply concepts. Read all options carefully before selecting your answer. Use the process of elimination to rule out clearly incorrect options first. If two options seem similar, look for the subtle difference that makes one more accurate. For numerical MCQs, verify your answer by substituting it back into the problem.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Interface Python with SQLQ1: Question 1 Explain the following &#x27;results&#x27; retrieval methods with examples. (a) fetchone() (b)...
Q11: Question 11 Write a program to display all records in ascending order of their salary from table...
Q12: Question 12 Write a program to increase salary of the employee, whose name is "MANOJ KUMAR", by...
Q13: Question 13 Write a program to delete the employee record whose name is read from keyboard at...
Q14: Question 14 Create a database TESTDB.
Practice more questions from Interface Python with SQL &mdash; Computer Science, Class 12 CBSE

Question 2

Question 1Explain the following 'results' retrieval methods with examples.(a) fetchone()(b) rowcount(c) fetchall()

Accepted Answer

(a) fetchone() — It fetches one row from the result set in the form of a tuple or a list. This function will return one record from the result set, i.e., first time it will return the first record, next time it will return the second record and so on. If no more record is left in the table, it will return None.Example:Let us consider the table student:StudentNo.ClassNameGAMEGrade1SUPWGrade2107SameerCricketBPhotographyA118SujitTennisAGardeningC127KamalSwimmingBPhotographyB137VeenaTennisCCookingA149ArchanaBasket BallALiteratureA1510ArpitCricketAGardeningCimport mysql.connector
mydb = mysql.connector.connect(host = "localhost", user = "root", passwd = "tiger", database = "School")
mycursor = mydb.cursor()
mycursor.execute("select * from student")
myrecords = mycursor.fetchone()
print(myrecords)Output(10, 7, 'Sameer', 'Cricket', 'B', 'Photography', 'A')
(b) rowcount — This is read-only attribute and returns the number of rows that were affected by an execute() method and retrieved from the cursor.Example:import mysql.connector
mydb = mysql.connector.connect(host = "localhost", user = "root", passwd = "tiger", database = "School")
mycursor = mydb.cursor()
mycursor.execute("select * from student")
myrecords = mycursor.fetchone()
affected_rows = mycursor.rowcount
print("Number of affected rows: ", affected_rows)OutputNumber of affected rows:  1
(c) fetchall() — It fetches all the rows in a result set and returns a list of tuples. If some rows have already been extracted from the result set, then it retrieves the remaining rows from the result set. If no more rows are available, it returns an empty list.Example:import mysql.connector
mydb = mysql.connector.connect(host = "localhost", user = "root", passwd = "tiger", database = "School")
mycursor = mydb.cursor()
mycursor.execute("select * from student")
myrecords = mycursor.fetchall()
for x in myrecords:
    print(x)Output(11, 8, 'Sujit', 'Tennis', 'A', 'Gardening', 'C')
(12, 7, 'Kamal', 'Swimming', 'B', 'Photography', 'B')
(13, 7, 'Veena', 'Tennis', 'C', 'Cooking', 'A')
(14, 9, 'Archana', 'Basket Ball', 'A', 'Literature', 'A')
(15, 10, 'Arpit', 'Cricket', 'A', 'Gardening', 'C')

Question 3

Question 2What is the significance of connecting Python with MySQL?

Accepted Answer

Python is a flexible, portable, easy to learn and modifiable language. So, we are integrating MySQL with Python interface for executing any database applications. The various reasons to use Python for programming database applications are:Programming in Python is arguably more efficient and faster as compared to other languages.Python is known for its portability.It is platform-independent.Python supports SQL cursors that allows executing SQL queries and processing the results.In many programming languages, the application developer needs to take care of the open and closed connections of the database to avoid further exceptions and errors. In Python, these connections are taken care of.Python supports relational database management systems.Python database APIs are compatible with various databases, so it is very easy to migrate and port database application interfaces.

Question 4

Question 3Why do we use connect() function?

Accepted Answer

The connect() function is used to establish a connection to the MySQL database from a Python application. It returns a MySQLConnection object, which we can then use to perform various operations on the MySQL database.

Question 5

Question 4Explain the steps for establishing MySQL connection with Python.

Accepted Answer

The steps for establishing MySQL connection with Python are as follows:Step 1 — To connect Python to MySQL, we need to install mysql-connector using 'pip' command on the command prompt (cmd). Do ensure that MySQL-connector is installed in the same folder as Python.Step 2 — Once the path is set, type the command as — python -m pip install mysql-connector or pip install mysql-connector-python. MySQL shall download and will be installed on our system. Now, we need to check whether it has been properly installed or not.Step 3 — To do this, type import mysql.connector in Python shell. If no error message gets displayed, this signifies that driver has been successfully installed.Step 4 — The next step to using MySQL in Python scripts is to make a connection to the database. All Python DB-API modules implement a function: conn = module_name.connect(host = "localhost", user = "root", passwd = "password", database = "database_name").Step 5 — Once the connection is established, create a cursor object using the cursor() method of the connection object, mycursor = conn.cursor().Step 6 — We can now execute SQL queries using the execute() method of the cursor object, mycursor.execute("SHOW DATABASES")Step 7 — If our query retrieves data, we can fetch the results using methods like fetchone(), fetchall(), or fetchmany() on the cursor object.Step 8 — If we make any changes to the database, then commit those changes using commit() on the connection object, conn.commit(). Finally, close the connection, mycursor.close().

Question 6

Question 5Explain the transaction keywords used with MySQL-Python connectivity.

Accepted Answer

The transaction keywords used with MySQL-Python connectivity are as follows:commit — The COMMIT keyword is used to permanently apply the changes made during a transaction to the database. The MySQLConnection.commit() method sends a COMMIT statement to the MySQL server, finalizing and committing the current transaction. It's important to commit transactions only when all operations within the transaction have been successfully completed and verified.rollback — The ROLLBACK keyword is used to undo or revert changes made during a transaction. When a transaction fails to execute and we want to revert all the changes, the MySQLConnection.rollback() method can be used to revert the changes.autocommit — The MySQLConnection.autocommit value can be assigned as True or False to enable or disable the auto-commit feature of MySQL. By default, its value is False. This feature controls whether each SQL statement is automatically committed as a separate transaction or if manual transaction control is required.

Question 7

Question 6Give the significance of using execute() function.

Accepted Answer

The execute() function is significant for executing SQL queries and commands. It enables us to send SQL statements to the database and perform various operations such as creating, inserting, updating, and deleting data.

Question 8

Question 7Differentiate between commit() and rollback() statements.

Accepted Answer

commit() statementrollback() statementThe commit() method is used to permanently save the changes made during a transaction to the database.The rollback() method is used to undo or revert the changes made by a transaction.The syntax is: connection.commit().The syntax is: connection.rollback().

Question 9

Question 11Write a program to display all records in ascending order of their salary from table employee.

Accepted Answer

Table Employee:EMPNOENAMEDEPTSALARY1RAJESHIT600002MANOJ KUMARHISTORY650003ANUSHAMARKETING700004ABHAYFASHION STUDIES45000import mysql.connector
mydb = mysql.connector.connect(host = "localhost",
                                user = "root",
                                passwd = "tiger",
                                database = "School")
mycursor = mydb.cursor()
mycursor.execute("select * FROM EMPLOYEE ORDER BY SALARY")
myrecords = mycursor.fetchall()
for row in myrecords:
    print(row)
mycursor.close()    
mydb.close()Output(4, 'ABHAY', 'FASHION STUDIES', 45000.0)
(1, 'RAJESH', 'IT', 60000.0)
(2, 'MANOJ KUMAR', 'HISTORY', 65000.0)
(3, 'ANUSHA', 'MARKETING', 70000.0)

Question 10

Question 12Write a program to increase salary of the employee, whose name is "MANOJ KUMAR", by 3000.

Accepted Answer

import mysql.connector
mydb = mysql.connector.connect(host = "localhost",
                                user = "root",
                                passwd = "tiger",
                                database = "School")
mycursor = mydb.cursor()
mycursor.execute("UPDATE employee SET salary = salary + 3000 WHERE Ename = 'MANOJ KUMAR'")
mydb.commit()

Question 11

Question 13Write a program to delete the employee record whose name is read from keyboard at execution time.

Accepted Answer

import mysql.connector
mydb = mysql.connector.connect(host = "localhost",
                                user = "root",
                                passwd = "tiger",
                                database = "School")
mycursor = mydb.cursor()
employee_name = input("Enter the name of the employee to delete: ")
mycursor.execute("DELETE FROM employee WHERE ENAME = %s", (employee_name,))
print(mycursor.rowcount, "Record Deleted")OutputEnter the name of the employee to delete: RAJESH
1 Record Deleted

Question 12

Question 14Create a database TESTDB.

Accepted Answer

import mysql.connector
conn = mysql.connector.connect(host = 'localhost', 
                                user = 'root', 
                                passwd = 'tiger')
cursor = conn.cursor()
cursor.execute("CREATE DATABASE TESTDB")
conn.commit()
conn.close()

Question 13

Question 15Create a table EMPLOYEE with Fields FIRST_NAME, LAST_NAME, AGE, GENDER and INCOME.

Accepted Answer

import mysql.connector
mydb = mysql.connector.connect(host = 'localhost', 
                               user = 'root', 
                               passwd = 'tiger', 
                               database = "kboat_cbse_12")
mycursor = mydb.cursor()
mycursor.execute("CREATE table EMPLOYEE (FIRST_NAME VARCHAR(45), 
                LAST_NAME VARCHAR(45), 
                AGE INTEGER, 
                GENDER VARCHAR(10), 
                INCOME FLOAT)")
mydb.commit()
mycursor.close()
mydb.close()

Question 14

Question 8fetchone() fetches the next row of a query result set.

Accepted Answer

TrueReason — The fetchone() method fetches only one row from the result set in the form of a tuple or a list. This function returns one record from the result set each time it is called. The first call will return the first record, the next call will return the second record, and so on.

Question 15

Question 9DB-API is the standard for Python's database interface.

Accepted Answer

TrueReason — The DB-API (Database Application Programming Interface) is the standard for Python's database interface.

Source: This question is from Interface Python with SQL, Computer Science &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Interface Python with SQL: Question, Api, Standard, Python&#x27;s, Database, Interface. These are fundamental topics in Computer Science that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Computer Science papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberWrite programs with proper indentation and comments.
Trace through your code with sample inputs to verify correctness.
Explain the logic behind each step of your solution.
Familiarise yourself with common library functions and methods.
Related Questions from Interface Python with SQLQ1: Question 1 Explain the following &#x27;results&#x27; retrieval methods with examples. (a) fetchone() (b)...
Q11: Question 11 Write a program to display all records in ascending order of their salary from table...
Q12: Question 12 Write a program to increase salary of the employee, whose name is "MANOJ KUMAR", by...
Q13: Question 13 Write a program to delete the employee record whose name is read from keyboard at...
Q14: Question 14 Create a database TESTDB.
Practice more questions from Interface Python with SQL &mdash; Computer Science, Class 12 CBSE

Interface Python with SQL

Multiple Choice Questions

Solutions To Unsolved Questions

State True Or False