Page 1 Sample Paper 2 INFORMATICS PRACTICES Class 12

Sample Paper 2
INFORMATICS PRACTICES (065)
CLASS XII 2023-24
Time: 3 Hours Max. Marks: 70
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A has 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 02 questions carrying 04 marks each.
7. Section E has 03 questions carrying 05 marks each.
8. All programming questions are to be answered using Python Language only.

Section A
1. The term plagiarism is not related to _____.
(a) illegal software copy (b) illegal use of patents
(c) stealing others E-mail password (d) None of these

2. _____ is a set of moral principles that governs the behaviour of a group or an individual and regulates the use of
computers.
(a) Copyright (b) Computer ethics
(c) Property rights (d) Privacy law

3. The columns of DataFrame can be

(a) heterogeneous (b) homogeneous
(c) Both (a) and (b) (d) None of these

4. The term e-Waste can also be called as _____.

(a) WEEE (b) WEST
(c) WET (d) None of these

5. Code of the software will be protected by

(a) copyright (b) patent
(c) registered trademark (d) None of these

6. Which of the following is not an aggregate function?

(a) AVG() (b) ADD()
(c) MAX() (d) COUNT()

Install NODIA App to See the Solutions.

Click Here To Install
Page 2 Sample Paper 2 INFORMATICS PRACTICES Class 12

7. Pandas is a _____.
(a) package (b) language
(c) library (d) software

8. The module that is required to create a Series is

(a) matplotlib (b) pyplot
(c) pandas (d) random

9. With the Internet help we can do _____.

(a) Exchange information with friends and colleagues.
(b) Access pictures, sounds, video clips and other media elements.
(c) Find diverse perspective on issues from a global audience.
(d) Exchange information, access pictures, find diverse perspective on issue from a global audience.

10. Which of the following is a valid SQL statement?

(a) SELECT MIN(pub_date) FROM books GROUP BY category HAVING pub_id = 4;
(b) SELECT MIN(pub_date) FROM books ORDER BY category = ‘COOKING’;
(c) SELECT COUNT(*) FROM orders WHERE customer# = 1005;
(d) SELECT MAX(COUNT(customer#)) FROM orders GROUP BY customer#;

11. Home page helps viewers to find out what they can find on the particular site. Home page is the _____.
(a) first page of a website
(c) about page
(b) index page
(d) None of these

12. Which of the following is an open source license?

(a) GNU (b) BSD
(c) Apache (d) All of these

13. What is the meaning of “GROUP BY” clause in MySQL?

(a) Group data by column values (b) Group data by row values
(c) Group data by column and row values (d) None of these

14. Find odd one out.

(a) GROUP BY (b) DESC
(c) ASC (d) ORDER BY

Install NODIA App to See the Solutions.

Click Here To Install
Page 3 Sample Paper 2 INFORMATICS PRACTICES Class 12

15. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following
MySQL statement?
SELECT emp_id
FROM person ORDER BY emp_id;
(a) {1, 2, 3, 4, 6, 7, 9} (b) {2, 1, 4, 3, 7, 9, 6}
(c) {9, 7, 6, 4, 3, 1, 2} (d) None of these

16. Identify the correct INSERT queries from the following :

(a) INSERT INTO Persons(‘xxx1’, ‘yyy1’);
(b) INSERT INTO Persons (LastName, FirstName) Value (‘xxx’, ‘yyy’);
(c) INSERT INTO Persons Values (‘xxx1’, ‘yyy1’);
(d) INSERT INTO Persons Value (‘xxx1’, ‘yyy1’);

Directions (Q.Nos. 17-18) Assertion and Reason based Questions.

17. Assertion (A) The name Bluetooth is derived from Harald Bluetooth, a king in Denmark.
Reason (R) Bluetooth is used for exchanging data over a short distance from fixed and mobile devices.
(a) Both A and R are true and R is the correct explanation for A.
(b) Both A and R are true and R is not the correct explanation for A.
(c) A is true but R is false.
(d) A is false and R is true.

18. Assertion (A) Pandas is an open-source Python library which offers high performance, easy to use data structures
and data analysis tools.
Reason (R) Professionals and developers are using the Pandas library in data science and machine learning.
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true but R is not the correct explanation of A.
(c) A is true but R is false.
(d) A is false but R is true.

Section B
19. List some factors which have led in rise of cyber crimes?

20. What is the purpose of ORDER BY clause in SQL? Explain with the help of suitable example.

21. Carefully observe the following code:

import pandas as pd
One={‘P’:5000,‘Q’:8000,‘R’:12000,
‘S’: 18000}
Two={‘A’:13000, ‘B’:14000, ‘C’:12000}
totSales={1:One, 2:Two}
df=pd.DataFrame(totSales)
Install NODIA App to See the Solutions.
Click Here To Install
Page 4 Sample Paper 2 INFORMATICS PRACTICES Class 12

print(df)
Answer the following:
(i) List the index of the DataFrame df
(ii) List the column names of DataFrame df.

22. List some benefits of networking. Name any two components required for networking.

o
Give an example of each static web page and dynamic web page.

23. The Python code written below has syntactical errors. Rewrite the correct code and underline the corrections made.
Import pandas as pd
Emp = {‘a’ : 10000, ‘b’ : 15000,
‘c’ : 12000}
Sr = pd.Series(Emp)
Print(sr)

24. A character expression name contains ‘try yourself’. Write a command to pick the following set of characters from
it.
(i) First 3 characters
(ii) From 3rd to 7th character

25. Complete the given Python code to get the required output as: 16
import _____ as np
data = [1, 4, 9, 16]
series_data = np._____(data)
print(series_data[______])

Section C
26. Write a small Python code to create a DataFrame with headings (a and b) from the list given below
[10, 20], [30, 40], [50, 60], [70, 80]

27. Consider the table EXAM given below. Write the queries for (i) to (iii).
Table : EXAM
S Name Stip-end Subject Average Division
No
1 Karan 400 English 68 Ist
2 Aman 680 Mathematics 72 Ist

3 Javed 500 Accounts 67 Ist

4 Bishakh 200 Informatics 55 IInd
5 Sugandha 400 History 35 IIIrd
6 Suparna 550 Geography 45 IIIrd

Install NODIA App to See the Solutions.

Click Here To Install
Page 5 Sample Paper 2 INFORMATICS PRACTICES Class 12

(i) To list the names of those students, who have obtained division as Ist in ascending order of Name.

(ii) To count the number of students, who have either Accounts or Informatics as Subject.

(iii) To display a report listing Name, Subject and annual Stipend received assuming that the Stipend column has
monthly stipend.

o

Reena is working with functions of MySQL.

Explain her following

(i) What is the purpose of NOW( ) function?

(ii) How many parameters does it accept?

(iii) What is the general format of its return type?

28. Given a DataFrame df as shown below

A B C
0 21 12 69
1 45 45 84
2 23 86 70
3 17 33 78
What will be the result of the following code statements?
(i) df[‘D’] = np.NaN
(ii) df[‘D’] = [23, 41, 32]
(iii) df[‘D’] = [23, 41, 32, 9]

29. Give the output of following commands.

(i) mysql>SELECT TRUNCATE (200.91,
1);
(ii) mysql>SELECT LEFT (‘Swati’, 4);
(iii) mysql>SELECT LENGTH
(“Information”);

30. Rahul has recently shifted to a new college and hostel. He does not know many people in his new college and hostel.
But all of a sudden, someone is posting negative, demeaning comments on his social networking profile etc.
He is also getting repeated mails from unknown people. Every time he goes online, he finds someone chasing him
online.

(i) What is this happening to Rahul?

(ii) What immediate action should he take to handle it?

(iii) Is there any law in India to handle such issues? Discuss briefly.


o
What is software licensing ? Name two types of software licensing with an example of each.

Install NODIA App to See the Solutions.

Click Here To Install
Page 6 Sample Paper 2 INFORMATICS PRACTICES Class 12

Section D
31. Mr. Ankit is working in an organisation as data analyst. He uses Python Pandas and Matplotlib for the same. He got
a dataset of the passengers for the year 2010 to 2012 for January, March and December. His manager wants certain
information from him, but he is facing some problems.
Help him by answering few questions given below:
Year Month Passengers
0 2010 Jan 25
1 2010 Mar 50
2 2012 Jan 35
3 2010 Dec 55
4 2012 Dec 65
(i) What will be the output of the following statements?
(a) df.shape( )
(b) df.index=[“AirIndia”, “Indi go”, “Spicejet”, “Jet”, “Emirates”]
(ii) Write the code to get the following output:
Month Passengers
0 Jan 25
2 Jan 35
(iii) Predict the output of print (df[1 : 3])


o (Option for part (iii) only)
Suppose a DataFrame df contains information about student having columns rollno, name, class and section.
Write the code to transpose DataFrame.

32. Tejasvi Sethi, a car dealer has stored the details of all cars in her showroom in a table CARMARKET. The table
CARMARKET has attributes CARCODE which is a primary key, CARNAME, COMPANY COLOR, COST (in
lakh) of the car and DOM which is the Date of Manufacture of the car.
Table : CARMARKET

CARC-ODE CARNAME COMPANY COLOR COST DOM

C01 BALENO SUZUKI BLUE 5.90 2019-11-07

C02 INDIGO TATA SILVER 12.90 2020-10-15

C03 GLC MERCEDES WHITE 62.38 2020-01-20

C04 A6 AUDI RED 58.55 2018-12-29

C05 INNOVA TOYOTA BLACK 32.82 2017-11-10

C06 WAGON-R SUZUKI WHITE 12.11 2016-11-11

C07 BREZZA SUZUKI GOLDEN 9.80 2016-10-03

Help her by writing answers of the following questions based on the given table.
(i) Display the carname along with the charges rounded off to 1 digit after decimal place.
(ii) Display the carname, name of the company in lower case of all cars whose year (of dom) is 2020.
Install NODIA App to See the Solutions.
Click Here To Install
Page 7 Sample Paper 2 INFORMATICS PRACTICES Class 12

(iii) Display the number of cars manufactured each year.

(iv) Display the carname, color and position of the character ‘E’ in the color of all the cars.

Section E
33. Green Valley Public School has 4 buildings in its campus . Distance between the buildings and the number of
computers in each is given below

Building Number of Computers

A 150
B 10
C 25
D 3

Building Distance
A-B 10 m
A-C 1250 m
A-D 25 m
B-C 30 m
B-D 2000 m

(i) Which building is best suitable for placement of server?

(ii) If building A to D is to be connected, which device will be required for strong signals?
(iii) Which building would need a switch/hub?
(iv) Which topology would you suggest for connecting computers in each building?
(v) Suggest and draw cable layout to efficiently connect various buildings within the school campus for a wired
connectivity.
34. Write down the syntax format of the following functions, with one example of each.
(i) LCASE(str)
(ii) UCASE(str)
(iii) RIGHT(str,n)
(iv) POWER(m,n)
(v) RTRIM(str)

Install NODIA App to See the Solutions.

Click Here To Install
Page 8 Sample Paper 2 INFORMATICS PRACTICES Class 12

o
Consider the table DOCTOR given below. Write commands in SQL for (i) to (iv) and answer the question for (v).
Table : DOCTOR
ID DOCName Department DOJ Gender Salary
1 Amit Kumar Orthopaedics 1993-02-12 M 35000
2 Anita Hans Paediatrics 1998-10-16 F 30000
3 Sunita Maini Gynaecology 1991-08-23 F 40000
4 Joe Thomas Surgery 1994-10-20 M 55000
5 Gurpreet Kaur Paediatrics 1999-11-24 F 52000
6 Anandini Burman Oncology 1994-03-16 F 31000
7 Siddharth Dang Surgery 1995-09-08 M 47000
8 Rama Mukherjee Oncology 2000-06-27 F 54500

(i) Display the names and salaries of doctors in descending order of salaries.
(ii) Display names of each department along with total salary being given to doctors of that department.
(iii) Display the number of doctors in each department.
(iv) To display all the female doctors from the given data.
(v) Identify the primary key from the table DOCTOR.

35. A bar graph is used to show individual figures at a specific time or to compare different items. Similarly, a bar graph
which is showing the marks of different subjects. You have to write the code that will represent the given graph.

Write a Python code to create a line graph for the data given below based on Games apps rated by the users.
Games = [“Subway Surfer”, “Temple Run”, “CandyCrush”, “Bottle Shot”, “Runner Best”]
Rating= [4.2, 4.8, 5.0, 3.8, 4.1]

EN

Install NODIA App to See the Solutions.

Click Here To Install