Review of Python – 1 — Computer Science STD 12 Science — Question

Distinguish between MAC address and IP address with the help of example of each.

Write SQL commands for the statements (a) to (h) on the table HOSPITAL
(a) To insert a new row in the HOSPITAL table with the following data: 11,’ Kasif’, 37,’ENT’,’2018-02-25’, 300, ’M’.
(b) To set charges to NULL for all the patients in the Surgery department.
(c) To display patient details who are giving charges in the range 300 and 400 (both inclusive).
(d) To display the details of that patient whose name second character contains ‘a’.
(e) To display total charges of ENT Department.
(f) To display details of the patients who admitted in the year 2019.
(g) To display the structure of the table hospital.
(h) Write the command to create the above table.

To find the sum of first n natural numbers, where n is to be input from the user. Filename:

Define Series in Pandas.

To input a number and display its first 10 multiples.

What do you mean by join? Explain the concept of join.

 Define the Pandas/Python pandas.

A company has three departments namely Administrative, Sales and Production. Out of telephone cable, Optical Fibre, Ethernet Cable, which communication medium is best for high speed communication between departments?

Which type of network (out of LAN, PAN, MAN) is formed when you connect two mobiles using Bluetooth to transfer a picture file? 

Write a python program to accept a list for the user and create another list which will double of x list. Create the line chart for the same.