Download App

MYSQL with Python Interface — Computer Science STD 12 Science — Question

CBSE BoardEnglish MediumSTD 12 ScienceComputer ScienceMYSQL with Python Interface3 Marks
Question
Write the python function to accept the employee name as parameter and find out whether record present in the table or not. (Assuming that table already exist)
✓

Answer

Get the step-by-step solution for this question inside the Vidyadip app.

Get the answer in the app

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "3 Marks Each" from MYSQL with Python Interface→MYSQL with Python Interface — all question types→Computer Science STD 12 Science question papers→CBSE Board STD 12 Science question papers→CBSE Board question paper generator→

Similar questions

Explain the concept of split-apply-combin in group by.
→
Illustrate the layout for connecting 5 computers in a Bus and a Star topology of Networks. [AI 2015]

OR

Any valid illustration of Bus and Star Topology.

→
Write a program to save the following records in laps1.csv. ADMNO NAME AGE 1151, Ajay, 12 1152, Chandrika, 14
→
Out of the following, which all comes under cyber crime? [Delhi 2015]

(a) Stealing away a brand new computer from a showroom.

(b) Getting in someone’s social networking account without his consent and posting pictures on his behalf to harass him.

(c) Secretly copying files from server of a call center and selling it to the other organization.

(d) Viewing sites on a internet browser.

→
Categorise the following under Client Side and Server Side script category:

(i) VB Script

(ii) ASP

(iii) JSP

(iv) JavaScript

→
Write the output of the following script/code

→
Write a python program to draw the line chart for the following:

x_data = [2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2013]

y_data = [18, 21, 18, 21, 16, 14, 13, 18, 17, 16, 19, 23]

→
What are the adverse effects of e-Waste?
→

Consider the following table Student & Stream.

Table: Student

Admno Sname Class Sec Fee Mobile Area S_ID
1001 RAMESH XII A 2500 987654321 Madipur 10
1078 KRISHNA XII B 2400 999911111 Jawala Heri 30
1006 FARDEEN XII C 2600 987654321 Paschim Puri 40
1004 SUBHAM XII A 2500 963025874 Madipur 20
1029 KRITIKA XI C 2700 987456210 Madipur 30
1008 SAMEEKSHA XII A 2450 987123456 Mangol Puri 20
1025 SALMA XII B 2580 998877445 Madipur 30
1036 AMANDEEP XII B 2600 999333555 Khyala 40
1037 TEJAS XI C 2650 987951357 Paschim Puri 40
1029 HIMANSHU XII A 2750 951369874 Jawala Heri 10

Table : Stream

S_ID Stream_name
10 MEDILCAL
20 NON MEDICAL
30 COMMERCE WITH MATH
40 COMMERCE WITH IP
50 HUMANITIES

Write SQL commands for the statements (a) to (h) on the table: Student and Stream
(a) Display class and total fee collected from each class.
(b) Display admission no, students name and stream name.
(c) Display all the student details who have taken Commerce Stream.
(d) Count number of students who have opted for HUMANITIES stream.
(e) Display information of commerce with ip students whose name start with ‘S’. Arrange the record by admission number.
(f) Display details of all students who are in the MEDICAL stream.
(g) Display total fee of ‘Non-Medical’ Student.
(h) Change the name of the Column Sname to Student_Name.

→
Write function insert() to insert the new row in table student. The function will take the values as parameter.
→