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

Write SQL commands for the following:

Table: TEACHER

TID	NAME	AGE	DEPT	DATEOFJOIN	SAL	SEX
T118	Navin	40	Computer	2010-01-10	12000	M
T107	Chetna	37	History	2008-03-24	20000	F
T105	Sandeep	46	Maths	2006-12-12	30000	M
T110	Sangeeta	35	History	2010-07-01	25000	F
T101	Rudransh	42	Maths	2004-09-05	40000	M
T121	Neeraj	38	Physics	2011-04-01	28000	M

(i) To show information about the teachers of the history department.
(ii) To list the names of teachers earning a salary between 20000 and 30000.
(iii) To count the number of male teachers.
(iv) Display gender wise total number of teachers.
(v) To list the name and age of teachers of female teachers in descending order of date of join.
(vi) Increase the salary by 10% for Maths departments.
( vii) To delete the record of teacher Neeraj.

Write a script which inputs three numbers from the user and displays these numbers in ascending order.

To input a number and display its first 10 multiples.

What is the importance of a Primary Key in a table? Explain with a suitable example.

Write a function to read the content from the file “Story.txt”. The function will take a string as parameter and search the string into the file.

Write two advantages of using an optical fiber cable over an Ethernet cable to connect two service stations, which are 190m away from each other.

Write Python script to input the values of Principal, Rate, and Time and calculate Simple Interest and Total Amount.

Consider the following randomly ordered numbers stored in a list
786, 234, 526, 132, 345, 467,
Show the content of list after the First, Second and Third pass of the bubble sort method used for arranging in ascending order?
Note: Show the status of all the elements after each pass very clearly underlining the changes.

Write a function countmy( )in Python to read the text file "DATA.TXT" and count the number of times "my" occurs in the file. For example if the file "DATA.TXT" contains: "This is my website. I have displayed my preferences in the CHOICE section." The countmy( ) function should display the output as: "my occurs 2 times".

A school with 20 stand -alone computers is considering to network them together and adding a server. State two advantages of doing this.