MODEL TEST PAPER–1
CLASS XII
INFORMATICS PRACTICES (065)
Maximum Marks: 70 Time Allowed: 3 hrs
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 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each.
8. All programming questions are to be answered using Python Language only.
SECTION – A
1. Which protocol is used for sending and receiving email messages? (1)
(a) PPP (b) SMTP
(c) POP3 (d) VoIP
2. Using someone else’s Facebook account to post something will be termed as: (1)
(a) Fraud (b) Online stealing
(c) Violation (d) Identity theft
3. Which of the following measures should not be adopted to recycle e-waste safely? (1)
(a) Donate to NGO (b) Sell your old electronics
(c) Burn your e-waste (d) Give your e-waste to a certified e-waste recycler
4. In a table named ‘Student’, if a column “Name” contains the data set (“Rashi”, “Shreyas”, “Nitya”, “Rashi”,
“Nitya”, “Nityam”, “Kavya”, “Rashi”), what will be the output after the execution of the given query? (1)
SELECT COUNT(DISTINCT Name) FROM student;
(a) Error – cannot work on char data type (b) 5
(c) “Five” (d) No output
5. What will be the order of the data being sorted after the execution of given SQL query? [1]
SELECT * From School Order by Class;
(a) Order of inserting records in a table (b) Ascending order
(c) Descending order (d) None of these
6. The term ‘Intellectual Property Rights’ covers: [1]
(a) Copyrights (b) Trademarks
(c) Patents (d) All of these
7. Consider a table named Employees with columns – EName, Age, Salary and Designation. Which SQL
statement do we use to find out the total salary given to employees? (1)
(a) Select SUM(Salary) From Employees; (b) Select COUNT (*) From Employees;
(c) Select FIND (*) From Employees; (d) Select SUM () From Employees;
8. Which clause in SQL is used to apply a condition on a group? (1)
(a) Where (b) Having
(c) As (d) On
Model Test Paper–1 A.1
9. In SQL, which of the following functions is used to display an average of a given number? (1)
(a) Average() (b) Aver()
(c) Avg() (d) Avge()
10. The function to create a Series in Pandas is: (1)
(a) Series[] (b) Series{ }
(c) Series() (d) .Series
11. The library used for data analysis in Python is: (1)
(a) math (b) pandas
(c) Series (d) DataFrame
12. While creating a dataframe from a list of dictionaries, the number of rows in a dataframe is dependent on
the number of ____________ present in the list. (1)
(a) Lists (b) Dictionaries
(c) Keys (d) Values
13. Which network device regenerates and retransmits a weak signal? (1)
(a) Hub (b) Switch
(c) Repeater (d) Gateway
14. In SQL, which function is used to extract a date from a date expression? (1)
(a) Now() (b) Curdate()
(c) Date() (d) Day()
15. What is the name of the IT law in the Indian legislature? (1)
(a) India’s Technology (IT) Act, 2000
(b) India’s Digital Rights
(c) India’s Information Technology (IT) Act, 2000
(d) The India Act, 2000
16. The rights of the owner of the information to decide how much information is to be shared/exchanged/
distributed are collectively known as ___________. (1)
(a) Information Protection Rights (b) Interactive Protection Rights
(c) Intellectual Protection Rights (d) Intellectual Property Rights
Q17 and 18 are Assertion and Reason-based questions. Mark the correct choice:
(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 but R is True
17. Assertion (A): A URL is a complete web address used to find a particular web page. (1)
Reason (R): Every URL contains a domain name.
18. Assertion (A): By default, the index label is defined from 0 to n–1 where n is the total number of rows in a
dataframe. (1)
Reason (R): We cannot change the row label explicitly once a dataframe is created.
SECTION – B
19. Differentiate between a static web page and a dynamic web page. (2)
Or
How is data transferred from one computer to another over a network?
20. Manya is working as a Database administrator in an IT company. She wants to display average salary of
employees whose designation is “Software Engineer” and grade is ‘A’. She is encountering an error while
executing the following SQL query: (2)
A.2 Informatics Practices with Python–XII
Select AVG(Salary) from Employees Group By Designation Where Designation
=”Software Engineer” and Grade=’A’;
Help her in identifying the reason for the error and write the correct query by suggesting the possible
correction(s).
21. What is the purpose of Having clause in SQL? How it is different from Where clause? (2)
22. Write a Python code to create a Series object “Amount” using two lists that store five products along with
their price. The products in a shop are Pens, Pencils, Erasers, Color boxes and Bags and all should be indexes
of Series and their prices are [20, 10, 10, 50, 100] which should be considered as values of Series. (2)
23. List any four health hazards related to the excessive use of technology. (2)
Or
List any four habits that are not considered netiquette.
24. What will be the output of the following code: (2)
>>>import pandas as pd
>>>Ser=pd.Series(data=[10,20,30,40,50])
>>>print(Ser[2]+Ser[3])
25. Consider the following lists and write the Python code: (2)
L1=[“Priya”, “Shalini”, “Dev”, “Kapil”]
L2=[‘XIIA’, ‘XIIA’, ‘XIIB’, ‘XIIA’]
L3=[94,88,99,89]
(a) Create a DataFrame using the given lists. Also assign column names as ‘Name’, ‘Class’ and ‘Marks’.
(b) Assign index label as ‘St1’,‘St2’,‘St3’,‘St4’.
SECTION – C
26. Write outputs for SQL queries (a) to (c) which are based on the given table TEACHER. (3)
Table: TEACHER
ID Name Department Hiredate Category Gender Salary
1. Tanya Nanda SocialStudies 2012-03-17 TGT F 32389.780
2. Saurabh Sharma Art 2014-02-12 PRT M 26895.732
3. Nandita Arora English 2012-05-16 PGT F 30578.876
4. James Jacob English 2022-10-16 TGT M 25647.765
5. Jaspreet Kaur Hindi 2018-08-01 PRT F 21899.856
6. Disha Sehgal Math 2022-03-17 PRT F 29876.890
7. Sonali Mukherjee Math 2022-11-17 TGT F 36987.666
SELECT Right(Department,3) FROM TEACHER WHERE Category=’TGT’;
(a)
SELECT Name FROM TEACHER WHERE Year(Hiredate)=2022;
(b)
SELECT Round (Salary,2) FROM TEACHER WHERE Gender=’F’;
(c)
27. Write a Python code to create a dataframe ‘stock’ with the dictionary given below: (3)
Item={“ItemNo”:[10,11,12,13,14,15],“Price”:[200,500,800,700,500,900]}
Add appropriate row labels.
28. Consider the given dataframe Grade: (3)
Name Grade
0 Rashmi A1
1 Harish A2
2 Jiya B1
3 Neelam A2
4 Surbhi B2
Model Test Paper–1 A.3
Write suitable Python code for the following questions:
(a) Add a column ‘Percentage’ with the following data: [98,89,80,88,78]
(b) Delete the 2nd and 4th rows.
(c) Delete the column Grade.
29. Punit receives a phone call from a company named ABC Ltd. claiming that he has won a 10 lakh lottery.
He is asked some security questions for verification like name, date of birth, account number, IFSC code,
phone number and OTP, etc. In relation to this, answer the following questions: (3)
(a) What is the given case depicting?
(b) Should Punit give the details being asked?
(c) What are the measures to avoid such situations?
Or
What do you understand by digital footprint? What are the different types of digital footprints?
30. Based on table EMP given here, write suitable SQL queries for the following: (3)
Table: EMP
EmpNo EmpName City Designation DOJ Sal Comm
8369 Sunil Mumbai Clerk 1990-12-18 25000.00 NULL
8499 Aakash Varanasi Sales Manager 1991-02-20 30000.00 3000.00
8521 Sarthak Jaipur Sales Manager 1991-02-22 32000.00 5000.00
8566 Mohit Delhi Manager 1991-04-02 50000.00 NULL
(a) Display the designation-wise list of employees with name, salary and date of joining.
(b) Show the minimum and maximum salary of managers.
(c) Count the number of Sales managers in the organization.
Or
What is the difference between Order by clause and Group by clause in SQL? Explain with the help of an
example.
SECTION – D
31. Explain the following SQL functions using suitable examples: (5)
(a) Now() (b) Substr()
(c) Length() (d) Mod()
(e) Ucase()
Or
Write the output of the following queries:
(a) Select Concat(left('Information Technology field', 22)," " , Substr
('Action',1,3),'2000');
(b) Select Instr(‘ Data Science’, ‘Sci’);
(c) Select Year(’23-11-2022’);
(d) Select power(12,2);
(e) Select Round(678.875,-2);
32. Shop Biz Ltd. is an international educational organization. It is planning to set up its India campus in Bengaluru
with its head office in Delhi. The Bengaluru campus has four main buildings—ADMIN, ENGINEERING,
BUSINESS and MEDIA. (5)
D ELHI BENGALURU
Head Office MEDIA ENGINEERING
ADMIN BUSINESS
You, as a network expert, have to suggest the best network-related solutions for the problems raised in
(a) to (e), keeping in mind the distances between the buildings and other given parameters.
A.4 Informatics Practices with Python–XII
Shortest distance between various buildings:
ADMIN to ENGINEERING 60 m
ADMIN to BUSINESS 95 m
ADMIN to MEDIA 70 m
ENGINEERING to BUSINESS 70 m
ENGINEERING to MEDIA 90 m
BUSINESS to MEDIA 50 m
DELHI Head Office to BENGALURU Campus 2155 km
Number of Computers installed at various buildings is as follows:
ADMIN 110
ENGINEERING 75
BUSINESS 40
MEDIA 12
DELHI Head Office 20
(a) Suggest the most appropriate location for the server inside the Bengaluru campus (out of the four
buildings) to get the best connectivity for a maximum number of computers. Justify your answer.
(b) Suggest and draw the cable layout to efficiently connect various buildings within the Bengaluru campus
for connecting the computers.
(c) Which hardware device will you suggest to be procured by the company to protect and control internet
use within the campus?
(d) Which of the following will you suggest to establish online face-to-face communication between the
people in the Admin Office of the Bengaluru campus and Delhi Head Office?
(i) Cable TV (ii) Email (iii) Video conferencing (iv) Text Chat
(e) The company has created its website for better reach to the people but it is not yet published. What
is the name of the procedure that allows them to construct their own websites and make them
accessible to internet users?
33. Write Python code to plot a bar chart to depict the programming language usage as shown below: (5)
Or
Write a program to plot a bar chart to depict the changing weekly onion prices for four weeks. Write
appropriate code to provide axes labels and save the plot.
week=[1,2,3,4]
prices=[40,50,100,97]
Model Test Paper–1 A.5
SECTION – E
34. Komal, a database administrator, has designed a database for S.M. Sports Academy. Help her by writing
answers of the following questions based on the given table: (4)
CoachID CoachName Game FeeCharged No_Of_students Total_Amount
C101 Nupur Yadav Cricket 2000 50 100000
C102 Vipin Kumar Skates 2500 30 75000
C103 Sooraj Kapoor Taekwondo 3000 35 105000
C104 Naresh Bhatia Cricket 2500 70 175000
C105 Pooja Garg Badminton 3000 65 195000
(a) Write a query to display Coach names in upper case.
(b) Write a query to display the name of the coach who charged highest fees.
(c) Write a query to count a query to count the number of cricket coaches.
OR (Option for part (c) only)
Write a query to calculate total fees charged by cricket students and badminton.
35. Pratigya, a data analyst, has designed the dataframe df that contains data about Employees with ‘EO1’,
‘EO2’, ‘EO3’, ‘EO4’, ‘EO5’ as indexes shown below. Answer the following questions: (4)
Name Gender Designation City Salary
E01 Ritika F Manager Delhi 90000
E02 Geet M Programmer Mumbai 80000
E03 Rahul M IT Officer Ahmedabad 86000
E04 Rijul M Analyst Lucknow 55000
E05 Anita F Programmer Bengaluru 89000
(a) Predict the output of the following python statement:
(i) df.columns
(ii) df.loc[‘E02’: ‘E04’]
(b) Write Python statement to display the data of Designation column of indexes E01 to E03.
OR
Write Python statement to display Salary of Programmers from the above dataframe.
A.6 Informatics Practices with Python–XII
