Page 22 - IPP-11

25. Differentiate between a NumPy Array and Lists. (2)

26. Write a program to convert a Panda module series to Python list and its types. (2)
27. What will be the output of the following code: (2)
def foo(i=[]):
i.append(1)
return i
print(foo())
SECTION–C

28. What are the common MySQL functions? (1)
29. What is the difference between primary key and candidate key? (2)
30. What do DDL, DML and DCL stand for? (2)
31. Create a table for the following structure— (2)

Field | Type | Null | Key | Default | Extra |
+---------- +---------------- +------ +----- +--------- + ------- +
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
32. What is the difference between update and alter command? (2)
33. Define projection in terms of mysql. (1)

34. Write the appropriate usage of social networks. (1)
35. Define eavesdropping and phishing. (2)
36. What is the difference between virus and Trojan horse? (2)
37. What is cyberbullying? (1)

2