Informatics Practices Question Paper 2023

General Instructions :

1. This question paper contains five sections, Sections A to E
2. All questions are compulsory.
3. Section A has 18 questions carrying 1 mark each.
4. Section B has 7 very short answer-type questions carrying 2 marks each.
5. Section C has 5 Short Answer type questions carrying 3 marks each.
6. Section D has 3 Long Answer type questions carrying 5 marks each.
7. Section E has 2 questions carrying 4 marks each.
8. All programming questions are to be answered using Python Language only

Part-A

1. Which of the following topologies is very efficient and all nodes are  connected to a central hub?

a) Star                                           b) Bus                                            c) Tree                                            d) Ring

2. Ramandeep is a young woman with great aspirations and has a good team of like-minded people. She along with her team members started a company to sell handicrafts online and also designed a logo for their company. What type of intellectual property does this logo represent?

a) Patents                                      b) Design                                    c) Copyright                                 d) Trademark

3. Which of the following is a type of cybercrime where objectionable and demeaning comments are posted on social media platform about a person, such that he/she is mentally harassed?

a) Phishing                                   b) Cyber bullying                        c) Hacking                                   d) Identity Theft

4. Which is the correct output of the following SQL command? SELECT ROUND (7876.4568, 2);

a) 7876.46                                      b) 7876.45                                    c) 7900                                        d) 4568

5. Aggregate functions are also known as:

a) Scalar Functions                     b) Single Row Function            c) Multiple Row Function       d) Hybrid Functions

6. Primary law in India for matters related to e-commerce and cyber crime is:

a) IT Act 1995                              b) IT Act 1998                              c) IT Act 2000                            d) IT Act 2010

7. Ravisha has stored the records of all students of her class in a MYSQL table. Suggest a suitable SQL clause that she should use to display the names of students in alphabetical order.

a) Sort By                                     b) Group By                                  c) Align By                                  d) Order By

8. To remove the leading and trailing space from data values in a column of MySql Table, we use

a) Left()                                         b) Trim()                                        c) Right()                                    d) LTrim()

9. If the substring is not present in a string, the INSTR() returns:

a) -1                                                b) 1                                                 c) 0                                               d) NULL

10. What will be the output of the following code?

11. Which of the following is a two-dimensional labelled data structure of Python?

a) Relation                                      b) Series                                 c) Dataframe                                       d) Square

12. To compare data values of commission earned by salesmen over a year, which of the following type of graph should preferably be used?

a) scatter                                        b) line                                      c) area                                                d) bar

13. Which of the following is not a web browser?

a) Opera                                       b) linux                                     c) Google Chrome                              d) Mozilla Firefox

14. Which of the following is not a valid aggregate function in MYSQL?

a) Count()                                     b) Max()                                    c) Sum()                                               d) Len()

15. The digital footprint that we leave online unintentionally is called

a) Active digital footprint       b) True digital footprint      c) Passive digital footprint      d) False digital footprint

16. E-waste is responsible for the degradation of our environment if not properly treated or disposed of. Some of the feasible methods of e-waste management are reduce,_________ and recycle

a) reuse                                        b) resubmit                                    c) recheck                                     d) regular

Q17 and 18 are ASSERTION (A) and REASONING (R) based questions. Mark the correct choice as Both (A) and (R) are true and (R) is the correct explanation for (A). Both (A) and (R) are true and (R) is not the correct explanation for (A). (A) is true and (R) is false. (A) is false but (R) is true.

17. Assertion (A): A static webpage does not change for each person visiting the web page. Reason (R): When a web server receives a request for a dynamic web page, it locates and updates the page and sends it to the browser of the client

18. Assertion (A): The output of addition of two series will be NaN if one of the elements or both the elements have no value(s). Reason (R): While performing mathematical operations on a series, by default all missing values are filled in with 0.

Part-B

19. What is web server ? How is it different from web browser?

or

What do you understand by the term cookies? Give any two benefits of cookies.

20. Keshav has written the query to find out the sum of bonus earned by the employees of WEST zone SELECT zone,total(bonus) FROM employee Having zone=’WEST’; But he got an error. Identify the errors and rewrite the query by  underlining  the correction(s) done

21. Differentiate between Count( )and count(*) functions in MYSQL.Give suitable examples to support your answer.

22. Write a python program to create series object country using a list that stores the capital of each country

23. Explain plagiarism with an example.

or

Nowdays all of us frequently use social media to connect with our  friends. Give any two netiquettes that we should follow while communicating on social media.

24. what will be the output of following code

25. Carefully observe the following code :

i) In the data frame player created above set the row labels as  ‘player1’, ‘player2’, ‘player3’,  ‘player4’, ‘player5’

ii) Rename the column ‘points’ to ‘netpoint’ in the DataFrame player.

SECTION – C

26. Consider the table Patient given below and write SQL commands.

                                            Table: Patient

27. Kavyaanjali, a chemical analyst needs to arrange data of few elements in the form of two series containing symbols and their atomic numbers respectively . Thereafter, the data of these two series has to be arranged  and displayed in the           form of data as shown below:

Help her in writing suitable Python code to complete the task.

28. Consider the given DataFrame ’health’.

Write suitable Python statements for the following :

29. Manohar received an email from a company, named Makemoney Pvt. Ltd., claiming that Manohar has won Rupees 20 lakhs in a survey done online. In order to claim the prize money, he was required to answer few security questions such as his Name, Account number, PAN card details , Phone number and OTP for verification purposes. For this he had to click on the link provided in the email.

(i) Should Manohar give the required details to the company?

(ii) What is the activity depicted above?

(iii) what should he do with this email?

OR 

What do you understand by the term Hacking? Write any two measures that one should take to avoid being the victim of hacking.

30. Write the output(i-iii) for the following SQL commands.

                                                 Table: FASHION

SECTION-D

OR

32. XEED Private Ltd., Delhi is a company that deals with educational toys. They have Different divisions HR (A1) , Sales (A2).Production (A3) and Marketing(A4).

The layout of the Delhi branch is :

IMAGE

The company also has branch in Bangalore .The management wants to connect all the divisions as well as all the                     computers of each  division (A1,A2,A3,A4).

The distance between the wings is as follows:

Number of computers in each of the wing :

Based on the above specifications, answer the following questions:

33. Consider the following graph. Write the Python code to plot it . Also add the Title, label of the X and Y axis.

Use the following data for plotting the graph

Smarks=[10,40,30,60,55]

Sname=[“sahil”,”Depak”,”Anil”,”Ravi”,”Riti”]

OR

Write Python code to draw the following bar graph representing the total sales in each quarter. Add the Title, label for X-axis and Y-axis.

Use the following data for plotting for graph:

Sales= [450,300,500,650]

Qtr = [“QTR1”,”QTR2”,”QTR3”,”QTR4”]

Section –E

    34. Consider the following table Schooldata:

Write SQL queries for the following:

35. Consider the following DataFrame ‘mdf’.