Data Structure — Computer Science STD 12 Science — Question

Write a script to create a list of names of 10 cities and then
(a) Display the names of all the cities whose names start with 'A'
(b) Count the number of cities whose names do not start with 'A'

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

 Explain Reindexing in pandas.

What kind of data gets stored in cookies and how is it useful? 

What is the difference between HTML and XML.

Based on the following python code, find out the expected correct output(s) from the options (i) to (iv)
tup=("Red","Blue","Green","Yellow")
for i in range(3):
print(tup[random.randrange(1,4,2)],end="#")
(i) Blue#Blue#Yellow#
(ii) Red#Green#Green#
(iii) Blue#Yellow#Green# (iv) Blue#Green#Yellow#

What is the basic difference between Trojan Horse and Computer Worm? 

Write the output of the given program:

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

Consider the following table Student & Stream.

Table: Student

Admno	Sname	Class	Sec	Fee	Mobile	Area	S_ID
1001	RAMESH	XII	A	2500	987654321	Madipur	10
1078	KRISHNA	XII	B	2400	999911111	Jawala Heri	30
1006	FARDEEN	XII	C	2600	987654321	Paschim Puri	40
1004	SUBHAM	XII	A	2500	963025874	Madipur	20
1029	KRITIKA	XI	C	2700	987456210	Madipur	30
1008	SAMEEKSHA	XII	A	2450	987123456	Mangol Puri	20
1025	SALMA	XII	B	2580	998877445	Madipur	30
1036	AMANDEEP	XII	B	2600	999333555	Khyala	40
1037	TEJAS	XI	C	2650	987951357	Paschim Puri	40
1029	HIMANSHU	XII	A	2750	951369874	Jawala Heri	10

Table : Stream

S_ID	Stream_name
10	MEDILCAL
20	NON MEDICAL
30	COMMERCE WITH MATH
40	COMMERCE WITH IP
50	HUMANITIES

Write SQL commands for the statements (a) to (h) on the above table: Student and Stream
(a) Identify Primary Keys and Foreign Key in the table student and primary key in Stream table given above.
(b) Display stream id and stream-wise total fee collected.
(c) Count no of students from each area.
(d) Display all the student details those who belongs to Madipur Area.
(e) Increase the fees of all students by10%.
(f) Display unique area from the student table.
(g) Display details of those students whose area contains ‘Puri’.
(h) Display the information of those students who are in class XII and section is either B or C.