Science (English Medium) कक्षा १२ - CBSE Important Questions for Computer Science (Python)

Consider the table CLUB given below and write the output of the SQL queries that follow.

1. SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
2. SELECT CNAME, SPORTS FROM CLUB
   WHERE DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
3. SELECT CNAME, AGE, PAY FROM CLUB WHERE GENDER = "MALE" AND PAY BETWEEN 1000 AND 1200;

Consider the table Personal given below:

Based on the given table, write SQL queries for the following:

1. Increase the salary by 5% of personals whose allowance is known.
2. Display Name and Total Salary (sum of Salary and Allowance) of all personals. The column heading ‘Total Salary’ should also be displayed.
3. Delete the record of Supervisors who have salary greater than 25000.

Kabir wants to write a program in Python to insert the following record in the table named Student in MYSQL database,

SCHOOL:

• rno(Roll number) - integer
• name(Name) - string
• DOB (Date of birth) - Date
• Fee - float

Note the following to establish connectivity between Python and MySQL:

• Username - root
• Password - tiger
• Host - localhost

The values of fields rno, name, DOB and fee has to be accepted from the user. Help Kabir to write the program in Python.

Consider the tables PRODUCT and BRAND given below:

Write SQL queries for the following:

1. Display product name and brand name from the tables PRODUCT and BRAND.
2. Display the structure of the table PRODUCT.
3. Display the average rating of Medimix and Dove brands.
4. Display the name, price, and rating of products in descending order of rating.

Zack is working in a database named SPORT, in which he has created a table named “Sports” containing columns SportId, SportName, no_of_players, and category.

After creating the table, he realized that the attribute, category has to be deleted from the table and a new attribute TypeSport of data type string has to be added. This attribute TypeSport cannot be left blank. Help Zack write the commands to complete both the tasks.

Sartaj has created a table named Student in MYSQL database, SCHOOL:

• rno(Roll number )- integer
• name(Name) - string
• DOB (Date of birth) – Date
• Fee – float

Note the following to establish connectivity between Python and MySQL:

• Username - root
• Password - tiger
• Host - localhost

Sartaj, now wants to display the records of students whose fee is more than 5000. Help Sartaj to write the program in Python.

Hi-Standard Tech Traj.ning Ltd. is a Mumbai based organization which is expanding its office set-up to Chennai. At Chennai office compound, they are planning to have 3 different blocks for Admin, Training and Accounts related activities. Each block has a number of computers, which are required to be connected in a network for communication, data and resource sharing.

As a network consultant, you have to suggest the best network related solutions for them for issues/problems raised by them in (i) to (iv), as per the distances between various blocks/locations and other given parameters.

Shortest differences between various blocks/locations:

The number of computers installed at various blocks is as follows:

1) Suggest the most appropriate block/location to house the SERVER in the CHENNAI office (out of the 3 blocks) to get the best and effective connectivity. Justify your answer.

2) Suggest the best-wired medium and draw the cable layout (Block to Block) to efficiently connect various blocks within the CHENNAI office compound.

3) Suggest a device/software and its placement that would provide data security for the entire network of the CHENNAI office.

4) Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smartphone/laptop users in the CHENNAI office

Differentiate between packet switching over message switching

Expand the following:

ARPANET

Explain the following device:

Repeater

Explain the following device:

Router

Quickdev, an IT based firm, located in Delhi is planning to set up network for its four branches within a city with its Marketing department in Kanpur. As a network professional, give solution to the questions, after going through the branches locations and other details which are given below: 

Distance between various branches is a follows:

Number of computers in each of the branches:

1. Suggest the most suitable place to install the server for the Delhi branch with a suitable reason.
2. Suggest an ideal layout for connecting all these branches within Delhi.
3. Which device will you suggest, that should be placed in each of these branches to efficiently connect all the computers within these branches?
4. Delhi firm is planning to connect to its Marketing department in Kanpur which is approximately 300 km away. Which type of network out of LAN, WAN, or MAN will be formed? Justify your answer.
5. Suggest a protocol that shall be needed to provide help for transferring of files between Delhi and Kanpur branch.

The modem at the sender’s computer end acts as a ______.

______ is a communication methodology designed to deliver both voice and multimedia communications over Internet protocol.

Write the full form of the following:

SMTP

Write the full form of the following:

PPP

What is the use of TELNET?

What is the need for Protocols?

In case of ______ switching, before a communication starts, a dedicated path is identified between the sender and the receiver.

Define the term bandwidth with respect to networks.