{"id":4409,"date":"2024-02-14T12:41:35","date_gmt":"2024-02-14T07:11:35","guid":{"rendered":"https:\/\/cbsepython.in\/interface-of-python-with-sql-quiz-class-12\/"},"modified":"2024-02-19T22:48:49","modified_gmt":"2024-02-19T17:18:49","slug":"interface-of-python-with-sql-quiz-class-12","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/interface-of-python-with-sql-quiz-class-12\/","title":{"rendered":"Interface of python with SQL Quiz Class 12"},"content":{"rendered":"<h3>Interface of python with SQL Quiz Class 12<\/h3>\n<p>Here&#8217;s a 15-question quiz based on the topic &#8220;Interface of Python with an SQL Database: Connecting SQL with Python, Performing Insert, Update, Delete Queries Using Cursor, Display Data by Using <strong>connect()<\/strong>, <strong>cursor()<\/strong>, <strong>execute()<\/strong>, <strong>commit()<\/strong>, <strong>fetchone()<\/strong>, <strong>fetchall()<\/strong>, <strong>rowcount<\/strong>, Creating Database Connectivity Applications, Use of <strong>%s<\/strong> Format Specifier or <strong>format()<\/strong> to Perform Queries&#8221;<\/p>\n<div id=\"watu_quiz\" class=\"quiz-area single-page-quiz\">\n<form action=\"\" method=\"post\" class=\"quiz-form \" id=\"quiz-32\" >\n<div class='watu-question' id='question-1'><div class='question-content'><p><span class='watu_num'>1. <\/span>What does the connect() function do when working with Python and SQL databases?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='479' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2279' \/><div class='watu-question-choice'><input type='radio' name='answer-479[]' id='answer-id-2279' class='answer answer-1  answerof-479' value='2279' \/>&nbsp;<label for='answer-id-2279' id='answer-label-2279' class=' answer label-1'><span class='answer'>Connects Python to the internet<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2280' \/><div class='watu-question-choice'><input type='radio' name='answer-479[]' id='answer-id-2280' class='answer answer-1  answerof-479' value='2280' \/>&nbsp;<label for='answer-id-2280' id='answer-label-2280' class=' answer label-1'><span class='answer'>Establishes a connection to an SQL database<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2281' \/><div class='watu-question-choice'><input type='radio' name='answer-479[]' id='answer-id-2281' class='answer answer-1  answerof-479' value='2281' \/>&nbsp;<label for='answer-id-2281' id='answer-label-2281' class=' answer label-1'><span class='answer'>Connects Python modules<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2282' \/><div class='watu-question-choice'><input type='radio' name='answer-479[]' id='answer-id-2282' class='answer answer-1  answerof-479' value='2282' \/>&nbsp;<label for='answer-id-2282' id='answer-label-2282' class=' answer label-1'><span class='answer'>Connects Python to external APIs<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType1' value='radio' class='required'><\/div><div class='watu-question' id='question-2'><div class='question-content'><p><span class='watu_num'>2. <\/span>Which function is used to create a cursor object when interacting with an SQL database in Python?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='480' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2283' \/><div class='watu-question-choice'><input type='radio' name='answer-480[]' id='answer-id-2283' class='answer answer-2  answerof-480' value='2283' \/>&nbsp;<label for='answer-id-2283' id='answer-label-2283' class=' answer label-2'><span class='answer'>create_cursor()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2284' \/><div class='watu-question-choice'><input type='radio' name='answer-480[]' id='answer-id-2284' class='answer answer-2  answerof-480' value='2284' \/>&nbsp;<label for='answer-id-2284' id='answer-label-2284' class=' answer label-2'><span class='answer'>make_cursor()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2285' \/><div class='watu-question-choice'><input type='radio' name='answer-480[]' id='answer-id-2285' class='answer answer-2  answerof-480' value='2285' \/>&nbsp;<label for='answer-id-2285' id='answer-label-2285' class=' answer label-2'><span class='answer'>cursor()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2286' \/><div class='watu-question-choice'><input type='radio' name='answer-480[]' id='answer-id-2286' class='answer answer-2  answerof-480' value='2286' \/>&nbsp;<label for='answer-id-2286' id='answer-label-2286' class=' answer label-2'><span class='answer'>generate_cursor()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType2' value='radio' class='required'><\/div><div class='watu-question' id='question-3'><div class='question-content'><p><span class='watu_num'>3. <\/span>In Python, what is the purpose of the execute() method when working with an SQL database?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='481' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2287' \/><div class='watu-question-choice'><input type='radio' name='answer-481[]' id='answer-id-2287' class='answer answer-3  answerof-481' value='2287' \/>&nbsp;<label for='answer-id-2287' id='answer-label-2287' class=' answer label-3'><span class='answer'>Executes SQL queries<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2288' \/><div class='watu-question-choice'><input type='radio' name='answer-481[]' id='answer-id-2288' class='answer answer-3  answerof-481' value='2288' \/>&nbsp;<label for='answer-id-2288' id='answer-label-2288' class=' answer label-3'><span class='answer'>Defines a new table<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2289' \/><div class='watu-question-choice'><input type='radio' name='answer-481[]' id='answer-id-2289' class='answer answer-3  answerof-481' value='2289' \/>&nbsp;<label for='answer-id-2289' id='answer-label-2289' class=' answer label-3'><span class='answer'>Imports data into Python<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2290' \/><div class='watu-question-choice'><input type='radio' name='answer-481[]' id='answer-id-2290' class='answer answer-3  answerof-481' value='2290' \/>&nbsp;<label for='answer-id-2290' id='answer-label-2290' class=' answer label-3'><span class='answer'>Initiates a database connection<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType3' value='radio' class='required'><\/div><div class='watu-question' id='question-4'><div class='question-content'><p><span class='watu_num'>4. <\/span>How is data committed to an SQL database using Python?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='482' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2291' \/><div class='watu-question-choice'><input type='radio' name='answer-482[]' id='answer-id-2291' class='answer answer-4  answerof-482' value='2291' \/>&nbsp;<label for='answer-id-2291' id='answer-label-2291' class=' answer label-4'><span class='answer'>commit()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2292' \/><div class='watu-question-choice'><input type='radio' name='answer-482[]' id='answer-id-2292' class='answer answer-4  answerof-482' value='2292' \/>&nbsp;<label for='answer-id-2292' id='answer-label-2292' class=' answer label-4'><span class='answer'>apply()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2293' \/><div class='watu-question-choice'><input type='radio' name='answer-482[]' id='answer-id-2293' class='answer answer-4  answerof-482' value='2293' \/>&nbsp;<label for='answer-id-2293' id='answer-label-2293' class=' answer label-4'><span class='answer'>save()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2294' \/><div class='watu-question-choice'><input type='radio' name='answer-482[]' id='answer-id-2294' class='answer answer-4  answerof-482' value='2294' \/>&nbsp;<label for='answer-id-2294' id='answer-label-2294' class=' answer label-4'><span class='answer'>finalize()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType4' value='radio' class='required'><\/div><div class='watu-question' id='question-5'><div class='question-content'><p><span class='watu_num'>5. <\/span>Which method retrieves the next row of a query result set in Python?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='483' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2295' \/><div class='watu-question-choice'><input type='radio' name='answer-483[]' id='answer-id-2295' class='answer answer-5  answerof-483' value='2295' \/>&nbsp;<label for='answer-id-2295' id='answer-label-2295' class=' answer label-5'><span class='answer'>fetchrow()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2296' \/><div class='watu-question-choice'><input type='radio' name='answer-483[]' id='answer-id-2296' class='answer answer-5  answerof-483' value='2296' \/>&nbsp;<label for='answer-id-2296' id='answer-label-2296' class=' answer label-5'><span class='answer'>fetchnext()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2297' \/><div class='watu-question-choice'><input type='radio' name='answer-483[]' id='answer-id-2297' class='answer answer-5  answerof-483' value='2297' \/>&nbsp;<label for='answer-id-2297' id='answer-label-2297' class=' answer label-5'><span class='answer'>fetchone()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2298' \/><div class='watu-question-choice'><input type='radio' name='answer-483[]' id='answer-id-2298' class='answer answer-5  answerof-483' value='2298' \/>&nbsp;<label for='answer-id-2298' id='answer-label-2298' class=' answer label-5'><span class='answer'>fetchrowset()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType5' value='radio' class='required'><\/div><div class='watu-question' id='question-6'><div class='question-content'><p><span class='watu_num'>6. <\/span>How do you perform an insert query using a cursor in Python?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='484' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2299' \/><div class='watu-question-choice'><input type='radio' name='answer-484[]' id='answer-id-2299' class='answer answer-6  answerof-484' value='2299' \/>&nbsp;<label for='answer-id-2299' id='answer-label-2299' class=' answer label-6'><span class='answer'>insert_query()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2300' \/><div class='watu-question-choice'><input type='radio' name='answer-484[]' id='answer-id-2300' class='answer answer-6  answerof-484' value='2300' \/>&nbsp;<label for='answer-id-2300' id='answer-label-2300' class=' answer label-6'><span class='answer'>execute_insert()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2301' \/><div class='watu-question-choice'><input type='radio' name='answer-484[]' id='answer-id-2301' class='answer answer-6  answerof-484' value='2301' \/>&nbsp;<label for='answer-id-2301' id='answer-label-2301' class=' answer label-6'><span class='answer'>execute(&#8220;INSERT &#8230;&#8221;)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2302' \/><div class='watu-question-choice'><input type='radio' name='answer-484[]' id='answer-id-2302' class='answer answer-6  answerof-484' value='2302' \/>&nbsp;<label for='answer-id-2302' id='answer-label-2302' class=' answer label-6'><span class='answer'>add_record()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType6' value='radio' class='required'><\/div><div class='watu-question' id='question-7'><div class='question-content'><p><span class='watu_num'>7. <\/span>What does the fetchall() method do in Python when working with an SQL database?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='485' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2303' \/><div class='watu-question-choice'><input type='radio' name='answer-485[]' id='answer-id-2303' class='answer answer-7  answerof-485' value='2303' \/>&nbsp;<label for='answer-id-2303' id='answer-label-2303' class=' answer label-7'><span class='answer'>Fetches the first row of the result set<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2304' \/><div class='watu-question-choice'><input type='radio' name='answer-485[]' id='answer-id-2304' class='answer answer-7  answerof-485' value='2304' \/>&nbsp;<label for='answer-id-2304' id='answer-label-2304' class=' answer label-7'><span class='answer'>Fetches all the rows of the result set as a list of tuples<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2305' \/><div class='watu-question-choice'><input type='radio' name='answer-485[]' id='answer-id-2305' class='answer answer-7  answerof-485' value='2305' \/>&nbsp;<label for='answer-id-2305' id='answer-label-2305' class=' answer label-7'><span class='answer'>Fetches the last row of the result set<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2306' \/><div class='watu-question-choice'><input type='radio' name='answer-485[]' id='answer-id-2306' class='answer answer-7  answerof-485' value='2306' \/>&nbsp;<label for='answer-id-2306' id='answer-label-2306' class=' answer label-7'><span class='answer'>Fetches a specific row based on a condition<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType7' value='radio' class='required'><\/div><div class='watu-question' id='question-8'><div class='question-content'><p><span class='watu_num'>8. <\/span>How can you check the number of rows affected by the last query in Python?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='486' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2307' \/><div class='watu-question-choice'><input type='radio' name='answer-486[]' id='answer-id-2307' class='answer answer-8  answerof-486' value='2307' \/>&nbsp;<label for='answer-id-2307' id='answer-label-2307' class=' answer label-8'><span class='answer'>rowcount()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2308' \/><div class='watu-question-choice'><input type='radio' name='answer-486[]' id='answer-id-2308' class='answer answer-8  answerof-486' value='2308' \/>&nbsp;<label for='answer-id-2308' id='answer-label-2308' class=' answer label-8'><span class='answer'>get_rowcount()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2309' \/><div class='watu-question-choice'><input type='radio' name='answer-486[]' id='answer-id-2309' class='answer answer-8  answerof-486' value='2309' \/>&nbsp;<label for='answer-id-2309' id='answer-label-2309' class=' answer label-8'><span class='answer'>rows_affected()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2310' \/><div class='watu-question-choice'><input type='radio' name='answer-486[]' id='answer-id-2310' class='answer answer-8  answerof-486' value='2310' \/>&nbsp;<label for='answer-id-2310' id='answer-label-2310' class=' answer label-8'><span class='answer'>query_rows()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType8' value='radio' class='required'><\/div><div class='watu-question' id='question-9'><div class='question-content'><p><span class='watu_num'>9. <\/span>What is the purpose of the fetchone() method in Python when working with an SQL database?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='487' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2311' \/><div class='watu-question-choice'><input type='radio' name='answer-487[]' id='answer-id-2311' class='answer answer-9  answerof-487' value='2311' \/>&nbsp;<label for='answer-id-2311' id='answer-label-2311' class=' answer label-9'><span class='answer'>Fetches the first row of the result set<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2312' \/><div class='watu-question-choice'><input type='radio' name='answer-487[]' id='answer-id-2312' class='answer answer-9  answerof-487' value='2312' \/>&nbsp;<label for='answer-id-2312' id='answer-label-2312' class=' answer label-9'><span class='answer'>Fetches all the rows of the result set<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2313' \/><div class='watu-question-choice'><input type='radio' name='answer-487[]' id='answer-id-2313' class='answer answer-9  answerof-487' value='2313' \/>&nbsp;<label for='answer-id-2313' id='answer-label-2313' class=' answer label-9'><span class='answer'>Fetches a specific row based on a condition<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2314' \/><div class='watu-question-choice'><input type='radio' name='answer-487[]' id='answer-id-2314' class='answer answer-9  answerof-487' value='2314' \/>&nbsp;<label for='answer-id-2314' id='answer-label-2314' class=' answer label-9'><span class='answer'>Fetches the last row of the result set<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType9' value='radio' class='required'><\/div><div class='watu-question' id='question-10'><div class='question-content'><p><span class='watu_num'>10. <\/span>How do you perform an update query using a cursor in Python?<\/p>\n<\/div><input type='hidden' name='question_id[]' value='488' \/><div class='watu-questions-wrap '><input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2315' \/><div class='watu-question-choice'><input type='radio' name='answer-488[]' id='answer-id-2315' class='answer answer-10  answerof-488' value='2315' \/>&nbsp;<label for='answer-id-2315' id='answer-label-2315' class=' answer label-10'><span class='answer'>cursor_update()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2316' \/><div class='watu-question-choice'><input type='radio' name='answer-488[]' id='answer-id-2316' class='answer answer-10  answerof-488' value='2316' \/>&nbsp;<label for='answer-id-2316' id='answer-label-2316' class=' answer label-10'><span class='answer'>execute(&#8220;UPDATE &#8230;&#8221;)<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2317' \/><div class='watu-question-choice'><input type='radio' name='answer-488[]' id='answer-id-2317' class='answer answer-10  answerof-488' value='2317' \/>&nbsp;<label for='answer-id-2317' id='answer-label-2317' class=' answer label-10'><span class='answer'>update_record()<\/span><\/label><\/div>\n<input type='hidden' name='answer_ids[]' class='watu-answer-ids' value='2318' \/><div class='watu-question-choice'><input type='radio' name='answer-488[]' id='answer-id-2318' class='answer answer-10  answerof-488' value='2318' \/>&nbsp;<label for='answer-id-2318' id='answer-label-2318' class=' answer label-10'><span class='answer'>modify_query()<\/span><\/label><\/div>\n<\/div><input type='hidden' id='questionType10' value='radio' class='required'><\/div><div style='display:none' id='question-11'><br \/><div class='question-content'><img decoding=\"async\" src=\"https:\/\/cbsepython.in\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading ...\" title=\"Loading ...\" \/>&nbsp;Loading &#8230;<\/div><\/div><br \/>\n<input type=\"button\" name=\"action\" onclick=\"Watu.submitResult()\" id=\"action-button\" value=\"Submit\"  class=\"watu-submit-button\" \/>\n<input type=\"hidden\" name=\"no_ajax\" value=\"0\"><input type=\"hidden\" name=\"quiz_id\" value=\"32\" \/>\n<input type=\"hidden\" id=\"watuStartTime\" name=\"start_time\" value=\"2026-04-10 13:39:02\" \/>\n<\/form>\n<\/div>\n<div id=\"watu-loading-result\" style=\"display:none;\">\n\t<p align=\"center\"><img decoding=\"async\" src=\"https:\/\/cbsepython.in\/wp-content\/plugins\/watu\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading\" title=\"Loading\" \/><\/p>\n<\/div>\t\n<script type=\"text\/javascript\">\nvar exam_id=0;\nvar question_ids='';\nvar watuURL='';\njQuery(function($){\nquestion_ids = \"479,480,481,482,483,484,485,486,487,488\";\nexam_id = 32;\nWatu.exam_id = exam_id;\nWatu.qArr = question_ids.split(',');\nWatu.post_id = 4409;\nWatu.singlePage = '1';\nWatu.hAppID = \"0.12980900 1775808542\";\nwatuURL = \"https:\/\/cbsepython.in\/wp-admin\/admin-ajax.php\";\nWatu.noAlertUnanswered = 0;\n});\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Interface of python with SQL Quiz Class 12 Here&#8217;s a 15-question quiz based on the topic &#8220;Interface of Python with an SQL Database: Connecting SQL with Python, Performing Insert, Update, Delete Queries Using Cursor, Display Data by Using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount, Creating Database Connectivity Applications, Use of %s Format Specifier or [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"class_list":["post-4409","post","type-post","status-publish","format-standard","hentry","category-quiz"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=4409"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/4409\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=4409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=4409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=4409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}