Computer Networks (CN) — Computer Science STD 12 Science — Question

A text file “Quotes.Txt” has the following data written in it: "Living a life you can be proud of Doing your best Spending your time with people and activities that are important to you Standing up for things that are right even when it’s hard Becoming the best version of you." Write a user defined function to display the total number of words present in the file.

Consider the following table HOSPITAL.

Table: HOSPITAL

PNo	Name	Age	Department	DateofAdm	Charges	Sex
1	Mayank	65	Surgery	23/02/2018	600	M
2	Babita	24	ENT	01/01/2019	400	F
3	Kashish	45	Orthopaedic	19/12/2018	400	M
4	Tarun	12	Surgery	01/10/2018	600	M
5	Manisha	36	ENT	12/01/2018	400	F
6	Imran	16	ENT	24/02/2018	400	M
7	Ankita	NULL	Cardiology	20/08/2018	800	F
8	Zoya	45	Gynecology	22/02/2018	500	F
9	Kush	19	Cardiology	13/01/2019	800	M
10	Shalini	31	Medicine	19/02/2018	300	F

Note: PNo is the primary key in the above table.

Write SQL commands for the statements (a) to (g) on the table HOSPITAL.
(a) To display the details of all the patients whose name starts with the alphabet ‘Z’.
(b) To change the age of the patient Kush to 20.
(c) To increase the charges of all the patients by 5%.
(d) To remove the record of the patient whose Name is Tarun.
(e) To add another column DocName(Doctor Name) of the type varchar in the above table.
(f) To display patient detail whose age is missing(null).
(g) To decrease the charges by 5% of all the patients admitted to the ENT department.

Write a function to count the “me” and “my” in a file “India.txt”. 

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

Differentiate between Bus and Star topology of networks. 

To input an integer and find the sum of its digits.

Which of the following crime(s) is/are covered under cybercrime? [Delhi 2013]

(a) Stealing brand new hard disk from a shop

(b) Getting into unknown person’s social networking account and start messaging on his behalf.

(c) Copying some important data from a computer without taking permission from the owner of the data.

What do the following top level domains signify?

(i) .com

(ii) .org

What is default argument? Explain with help of an example.

Write the SQL statements for the following:

(a) Extract the "net "from the word "Internet ".

(b) Print the month of your date of birth.