Page 383 - Informatics_Practices_Fliipbook_Class12
P. 383
OR
Kabir has created following table named exam:
+-------+---------+------------------+-------+
| RegNo | Name | Subject | Marks |
+-------+---------+------------------+-------+
| 1 | Sanya | Computer Science | 98 |
| 2 | Sanchay | IP | 100 |
| 3 | Vinesh | CS | 90 |
| 4 | Sneha | IP | 99 |
| 5 | Akshita | IP | 100 |
+-------+---------+------------------+-------+
Help him in writing SQL queries to the perform the following task:
a. Insert a new record in the table having following values:
[6,'Khushi','CS',85]
b. To change the value "IP" to "Informatics Practices" in subject column.
c. To remove the records of those students whose marks are less than 30 .
d. To add a new column Grade of suitable datatype.
To display records of "Informatics Practices" subject.
34. XYZ Media house campus is in Delhi and has 4 blocks named Z1, Z2, Z3 and Z4. The tables given below show the
distance between different blocks and the number of computers in each block. [5]
Block Z1 to Block Z2 80 metres
Block Z1 to Block Z3 65 metres
Block Z1 to Block Z4 90 metres
Block Z2 to Block Z3 45 metres
Block Z2 to Block Z4 120 metres
Block Z3 to Block Z4 60 metres
Block Number of computers
Z1 135
Z2 290
Z3 180
Z4 195
The company is planning to form a network by joining these blocks.
a. Out of the four blocks on campus, suggest the location of the server that will provide the best connectivity.
Explain your response.
b. For very fast and efficient connections between various blocks within the campus, suggest a suitable topology
and draw the same.
c. Suggest the placement of the following devices with justification
(i) Repeater
(ii) Hub/Switch
d. VoIP technology is to be used which allows one to make voice calls using a broadband internet connection.
Expand the term VoIP.
e. The XYZ Media House intends to link its Mumbai and Delhi centers. Out of LAN, MAN, or WAN, what kind of
network will be created? Justify your answer.
CBSE Sample Question Paper 369

