Sample paper[IP] 2025-26, Study notes of Computer science

Study material for exams[IP] paper

Typology: Study notes

2025/2026

Available from 03/30/2026

dilpreet-singh-23
dilpreet-singh-23 🇮🇳

2 documents

1 / 9

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
SAMPLE QUESTION PAPER
CLASS XII
INFORMATICS PRACTICES (065)
TIME: 03 HOURS M.M.: 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. A ____________is a device that connects the organisations network with the
outside world of the Internet.
i.
1
2. When e-waste such as electronic circuit boards are burnt for disposal, the
elements contained in them create a harmful chemical called ________which causes skin diseases,
allergies and an increased risk of lung cancer.
i.
1
3. Copyright, Patent and Trademark comes under:
i.
1
4. Predict the output of the following query:
SELECT MOD (9,0);
i.
1
Hub
ii. Modem
iii. Gateway
iv. Repeater
Hydrogen
ii. Beryllium
iii. Chlorine
iv. Oxygen
Intellectual Property Right
ii. Individual Property Right
iii. Industrial Property Right
iv. International Property Right
0
ii. NULL
iii. NaN
iv. 9
pf3
pf4
pf5
pf8
pf9

Partial preview of the text

Download Sample paper[IP] 2025-26 and more Study notes Computer science in PDF only on Docsity!

SAMPLE QUESTION PAPER

CLASS XII

INFORMATICS PRACTICES (065)

TIME: 03 HOURS M.M.: 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
  9. (^) A ____________is a device that connects the organisation’s network with the outside world of the Internet. i.
  1. (^) When e-waste such as electronic circuit boards are burnt for disposal, the elements contained in them create a harmful chemical called ________which causes skin diseases, allergies and an increased risk of lung cancer. i.
  1. (^) Copyright, Patent and Trademark comes under: i.
  1. (^) Predict the output of the following query: SELECT MOD (9,0); i.

Hub ii. Modem iii. Gateway iv. Repeater Hydrogen ii. (^) Beryllium iii. Chlorine iv. Oxygen Intellectual Property Right ii. (^) Individual Property Right iii. Industrial Property Right iv. International Property Right 0 ii. NULL iii. NaN iv. 9

  1. (^) Which of the following SQL functions does not belong to the Math functions category? i.
  1. (^) ________ is not a FOSS tool. i.
  1. CSV stands for: i.
  1. (^) Raj, a Database Administrator, needs to display the average pay of workers from those departments which have more than five employees. He is experiencing a problem while running the following query: SELECT
  1. (^) Predict the output of the following query: SELECT LCASE (MONTHNAME ('2023-03-05')); i.

POWER()

ii. (^) ROUND() iii. LENGTH() iv. MOD() Libre Office ii. Mozilla Firefox iii. Google Chrome iv. Python Column Separated Value ii. (^) Class Separated Value iii. Comma Separated Value iv. Comma Segregated Value DEPT, AVG(SAL)^ FROM^ EMP^ WHERE^ COUNT()^ >^5 GROUP BY DEPT; Which of the following is a correct query to perform the given task? i. SELECT DEPT, AVG(SAL) FROM EMP WHERE COUNT() > 5 GROUP BY DEPT; ii. SELECT DEPT, AVG(SAL) FROM EMP HAVING COUNT() > 5 GROUP BY DEPT; iii. (^) SELECT (^) DEPT, AVG(SAL) FROM EMP GROUP BY DEPT WHERE COUNT() > 5; iv. SELECT (^) DEPT, AVG(SAL) FROM EMP GROUP BY DEPT HAVING COUNT(*) > 5; May ii. March iii. may iv. march

  1. (^) _______________is a non-profit organization that aims to build a publicly accessible global platform where a range of creative and academic work is shared freely. i.
  1. (^) Assertion (A):- MODEM stands for modulator-demodulator. Reasoning (R): - It is a computer hardware device that converts data from a digital format to analog and vice versa. i.
  1. (^) Assertion (A):- To use the Pandas library in a Python program, one must import it. Reasoning (R): - The only alias name that can be used with the Pandas library is pd. i.

SECTION B

  1. (^) Briefly explain the basic concepts of a web server and web hosting. OR Rati is doing a course in networking. She is unable to understand the concept of URL. Help her by explaining it with the help of suitable example.
  1. (^) The python code written below has syntactical errors. Rewrite the correct code and underline the corrections made. Import pandas as pd df ={"Technology":["Programming","Robotics","3D Printing"],"Time(in months)":[4,4,3]} df= Pd.dataframe(df) Print(df)
  1. (^) Consider the given SQL string: “12#All the Best!” Write suitable SQL queries for the following: i.

Creative Cost ii. Critical Commons iii. Creative Commons iv. Creative Common Both A and R are true and R is the correct explanation for A ii. (^) Both A and R are true and R is not the correct explanation for A iii. A is True but R is False iv. A is false but R is True Both A and R are true and R is the correct explanation for A ii. (^) Both A and R are true and R is not the correct explanation for A iii. A is True but R is False iv. A is false but R is True Returns the position of the first occurrence of the substring “the” in the given string. ii. (^) To extract last five characters from the string.

  1. (^) Predict the output of the given Python code: import pandas as pd list1=[-10,-20,-30] ser = pd.Series(list1*2) print(ser)
  1. (^) Differentiate between the active digital footprint and passive digital footprints. 2
  2. (^) Complete the given Python code to get the required output as: Rajasthan import _________ as pd di = {'Corbett': 'Uttarakhand', 'Sariska': 'Rajasthan', 'Kanha': 'Madhya Pradesh’, 'Gir':'Gujarat'} NP = ___________. Series( _____ ) print(NP[ ___________ ])
  1. (^) What are aggregate functions in SQL? Name any two. 2 SECTION C
  2. (^) Based on the SQL table CAR_SALES, write suitable queries for the following: +--------+-------------------+--------+-------+-------+ | NUMBER | SEGMENT

| FUEL | QT1 | QT2 | +--------+-------------------+--------+-------+-------+ | 1 | Compact HatchBack | Petrol | 56000 | 70000 | | 2 | Compact HatchBack | Diesel | 34000 | 40000 | | 3 | MUV | Petrol | 33000 | 35000 | | 4 | MUV | Diesel | 14000 | 15000 | | 5 | SUV | Petrol | 27000 | 54000 | | 6 | SUV | Diesel | 18000 | 30000 | | 7 | Sedan | Petrol | 8000 | 10000 | | 8 | Sedan | Diesel | 1000 | 5000 | +--------+-------------------+--------+-------+-------+ i. (^) Display fuel wise average sales in the first quarter. ii. (^) Display segment wise highest sales in the second quarter. iii. Display the records in the descending order of sales in the second quarter. OR Predict the output of the following queries based on the table CAR_SALES given above: i. SELECT LEFT(SEGMENT,2) FROM CAR_SALES WHERE FUEL= "PETROL"; ii.SELECT (QT2-QT1)/2 "AVG SALE" FROM CAR_SALES WHERE SEGMENT= "SUV"; iii. SELECT SUM(QT1) "TOT SALE" FROM CAR_SALES WHERE FUEL= "DIESEL";

SECTION D

  1. (^) Preeti manages database in a blockchain start-up. For business purposes, she created a table named BLOCKCHAIN. Assist her by writing the following queries: TABLE: BLOCKCHAIN i.
  1. (^) Ekam, a Data Analyst with a multinational brand has designed the DataFrame df that contains the four quarter’s sales data of different stores as shown below:

SECTION E

  1. (^) Write suitable SQL queries for the following: i.

Write a query to display the year of oldest transaction. ii. (^) Write a query to display the month of most recent transaction. iii. Write a query to display all the transactions done in the month of May. iv. Write a query to count total number of transactions in the year 2022. Store Qtr1 Qtr2 Qtr3 Qtr 0 Store1 300 240 450 230 1 Store2 350 340 403 210 2 Store3 250 180 145 160 Answer the following questions: i. (^) Predict the output of the following python statement: a. print(df.size) b. (^) print(df[1:3]) ii. Delete the last row from the DataFrame. iii. Write Python statement to add a new column Total_Sales which is the addition of all the 4 quarter sales. OR (Option for part iii only) Write Python statement to export the DataFrame to a CSV file named data.csv stored at D: drive. To calculate the exponent for 3 raised to the power of 4. ii. (^) To display current date and time. iii. To round off the value -34.4567 to 2 decimal place. iv. To remove all the probable leading and trailing spaces from the column userid of the table named user. v. To display the length of the string ‘FIFA World Cup’.

OR

Kabir has created following table named exam: +-------+--------- +------------------+-------+ | RegNo | Name

  1. (^) XYZ Media house campus is in Delhi and has 4 blocks named Z1, Z2, Z3 and Z4. The tables given below show the distance between different blocks and the number of computers in each block.

| Subject | Marks | +-------+---------+------------------+-------+ | 1 | Sanya | Computer Science | 98 | | (^) 2 | Sanchay | IP | 100 | | 3 | Vinesh^ | CS | 90 | | 4 | Sneha | IP | 99 | | 5 | Akshita | IP | 100 | +-------+---------+------------------+-------+ Help him in writing SQL queries to the perform the following task: i. (^) Insert a new record in the table having following values: [6,'Khushi','CS',85] ii. (^) To change the value “IP” to “Informatics Practices” in subject column. iii. To remove the records of those students whose marks are less than

iv. (^) To add a new column Grade of suitable datatype. v. To display records of “Informatics Practices” subject.