Introduction to Computer Networks — Computer Science STD 12 Science — Question

Write a script to create a list of names of 10 cities and then
(a) Display all the elements of the list
(b) Display all the elements of the list in reverse order

Out of the following, which is the fastest (a) wired and (b) wireless medium of communication?

Infrared, Coaxial Cable, Ethernet Cable, Microwave, Optical Fiber

Write SQL queries for (a) to (d) and find outputs for SQL queries (e) to (i), which are based on the tables.

TABLE: WATCHES

Watchid	Watch_name	Price	Type	Qty_store
W001	High time	10000	Unisex	100
W002	Life time	15000	Ladies	150
W003	Wave	20000	Gents	200
W004	High fashion	7000	Unisex	250
W005	Golden time	25000	Gents	100

TABLE: SALE

Watchid	Qty_Sold	Quarter
W001	10	1
W003	5	1
W002	20	2
W003	10	2
W001	15	3
W002	20	3
W005	10	3
W003	15	4

(a) To display all the details of those watches whose name ends with ‘time’

(b) To display watch’s name andprice of those watches which have price range between 5000-15000

(c) To display total quantity in store of unisex type watches

(d) To display watch name and their quantity sold in first quarter

(e) Select max(price),min(qty_store) from watches;

(f) Select quarter, sum(qty_sold) from sale group by quarter;

(g) Select watch_name,price,type from watches w, sale s where w.watchid=s.watchid;

(h) Select watch_name, qty_store, sum(qty_sold),qty_store

(i) W.watch=s.watchid group by s.watchid;

What is the role of the computer in cybercrime?

Write the python function to accept the rollno as parameter and find out whether record present in the table or not

What is a scam? Write a few examples.

Write the difference between Internet Banking and Mobile Banking?

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

Write the algorithm for the bubble sort.

Write a function search () to search a record in a binary file according to the employee number entered by the user. Also display the message “Record not found” in case record not found in the file.