Data Visualisation — Computer Science STD 12 Science — Question

For a given list of values in descending order, write a method in python to search for a value with the help of Binary Search method. The method should return position of the value and should return –1 if the value not present in the list.

Differentiate between packet switching and message switching technique in network communication.

What is the difference between video conferencing and chat?   

Differentiate between Candidate Key and Primary Key in context of RDBMS.

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.

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

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

Write Python script to enter temperature in degree Celsius and display it into Fahrenheit. The formula to convert from degree Celsius to degree Fahrenheit is:

How can we sort the DataFrame?

Rewrite the following code after removing the syntactical errors (if any). Underline each correction: