Data File Handling — Computer Science STD 12 Science — Question

Write two advantages of using an optical fiber cable over an Ethernet cable to connect two service stations, which are 190m away from each other.

Write a program to create the list and do the following operations using the predefined functions.

• To print sum of all element of the list• To find maximum element of the list• To find minimum element of the list• To find the length of the list• To sort the list in ascending order• To sort the list in descending order

Differentiate between the terms primary key and alternate key.

Expand the following: GPRS, CDMA  

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

Write the few points about how technology is increasing the issue related to people's social life.

Observe the following table and answer the parts (i) and (ii) accordingly

Table: Product

Pno	Name	Qty	PurchaseDate
101	Pen	102	12-12-2011
102	Pencil	201	21-02-2013
103	Eraser	90	09-08-2010
109	Sharpener	90	31-08-2012
113	Clips	900	12-12-2011

(a) Write the names of most appropriate columns, that can be considered as candidate keys.

(b) What is the degree and cardinality of the above table?

Write the difference between WHERE and HAVING clause.

Following is the script to display first n natural numbers, where n is input from the user. If the user enters 0 or a negative number, the code generates no output.

Observe the table ‘Club’ given below:

Table: Club

Member_id	Member_Name	Address	Age	Fee
M001	Sumit	New Delhi	20	2000
M002	Nisha	Gurgaon	19	3500
M003	Niharika	New Delhi	21	2100
M004	Sachin	Faridabad	18	3500

(i) What is the cardinality and degree of the above given table?

(ii) If a new column contact_no has been added and three more members have joined the club then how these changes will affect the degree and cardinality of the above given table.