Class 12 Sample Paper Informatics Practices (Half Yearly)

SAMPLE
PAPER
Half Yearly Examination

Prepared For
NCERT BASED SYLLABUS
Applicable For
CBSE BOARD AND STATE BOARD USING NCERT

WWW.

HALF YEARLY EXAMINATION
SAMPLE QUESTION PAPER

Class: XII Max Marks: 70
Subject: Informatics Practices Time: 3 Hrs.
________________________________________________________________________________________
General Instructions:
1. This question paper contains two parts, A and B. Each part is compulsory.
2. Part A has two sections:
Section-I is short answer questions, to be answered in one word or one line (Any 20 question).
Section-II has two case study questions. Case study has 5 sub-part each with 1 mark with 1X10=10 marks
3. Part B is Descriptive Paper, has three sections:
Section-I is short answer questions of 2 marks each with 2X10=20 marks
Section-II is long answer questions of 3 marks each with 3X4=12 marks
Section-III is very long answer questions of 4 marks each 4X2=8 marks
_________________________________________________________________________________________
PART-A: Section-I
[ Attempt any 20 questions from questions 1 to 21 : 1X20=20 ]
1. State whether True or False: (1)
(i) Copying someone else’s work or programs and claiming them as your own is an act of plagiarism.
(ii) Cyber bullying is an attempt to acquire sensitive information such as usernames, passwords and credit
card details by sending emails or instant messaging.
2. Fill in the blanks: (1)
T20 match analysis in Dubai is to be plotted. The command used to give title to y-axis as ‘Total Score’ of each
team in a graph is..............
(i) plt.show() (ii) plt.plot("TotalScore")
(iii) plt.ylabel("Total Score") (iv) plt.title("TotalScore")
3. Write the output of the following SQL command. (1)
Select Round(67834.238,-3);
(i) 68000 (ii) 67000
(iii) 67834.000 (iv) 70000
4. Which method is used to access horizontal subset of a DataFrame? (1)
(i) iterrows( ) (ii) sort_values()
(iii) head() (iv) iteritems()
5. In Pandas, emp is a Series that stores names of the employees. (1)
emp=pd.Series(“Archana”, “Tiya”, “Manit”, “Sanskaar”)
Which command is used to assign the index as (“Emp1”, “Emp2”, “Emp3”, “Emp4”) explicitly?
(i) emp_index=('Emp1', 'Emp2','Emp3','Emp4')
(ii) emp.index =('Emp1', 'Emp2','Emp3', 'Emp4')
(iii) emp.index=['Emp1','Emp2','Emp3','Emp4']
(iv) emp[index]=('Emp1','Emp2','Emp3','Emp4')
6. A histogram displays numerical data by grouping data into ............. of equal width. (1)
7. This protocol is used to send email messages over the internet. (1)
8. ...........Refers to tabular data saved as plain text where data values are separated by commas. (1)
9. Consider a series object vls, created using following statement: (1)

vls= pd.Series([11, 23, 31, 61, 87, 93], index=[‘a’, ‘b’, ‘c’, ‘d’, ‘f’])
……………………………………………………….. statement retrieves and prints the first three elements.
10. IT Act (Cyber law) was introduced in India in the year………………………………… (1)
(i) 2000 (ii) 2008 (iii) 2009 (iv) 2014

[Pg-1]

11. A ............ is a set of one or more columns of a table that uniquely identifies a record in a database table but
accepts only one null value. (1)
(i) Primary Key (ii) Unique Key
(iii) Foreign key (iv) Candidate key
12. .....is a document that provides legally binding guidelines for the use and distribution of software. (1)
13. Write the output of the following code: (1)
import pandas as pd
Ser1=pd.Series(range(8),index=['A','B','C', 'D', 'E', 'F', 'G', 'H'])
print(Ser1)
14. To save the transactions permanently by SQL the command is: (1)
(i) COMMIT (ii) ROLLBACK (i) SAVEPOINT (ii) TRANCATE
15. Write the output of the following code: (1)
import pandas as pd
Marks=pd.Series({'Rahul':80, 'Aarush':98, 'Shobhit':89, 'Krish':90})
print(Marks[Marks>85])
16. Phishing is: …………………………………… (1)
(i) Asking to visit an unknown web site (ii) Clicking a link to takes to an unauthorized site
(iii) Hacking an account (iv) Online fraud
17. Define Trademark grants ______________ (1)
(i) Legal right (ii) Ownership right (i) Brand right (ii) All
18. The ............. command is used to see the structure of the table. (1)
19. Write the output of the following code: (1)
import pandas as pd
a=pd.Series([78,45,89,98])
b=pd.Series([67,87,90])
student={"English":a,"Hindi":b}
df=pd.DataFrame(student)
print(df)
20. Once one copies a content of the other source without consent, then it comes under__________ (1)
(i) Copyright violation (ii) Plagiarism
(iii) Trademark Infringement (iv) None of these
21. Name the term to describe taking control over a system, etc. by a third person or group. (1)

Part-A: Section-II
[ Both the case study-based questions (22 & 23) are compulsory: (1X5)X2=10]

22. Consider the following DataFrame df and answer the questions from (i) – (v)
RollNo Name UT1 UT2 UT3 UT4
0 1 Pratima Sinha 29 30 19 20
1 2 Manoj Gupta 20 18 18 24
2 3 Tathagata Patra 18 22 20 20
2 4 Firoz Khan 22 23 27 22
4 5 Kirti Rani 15 24 29 21
5 6 Raman Kumar 21 15 23 30
6 7 Bineet Banerjee 28 16 24 33

(i) Select the options from the command that will give the following output: (1)
Roll No 7
Name Tathagata Patra
UT1 29

UT2 30
UT3 29
UT4 33
dtype: object
(a) print(df.max)
(b) print(df.max())
(c) print(df.max(axis is=1))
(d) print(df.max, axis=1)

[Pg-2]

(ii) The teacher needs to know the marks scored by the student with roll number 7. Help him/her to identify the
correct set of statements from the given options (More than one may be correct): (1)
(a) df1=df [roll no = =7]
print (df1)
(b) df1=df [df [‘rollno’] = =7]
print (df1)
(c) df1=df [df.rollno = = 7 ]
print (df1)
(d) df1=df [rollno.df = =7]
print (df1)

(iii) Which of the following statement/s will give the exact number of values in each column of the DF? (1)
(i) print( df.count( ) )
(ii) print( df.count(0) )
(iii) print(df.count)
(iv) print(df.count(axis = ‘index’))
Choose the correct option:
(a) both (i) and (ii)
(b) only (ii)
(c) (i), (ii) and (iii)
(d) (i), (ii) and (iv)

(iv) Which of the following command will display the column labels of the DF? (1)
(a) print( df.columns( ))
(b) print( df.column)
(c) print( df.columns)
(d) print( df.column( ))
(v) A student Neeraj wants to add a new column, the score of Grade with the values ‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’,
‘A1’, ‘A1’ to the DataFrame. Help him choose the command to do so: (1)
(a) df[‘Grade’] = [‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’]
(b) df.column = [‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’]
(c) df.loc[‘Grade’] = [‘B1’, ‘B2’, ‘A2’, ‘B2’, ‘B1’, ‘A1’ , ‘A1’]
(d) both b and c are correct.

23. Consider the table EMPLOYEE given below and answer questions (i) to (v):
Emp_id Name DOJ Sex City Grade Salary
111 Jugal 21/05/1998 M Delhi A 8000
222 Sharmila 21/05/1997 F Mumbai B 9000
333 Sandeep 29/08/1998 M Kochi A 8000
444 Sangeeta 13/06/1996 F Kolkata B 10000
555 Rakesh 31/10/1999 M Mumbai C 9000
666 Shyam 21/05/1989 M Bangalore A 8000
777 Aishwarya 11/01/1990 F Delhi B 12000
(i) Select the command from the options that will give the output as: (1)
Name
Jugal
Sandeep
Shyam
(i) Select name from EMPLOYEE where Gender= ‘M’ AND Salary>7000;
(ii) Select name from EMPLOYEE where Gender= ‘M’ OR Grade=A;
(iii) Select name from EMPLOYEE where Gender= ‘M’ AND Grade= ‘A’;
(iv) Select name from EMPLOYEE where Salary=8000 AND NOT Grade=’B’ ;
Choose the correct option
(a) Both (i) and (ii)
(b) Both (ii) and (iii)

(c) Only (iii)
(d) Only (iv)

[Pg-3]

(ii) What will be the output of the following command: (select from options): (1)
Select Name, DOJ from EMPLOYEE where Gender = “F” Order By Name;

(a) Name DOJ
Sharmila 1997-05-21
Sangeeta 1996-06-13
Aishwarya 1990-02-11

(b) Name DOJ
Sangeeta 1996-06-13
Sharmila 1997-05-21
Aishwarya 1990-02-11

(c) Name DOJ
Aishwarya 1996-06-13
Sangeeta 1997-05-21
Sharmila 1990-02-11
(d) Name DOJ
Aishwarya 1990-02-11
Sangeeta 1996-06-13
Sharmila 1997-05-21
(iii) Aman has given the following command to obtain the total salary of female employees. (1)
“SELECT sum(salary) FROM Employee”
But she is not getting the desired result. Help her by writing the correct command.
(a) select sum(salary) from EMPLOYEE where group by ‘F’;
(b) select sum (salary) from EMPLOYEE where sex=‘F’ group by sex;
(c) select sum(salary) from EMPLOYEE having sex=’F’ group by sex;
(d) select sum(salary) from EMPLOYEE group by sex having sex= ‘F’;

(iv) Help Raman to write the command to display the name of the employee having more experience: (1)
(a) select name, Min(DOJ) from EMPLOYEE;
(b) select name, Max(DOJ) from EMPLOYEE;
(c) select name, Min(DOJ) from EMPLOYEE group by name;
(d) select name, Maximum(DOJ) from EMPLOYEE;

(v) State the command to display the average(salary) of employees of each grade. (1)
(a) select grade, average(salary) from EMPLOYEE where group by Grade;
(b) select grade, avg(salary) from EMPLOYEE where grade= ‘A’, ‘B’, ‘C’;
(c) select grade, avg(salary) group by Grade from EMPLOYEE ;
(d) select grade, avg(salary) from EMPLOYEE group by Grade ;

PART-B: Section-I
[ Attempt all questions: 2X10=20]
24. Write Python code to create the following DataFrame books using Python Pandas. Also assign index as
‘B1’,‘B2’,‘B3’,‘B4’ to the DF books. (2)

BookName Class Price
Let us C BCA 270
Artificial Intelligence B.Tech 350
Database Management BCA 450
Computer Architecture BCA 550

25. What is the difference between a WHERE and HAVING clause of SQL SELECT statement? (2)
OR
Differentiate between Aggregate functions and Single row functions.
26. Write the output of the following SQL commands: (2)
(i) Select Mod(13,3);
(ii) Select Power(5,3);
(iii) Select Length("Data Science");
(iv) Select Month(‘2020-03-12’);

[Pg-4]

27. What will be the output of the following program: (2)
import pandas as pd
a=pd.Series([10,20,30,40,50],index=['a','e','i','o','u'])
print(a*5)
print(a<30)
a['i']=1000
print(a)
28. Write a python code to create a DataFrame with column heading (a and b) from the list given below: (2)
[[1, 2], [3, 4], [5, 6], [7, 8]]
29. Consider the following SQL string: “IndoAryan Existentialism” (2)
Write the use of SUBSTR command to display:
(i) “Indo” (ii) “Existentialism”
OR
Considering the same string “IndoAryan Existentialism”, write SQL commands to display:
(i) the position of the substring ‘Ary’ in the string “IndoAryan Existentialism”
(ii) Replace the word ‘Existentialism’ with “3M”

30. Lekisha wants to plot a bar chart for the students of 9th class of different sections who have opted for the
given subjects. Complete the code to perform the following operations: (1+0.5+0.5=2)
(i) To plot bar chart using the given data set of subjects and students.
(ii) To provide xticks as subjects with Graph heading “Result Analysis Report”.
import matplotlib.pyplot as plt
Students=[10,12,15,17,19]
Subject=["French","Sanskrit","ICT", "Music","Art"]
_______________ // Statement 1
_______________ // Statement 2
_______________ // Statement 3
plt.show()
31. Given a DataFrame df as shown below: (2)
Col-1 Col-2 Col-3 Res
t1 100.0 100.0 60.0 True
t2 95.8 100.0 57.48 True
t3 89.3 100.0 53.58 False
t4 82.0 85.4 49.20 False
Write statements to do the following:
(i) Extract the values of row t2’s & column col2’s.
(ii) Rearrange the records in descending order on Col-1.

32. Deepanjali received an SMS from her bank querying a recent transaction that she made online and asking
for the pin number. Answer the following questions as to what she should do on receiving this SMS. (2)
(i) Should she SMS her pin number to the given contact number?
(ii) Should she call the bank helpline number to recheck the validity of the SMS received?

33. Why does often you find continuous advertisement at your social media accounts, that promotes the article
you have searched recently on the internet? Explain. (2)
OR
What do you understand by net Etiquettes? Explain any two such etiquettes.

Part-B: Section-II

[Attempt any 4 questions: 3X4=12]
34. Given a DataFrame namely sal as shown below: (3)
Qtr1 Qtr2 Qtr3 Qtr4
North 65 83 92 84
South 85 82 92 93
East 83 84 87 86
West 74 83 93 92
Central 82 84 94 87

[Pg-5]

Write statement to do the following :
(a) Write a code that has accessed the data of the above DF from a csv file, ‘sal.csv’
(b) Change the indexes “North”,“South”,“East”,“West”,“Central” to “N”,“S”,“E”,“W”,“C” respectively.
(c) Write code to store the dataframe in a csv file ‘salary.csv’ whose path is d:\salary.csv

35. What are the challenges of e-Waste? How can it be managed and reused? (3)
OR
What is the difference between copyright and patent? Write a brief note on Cyber Law act in India.
36. A dictionary ‘toys’ contains the following: (3)
toys= {‘Name’: [‘Talking Tom’, ‘Blocks’,‘Number game’, ‘ludo’], ‘Price’: [400,250, 300,150]}
Write statements for the following using the above dictionary:
(i) Create a DataFrame named “stock”
(ii) Add a column called ‘discount’ with the following
data: [ 30, 40, 15, 25]
(iii) Delete column discount with all values.

37. A relation Product is given below: (3)

P_No Ptype P_Manufacturer Price Qty
P1001 Pencil Natraj 15 20
P1002 Ball Pen Reynolds 10 50
P1003 Gel Pen Flair 20 100
P1004 Sketch Pen Doms 50 35
P1005 Paint Brush Doms 30 15
P1006 Pencil Natraj 15 30
P1007 Ball Pen Reynolds 10 10
P1004 Sketch Pen Doms 50 60
Write SQL commands to:
(i) Display the Average price of each type of Product having quantity more than 30.
(ii) Increase the price of the products manufactured by Doms by 2%.
(iii) Display the Maximum and Minimum price of all types of Products.

38. Write a code to plot the Sales Percentage of Bags for the last 6 months as shown in the figure given
below: (3)

OR

[Pg-6]

Write a code to plot the histogram to display the total runs scored by India in a match as shown in the
figure given below: Runs=[70, 120,180,240, 300]

Part-B: Section-III
[Attempt all: 4X2=8]

39. Write a program in Pandas to create the following DataFrame TotalMarks from a Dictionary: (4)

RollNo Name TERM I TERM II
1 Anshu 55 76
2 Prachi 82 88
3 Divyansh 95 98
4 Chetan 76 78
5 Sahil 68 65

Perform any four the following operations on the DataFrame TotalScore:
(i) Create a DataFrame TotalMarks.
(ii) Add both sum of the Marks of a Student (Term I & II) to a new added column “Total”.
(iii) Display the highest marks in both TERM I and TERM II of the DataFrame.
(iv) Display the records in descending order on the values of TERM-I
(v) Display the records of 2nd & 3rd rows and 3rd & 4th columns if assigned index are ‘One’, ‘Two’, ‘Three’,
‘Four’, ‘Five’ respectively.
40. Write any Four of the SQL functions (command) which will perform the following operations: (4)
(i) To display the string (“Information Technology”) in Uppercase.
(ii) To remove spaces from the beginning and end of a string, “ Informatics ”.
(iii) To display the name of the day, e.g., Friday or Sunday from your date of birth, dob.
(iv) To display the starting position of your first name(say ‘fname’) from your whole name( say ‘name’).
(v) Write the output: SELECT UPPER(LEFT(MID("Informatics Practices", 12, Length("Indo Aryan")),9));

###

AglaSem Earn while Learn Program. Send your papers and get paid.
[Pg-7]
Contact: support@