Page 34 - IPP-12-2024

12. Which of the following codes will display the total number of rows in the DataFrame stud? [1]
(i) print(len(stud.axes[0]) (ii) print(stud.len(0))
(iii) print(stud.len[axes=0]) (iv) print(len(stud.axes[row])
13. The legal term to describe the rights of a creator of original creative or artistic work is— [1]
(i) Copyright (ii) Copylef (iii) GPL (iv) FOSS
14. In SQL, which clause is used to select specific rows? [1]
15. Which is the device that connects dissimilar networks? [1]
16. Name the primary law in India dealing with cybercrime? [1]
Questions 17 and 18 are Assertion and Reasoning Based Questions. Mark the correct choice as
(i) Both A and R are true and R is the correct explanation for A.
(ii) Both A and R are true but R is not the correct explanation for A.
(iii) A is true but R is false.
(iv) A is false but R is true.
17. Assertion (A): A repeater is an electronic device that receives a signal and retransmits it. [1]
Reasoning (R): Repeaters are used to extend transmissions so that the signal can cover longer distances.
18. Assertion (A): In Series, values of data are Immutable: Value of elements cannot be changed. [1]
Reasoning (R): Pandas Series are homogeneous one-dimensional objects, i.e., all data are of the same type.

Section B
19. How do computer networks reduce hardware costs of an organization? Explain with the help of an example.
[2]
Or
Distinguish between Static and Dynamic web pages.
20. Carefully observe the following code: [2]
import pandas as pd
list_of_dict = [
{'Name': 'Sourab', 'Age': 35, 'Marks': 91},
{'Name': 'Rohan', 'Age': 31, 'Marks': 87},
{'Name': 'Shalini', 'Age': 33, 'Marks': 78},
{'Name': 'Divya', 'Age': 23, 'Marks': 93}
]
df = pd.DataFrame(list_of_dict)
print(df)
Answer the following:
(i) List the index of the DataFrame df. (ii) List the column names of DataFrame df.
21. What is the purpose of the DROP TABLE command in MySQL? How is it different from the DELETE command?
[2]
22. Write Python code to create the following Series Stock (using list): [2]
1 PEN
2 PENCIL
3 ERASER
23. Ms. Samantha has many electronic gadgets which are not usable due to outdated hardware and software.
Help her to find the three best ways to dispose of the used electronic gadgets. [2]
Or
What do you understand about Netiquette? Explain any two such etiquette.
24. Give the output: [2]
import pandas as pd
name=['Rahul','Aman','Karan']
p=pd.Series(name,index=[0,1,2])
p1=p.reindex([1,2,3])
print(p)
print(p1)
25. What is Mathematical function in SQL? Name any two. [2]

Appendices A.37