Series &RQPS
Question Paper Code 90 Set 4
INFORMATICS PRACTICES – updating…
(Session 2024-25)
Time allowed : 3 hours
Maximum Marks : 70
General Instructions :
- This question paper contains 37 questions and five sections, Section A to E.
- All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions.
- Section A have 21 questions carrying 1 mark each.
- Section B has 7 Very Short Answer type questions carrying 2 marks each.
- Section C has 4 Short Answer type questions carrying 3 marks each.
- Section D has 2 case study type questions carrying 4 marks each.
- Section E has 3 questions carrying 5 marks each.
- All programming question are to be answered using python language only.
- In case of MCQs, text of the correct answer should also be written.
SECTION – A
1. State whether the following statement is True or False :
In Python, we cannot create an empty DataFrame.
2. What will be the output of the following SQL command?SELECT MONTHNAME ('2024-08-02'):a) 08
b) 02
c) February
d) August
3. Temporary data files stored by websites in our computer can be used to track our online activities and also to personalize browsing experience. These files are known as:
a) Plug-ins
b) Add-ons
c) Cookies
d) Bookmarks
4. Which of the following is not an aggregate function in SQL?
a) COUNT(*)
b) MIN()
c) LEFT()
d) AVG()
5. Raheem created a unique computer software and wants to protect his creation from being copied or used without his permission. He is considering to apply for legal protection. Which type of intellectual property protection should Raheem apply for, to safeguard his software ?
a) Copyright
b) Plagiarism
c) Trademark
d) Lease
6. What is the default index type for a Pandas Series if not explicitly specified ?
a) String
b) List
c) Numeric
d) Boolean
7. In Python which function of matplotlib library is used to save a plot?
a) save()
b) saveplot()
c) export()
d) savefig()
8. State whether the following statement is True or False :
The MOD() function in SQL returns the quotient of division operation between two numbers.
9. Which of the following data structure is used for storing one-dimensional labelled data in Python Pandas ?
a) Integer
b) Dictionary
c) Series
d) DataFrame
10. Priya received an email that appeared to be from her bank, asking her to update her account information by clicking on a link. She clicked the link to enter her details, but immediately after, some amount was debited from her account. What type of cybercrime did Priya fall victim to?
a) Cyber stalking
b) Phishing
c) Fishing
d) Cyber bullying
11. Which SQL function calculates ab?
a) MOD()
b) POWER()
c) RAISE()
d) ROUND()
12. Which protocol is used while communicating through video calls on the Internet?
a) Video Over Internet Protocol
b) Voice Over Internet Protocol
c) Internet Protocol
d) Video Audio Over Internet Protocol
13. Which of the following Python statements will be used to select a specific element having index as points, from a Pandas Series named ser?
a) ser.element(points)
b) ser.select (points)
c) ser[points]
d) ser.show[points]
14. Excessive screen time and poor posture can lead to :
a) Faster Internet Speeds
b) Eye strain and other health issues
c) Better vision and bone density
d) Improved physical health
15. Which of the following libraries defines an ndarray in Python ?
a) pandas
b) numpy
c) matplotlib
d) scipy
16. With respect to SQL, match the function given in column-2 with categories given in column-1 :
| Column-1 | Column-2 | ||
| (i) | Math function | (a) | COUNT() |
| (ii) | Aggregate function | (b) | ROUND() |
| (iii) | Date function | (c) | RIGHT() |
| (iv) | Text function | (d) | YEAR() |
b) (i)-(b), (ii)-(a), (iii)-(d), (iv)-(c)
c) (i)-(d), (ii)-(b), (iii)-(a), (iv)-(c)
d) (i)-(b), (ii)-(c), (iii)-(d), (iv)-(a)
17. Which of the following Python statements is used to change a column label in a DataFrame, df?
a) df = df.rename ({old_name : new_name}, axis='columns')
b) df = df.rename (old_name, new_name), axis='columns'
c) df = df.change_name (old_name, new_name, axis='bar')
d) df = df.update ({old_name : new_name), axis='bar'
18. In Python Pandas, DataFrame. _________ [ ] is used for label indexing with DataFrames.
a) label
b) index
c) labindex
d) loc
19. Every web page on the Internet has a unique address. This address is known as :
a) Domain Name
b) Protocol
c) Uniform Resource Locator
d) Network Topology
20. Assertion (A): The drop () method in Pandas can be used to delete rows and columns from a DataFrame.
Reason (R): The axis parameter in the drop () method specifies whether to delete rows (axis=0) or columns (axis=1).
a) Both Assertion (A) and Reason (R) are True and Reason (R) is the correct explanation for Assertion (A).
b) Both Assertion (A) and Reason (R) are True and Reason (R) is not the correct explanation for Assertion (A).
c) Assertion (A) is True and Reason (R) is False.
d) Assertion (A) is False, but Reason (R) is True.
21. Assertion (A): The ROUND () function in SQL can be used to round off a number to a specified number of decimal places.
Reason (R): The ROUND () function is a string function that accepts character values as input and returns numerical values as output.
a) Both Assertion (A) and Reason (R) are True and Reason (R) is the correct explanation for Assertion (A).
b) Both Assertion (A) and Reason (R) are True and Reason (R) is not the correct explanation for Assertion (A).
c) Assertion (A) is True and Reason (R) is False.
d) Assertion (A) is False, but Reason (R) is True.
SECTION – B
22. (a) Mention any two main points of difference between Series and DataFrame of Python Pandas.
OR
(b) Explain how we can access elements ofa series using slicing. Give an example to support your answer.
23. A small tech startup, is considering using open source software to develop their new project management tool. They are evaluating the benefits and potential challenges of adopting open source solutions.
(i) ldentify one key benefit of using open source software for the development of project management tool.
(ii) Give any two examples of open source software.
24. Consider the string, “Infornatics Practices “. Write suitable SQL queries for the following :
(i) To convert the entire string to uppercase.
(ii) To display the total number of characters in the given string.
25. Give any two points of difference between Static web page and Dynamic web page.
OR
(b) Describe the role of a router in a network.
26. What is a Database Management System (DBMS) Mention any two examples of DBMS.
27. Give any two impacts on environment that are caused when e-waste is carelessly thrown or dumped in landfills or dumping grounds.
28. (a) Rohit is trying to create a Pandas Series from scalar values. His code has some mistakes. Rewrite the correct code and underline the corrections made.
import pandas
data = [50, 15, 40]
series = pd.series (data, Index=[‘x’ , ‘y’, ‘z’])
Print(series)
OR
(b) Complete the given Python code to generate the following output:
| COLOUR | NAME | QTY | |
| 0 | Red | Apple | 10 |
| 1 | Blue | Berry | 15 |
| 2 | Green | Guava | 20 |
data=[{‘COLOUR’:’Red’, ‘NAME’:’Apple , ‘QTY’ :10},
{‘COLOUR’:’Blue’, ‘NAME’:’Berry’ , ‘QTY’:15},
{_____, ‘NAME’ : ‘Guava’ , ‘QTY’:20}]
df=pd.DataFrame (______)
print(_____)
SECTION – C
29. Ravi is a student studying in grade 12. He frequently uses the internet for various activities such as social networking, online shopping, and to research for school projects. Recently, he noticed that he receives targeted advertisements based on his browsing history and is concerned about his digital footprint. Additionally, Ravi has encountered instances of cyberbulying and is unsure how to handle them, Help Ravi by answering the following questions:
(i) What are digital footprints, and how are they created?
(ii) Write any two net etiquettes that Ravi should follow to ensure respectful and responsible online behavior.
(iii) How can Ravi protect himself from cyberbullying? Mention any one protective measure.
30. Write a Python program to create the following DatakFrame using a Dictionary of Series :
| City | State | |
| 0 | Mumbai | Maharashtra |
| 1 | Dehradun | Uttrakhand |
| 2 | Bengaluru | Karnataka |
| 3 | Hyderabad | Telangana |
Write a Python program to create a Pandas Series as shown below from an ndarray containing the numbers 10, 20, 30, 40, 50 with corresponding indices ‘A’, ‘B’, ‘C’, ‘D’, ‘E’.
| A | 10 |
| B | 20 |
| C | 30 |
| D | 40 |
| E | 50 |
31. (i) Write the SQL statement to create a table, Customer with the following specifications :
| Column Name | Data Type | Key |
|---|---|---|
| CID | Int | Primary Key |
| FName | Varchar(20) | |
| LName | Varchar(20) | |
| Age | Int |
(ii) Write the SQL query to display all records in descending order of LName from the Table Customer.
32. (a) Given the following tables:
Table: STUDENTS
| S_ID | NAME | AGE | CITY |
|---|---|---|---|
| 1 | Rahul | 20 | Delhi |
| 2 | Priya | 22 | Mumbai |
| 3 | David | 21 | Delhi |
| 4 | Neha | 23 | Bengaluru |
| 5 | Khurshid | 22 | Delhi |
Table: GRADES
| S_ID | SUBJECT | GRADE |
|---|---|---|
| 1 | Math | A |
| 2 | English | B |
| 3 | Math | C |
| 4 | English | A |
| 5 | Math | B |
(i) To display the number of students from each city.
(ii) To find the average age of all students.
(iii) To list the names of students and their grades.
OR
(b) Consider the following tables:
Table1: PRODUCTS
This table stores the basis details of the products available in a shop
| PID | PName | Category |
|---|---|---|
| 201 | Laptop | Electronics |
| 202 | Chair | Furniture |
| 203 | Desk | Furniture |
| 204 | Smartphone | NULL |
| 205 | Tablet | Electronics |
Table2: SALES
This table records the number of units sold for each product.
| SaleID | PID | Category |
|---|---|---|
| 301 | 201 | 50 |
| 302 | 202 | 100 |
| 303 | 203 | 60 |
| 304 | 204 | 80 |
| 305 | 205 | 70 |
(i) To delete those records from table SALES whose UnitsSold is less than 80.
(i) To display names of all products whose category is not known.
(iii) To display the product names along with their corresponding units sold.
SECTION – D
SECTION – E