Page 380 - Informatics_Practices_Fliipbook_Class12
P. 380

Section B
          19. Briefly explain the basic concepts of a web server and web hosting.                             [2]
                                                           OR
              Rati is doing a course in networking. She is unable to understand the concept of URL. Help her by explaining it with
            the help of suitable example.
          20.  The python code written below has syntactical errors. Rewrite the correct code and underline the corrections made.  [2]

            Import pandas as pd
              df ={"Technology":["Programming","Robotics","3D Printing"],"Time(in months)":[4,4,3]}
            df= Pd.dataframe(df)
            Print(df)
          21. Consider the given SQL string:                                                                  [2]
            "12#All the Best!"
            Write suitable SQL queries for the following:
            a. Returns the position of the first occurrence of the substring "the" in the given string.
            b. To extract last five characters from the string.
          22. Predict the output of the given Python code:

            import pandas as pd
            list1=[-10,-20,-30]
            ser = pd.Series(list1*2)
            print(ser)
        23.  Differentiate between the active digital footprint and passive digital footprints.               [2]

        24. Complete the given Python code to get the required output as: Rajasthan                           [2]

            import_____________as pd
              di = {'Corbett': 'Uttarakhand', 'Sariska': 'Rajasthan', 'Kanha': 'Madhya
            Pradesh', 'Gir':'Gujarat'}
            NP =_____________. Series(_____________)
            print(NP[_____________])
          25. What are aggregate functions in SQL? Name any two.                                              [2]
                                                        Section C
        26.  Based on the SQL table CAR_SALES, write suitable queries for the following:                      [2]
            +--------+-------------------+--------+-------+-------+
            | NUMBER | SEGMENT           | FUEL   | QT1   | QT2   |
            +--------+-------------------+--------+-------+-------+
            |  1     | Compact HatchBack | Petrol | 56000 | 70000 |
            |  2     | Compact HatchBack | Diesel | 34000 | 40000 |
            |  3     | MUV               | Petrol | 33000 | 35000 |
            |  4     | MUV               | Diesel | 14000 | 15000 |
            |  5     | SUV               | Petrol | 27000 | 54000 |
            |  6     | SUV               | Diesel | 18000 | 30000 |
            |  7     | Sedan             | Petrol | 8000  | 10000 |
            |  8     | Sedan             | Diesel | 1000  |  5000 |
            +--------+-------------------+--------+-------+-------+
            a. Display fuel wise average sales in the first quarter.
            b. Display segment wise highest sales in the second quarter.
            c.  Display the records in the descending order of sales in the second quarter.

          366  Touchpad Informatics Practices-XII
   375   376   377   378   379   380   381   382   383   384   385