Functions — Computer Science STD 12 Science — Question

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

Out of the following, which all comes under cyber crime?

(a) Stealing away a brand new computer from a showroom.

(b) Getting in someone’s social networking account without his consent and posting pictures on his behalf to harass him.

(c) Secretly copying files from server of a call center and selling it to the other organization.

(d) Viewing sites on a internet browser.

Explain the concept indexing operator [] :

Write a python program to create the pie chart use a different colour for the different countries.

Title: Carbon emission of the coutries 1990-2011

values=[27, 11, 25, 8, 1, 3, 25]

countres= [ "US", "China", "European Union", "Russian Federation", "Brazil","India","Rest of World"]

 Write a python script to read the numbers from the user until user presses zero and print sum , average and maximum number entered by the user.

What acts comes under cybercrime?

How to iterate over a Pandas DataFrame? Explain any one with help of an example.

Distinguish between LAN and WAN.

Define illegal downloading and explain.

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;