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

Name the few tools & resources for students with disabilities which can help student to learn the things easily.

Write two advantages of 4G over 3G Mobile Telecommunication Technologies in terms of speed and services. 

Write a script to create a list of 10 integers and then
(a) Display all the elements of the list
(b) Display the odd elements of the list

Find and write the output of the following Python code:

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables:

TABLE: SALESPERSON

CODE	NAME	SALARY	ITCODE
1001	TANDEEP JHA	60000	I2
1002	YOGRAJ SINHA	70000	I5
1003	TENZIN JACK	45000	I2
1005	ANOKHI RAJ	50000	I7
1004	TARANA SEN	55000	I7

TABLE: ITEM

ITCODE	ITEMTYPE	TURNOVER
I5	STATIONARY	3400000
I7	HOISTERY	6500000
I2	BAKERY	10090000

(a) To display the CODE and NAME of all salesperson having “I7” item Type Code from the table SALESPERSON.
(b) To display all details from table SALESPERSON in descending order of SALARY.
(c) To display the number of SALESPERSON dealing in each TYPE of ITEM.(Use ITCODE for the same)
(d) To display NAME of all the salesperson table along with their corresponding ITEMTYPE from the ITEM table.
(e) Select max(salary) from salesperson;
(f) Select distinct itcode from salesperson;
(g) select code,name,i.itcode from sales persons, item i where s.itcode=i.itcode and turnover>=7000000;
(h) Select sum (salary)from salesperson where itcode=”i2”;

Explain the concept indexing operator [] :

Differentiate between DDL &DMLcommands. Identify DDL &DML commands from the following:

(UPDATE, SELECT, ALTER, DROP)

Write a script to create an empty list and then
(a) Input 10 numbers from the users and store them in the list using append() method
(b) Find the sum of all the even elements present in the list

What is the purpose of Modem in network?

What is a spam mail?