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

