Question 2 - Case Based MCQ Questions - Chapter 15 - Interface of Python with SQL Database

Transcript

Case Base Question 2 Consider the following table STUDENT: Question 2 (i) Option A What will be the query statement to insert a new record with Student id = 1107, name = Sumit Saxena, Course = BBA and result = passed (A) sql = “INSERT INTO student (stuid, name, course, result) VALUES (‘1107’, ‘Sumit Saxena’, ‘BBA’,‘Passed’)” (B) sql = “INSERT INTO student VALUES (‘1107’, ‘Sumit Saxena’, ‘BBA’, ‘Passed’)” (C) Both (a) and (b) (D) None of theseImports the required python module creating the cursor object for executing the queries The query assigned to the variable sql is executed All the rows affected by the previous query ie., to display all rows from the table, is assigned to the variable data Creates a connection between MySQL database & Python application The query to be executed is assigned to the variable sql Confirms changes made by user to the database Output Question 2 (i) Option B What will be the query statement to insert a new record with Student id = 1107, name = Sumit Saxena, Course = BBA and result = passed (A) sql = “INSERT INTO student (stuid, name, course, result) VALUES (‘1107’, ‘Sumit Saxena’, ‘BBA’,‘Passed’)” (B) sql = “INSERT INTO student VALUES (‘1107’, ‘Sumit Saxena’, ‘BBA’, ‘Passed’)” (C) Both (a) and (b) (D) None of theseImports the required python module creating the cursor object for executing the queries The query assigned to the variable sql is executed All the rows affected by the previous query ie., to display all rows from the table, is assigned to the variable data Creates a connection between MySQL database & Python application The query to be executed is assigned to the variable sql Confirms changes made by user to the database Output Question 2 (ii) The following sql command has been given: Sql = “UPDATE student SET result = ‘Passed’ WHERE course = ‘BCom’ ” The result of which of the following STUID will be changed to “Passed”? (A) 1101 (B) 1101, 1104 (C) 1101, 1105 (D) 1101, 1104, 1105 Imports the required python module Creating the cursor object for executing the query The query assigned to the variable sql is executed Creates a connection between the MySQL database and Python application The query to be executed is assigned to the variable sql Confirms the changes made by the user to the database Question 2 (iii) Consider the following code: sql = '''SELECT * from STUDENT'‘’ cursor.execute(sql) result = cursor.fetchone(); print(result) What will be output of above code in reference to the STUDENT table? (A) 1101, Anubhav Singh, BCom, Awaited (B) 1106, Sanchit Kumar, BCom, Passed (C) 1103, Kartikey Rana, BSc, Passed (D) Both (A) and (B) Imports the required python module Creating the cursor object for executing the query The query assigned to the variable sql is executed One row from the result set is fetched and assigned to the variable result Creates a connection between the MySQL database and Python application The query to be executed is assigned to the variable sql Prints the value stored in variable result Output Question 2 (iv) Consider the following code: result = cursor.fetchmany(2); print(result) What will be the result if it is executed after the code given in (iii)? (A) 1101, Anubhav Singh, BCom, Awaited 1102, Riya Sharma, BSc, Passed (B) 1102, Riya Sharma, BSc, Passed 1103, Kartikey Rana, BSc, Passed (C) 1103, Kartikey Rana, BSc, Passed 1104, Archana Kapoor, BBA, Awaited (D) None of these Imports the required python module Creating the cursor object for executing the query The query assigned to the variable sql is executed 1 row from the result set is fetched and the cursor positions moves to the beginning of the next row Creates a connection between the MySQL database and Python application The query to be executed is assigned to the variable sql 2 rows are fetched from the result set from the current position of the cursor and assigned to the variable result Output Question 2 (v) Consider the following code: cursor=db.cursor() query = "DELETE FROM student WHERE course = ‘BCom’ AND result = ‘Awaited’ “ cursor.execute(query) del_rows= cursor.rowcount print(del_rows) What will be the output of the above code? (A) 1 (B) 2 (C) 3 (D) 4 Imports the required python module Creating the cursor object for executing the query The query assigned to the variable sql is executed The number of rows affected by the execution of the query is assigned to the variable del_rows Creates a connection between the MySQL database and Python application The query to be executed is assigned to the variable sql Prints the value stored in variable result Output