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

Input principal and time. Then calculate simple interest. If time is more than 10 years, calculate the simple interest at rate of 8% p.a. Otherwise calculate it at rate of 12% p.a.

Distinguish between LAN and WAN.

Differentiate between Bus and Star topology of networks. 

Write a function to read the content from the file and display each word in reverse order.

What is the importance of a Primary Key in a table? Explain with a suitable example.

Write SQL commands for the statements (a) to (h) on the table HOSPITAL
(a) To insert a new row in the HOSPITAL table with the following data: 11,’ Kasif’, 37,’ENT’,’2018-02-25’, 300, ’M’.
(b) To set charges to NULL for all the patients in the Surgery department.
(c) To display patient details who are giving charges in the range 300 and 400 (both inclusive).
(d) To display the details of that patient whose name second character contains ‘a’.
(e) To display total charges of ENT Department.
(f) To display details of the patients who admitted in the year 2019.
(g) To display the structure of the table hospital.
(h) Write the command to create the above table.

JavaScript and VBScript are client side scripts.

JSP and ASP are server side scripts.

Expand the following: GPRS, CDMA      

Differentiate between the terms primary key and alternate key.

Write a script to find the roots of a quadratic equation.