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
   378   379   380   381   382   383   384   385   386   387   388