माध्यमिक शिक्षा बोर्ड, राजस्थान, अजमेर
पाठ्यक्रम सत्र 2025–2026 | Model Question Paper
Informatics Practices
Class — 11
विषय कोड — 04
| Unit | Topic | Marks |
|---|---|---|
| Unit 1 | Introduction to Computer System | 5 |
| Unit 2 | Introduction to Python | 25 |
| Unit 3 | Data Handling using NumPy | 15 |
| Unit 4 | Database Concepts and SQL | 20 |
| Unit 5 | Introduction to Emerging Trends | 5 |
| Theory Total | 70 | |
| Practical (Separate) | 30 | |
General Instructions / सामान्य निर्देश :
- सभी प्रश्न अनिवार्य हैं। / All questions are compulsory.
- प्रत्येक प्रश्न के अंक उसके सामने अंकित हैं।
- जहाँ विकल्प (OR) दिया गया हो, केवल एक प्रश्न हल करें।
- Python / NumPy programs में indentation अनिवार्य है — प्रत्येक level पर 4 spaces।
- SQL queries में keywords CAPITAL LETTERS में लिखें। Table name case-sensitive नहीं है।
SECTION — A : Objective Type Questions 20 Marks
Q.1–6 : MCQ | Fill in the Blanks | True/False | Match — (Unit 1 to 5)
Q. 1.4 × 1 = 4 Marks
Choose the most appropriate option : (Unit 1 & 5)
- Which of the following correctly lists primary memory types ?
- Which type of software is designed for a specific purpose, like Tally for accounting ?
- Immersive experience using headsets that simulates a realistic 3D environment is called —
- Which cloud service model provides software applications over the internet on a subscription basis ?
Q. 2.6 × 1 = 6 Marks
Choose the most appropriate option : (Unit 2 — Python)
- What is the output of the following ?
print(type("3.14"))
- Which of the following is a mutable data type in Python ?
- What will be the output of
"JODHPUR"[2:5]? - What will
len({'a':1, 'b':2, 'c':3})return ? - What is the output of the following ?
L = [10, 20, 30, 40] print(L[-1], L[-2])
- Which Python statement is used to exit a loop immediately ?
Q. 3.3 × 1 = 3 Marks
Choose the most appropriate option : (Unit 3 — NumPy)
- Which NumPy function creates an array of all zeros ?
- What is the output of
np.arange(2, 10, 3)? - Which attribute of a NumPy array gives the number of elements ?
Q. 4.3 × 1 = 3 Marks
Choose the most appropriate option : (Unit 4 — SQL)
- Which SQL command is used to remove a column from an existing table ?
- Which SQL clause is used to filter records based on a condition ?
- Which key uniquely identifies each record in a table ?
Q. 5. Fill in the Blanks :4 × 1 = 4 Marks
(i) In Python, a dictionary stores data in pairs.
(ii) The NumPy function used to calculate the mean of an array is .
(iii) The SQL command used to add a new row in a table is .
(iv) is the field in a child table that references the primary key of the parent table.
(ii) The NumPy function used to calculate the mean of an array is .
(iii) The SQL command used to add a new row in a table is .
(iv) is the field in a child table that references the primary key of the parent table.
Q. 6. Match Column A with Column B :4 × ½ = 2 Marks
| Column A | Column B |
|---|---|
| (i) np.concatenate() | (a) Structured Query Language for data retrieval |
| (ii) SELECT … FROM … WHERE | (b) Joins two or more NumPy arrays |
| (iii) IoT | (c) Network of physical devices exchanging data |
| (iv) Blockchain | (d) Decentralised, immutable digital ledger technology |
SECTION — B : Short Answer Type Questions 25 Marks
Each question carries 2 or 3 marks as indicated | Attempt all questions
Q. 7.2 Marks
Answer the following questions : (Unit 1)
- Differentiate between primary memory and secondary memory with two points. (1 Mark)
- What is the difference between generic software and specific purpose software ? Give one example of each. (1 Mark)
Q. 8.3 Marks
Answer the following Python questions : (Unit 2)
- What will be the output of the following code ? Explain each line. (2 Marks)
x = 15 y = 4 print(x // y) print(x % y) print(x ** 2)
- What is the difference between
append()andextend()in Python lists ? Give one example of each. (1 Mark)
Q. 9.3 Marks
Write a Python program using for loop to print the multiplication table of a number entered by the user (1 to 10). (2 Marks)
What will be the output of the following ? (1 Mark)
i = 1
while i <= 5:
if i % 2 == 0:
print(i, end=" ")
i += 1
Q. 10.3 Marks
Consider the following dictionary :
student = {'name': 'Ananya', 'age': 16, 'city': 'Jaipur', 'score': 92}
- Write Python statements to : (i) update score to 95, (ii) add a new key
'grade': 'A', (iii) delete the key'age', (iv) print all key-value pairs using a loop. (2 Marks) - What is the difference between
keys(),values(), anditems()in a dictionary ? (1 Mark)
Q. 11.3 Marks
Answer the following NumPy questions : (Unit 3)
- Write the output of the following NumPy code : (2 Marks)
import numpy as np a = np.array([10, 20, 30, 40, 50]) print(a[1:4]) print(a * 2) print(np.mean(a)) print(np.std(a))
- What is the difference between a Python list and a NumPy array ? Give two points. (1 Mark)
Q. 12.3 Marks
Answer the following questions on NumPy : (Unit 3)
- Write NumPy statements to create a 2D array of shape (3×3) containing values 1 to 9, then print its shape, size, and the element at row 2, column 3. (2 Marks)
- What do
np.zeros(),np.ones(), andnp.arange()do ? Give one example of each. (1 Mark)
Q. 13.3 Marks
Consider the following table STUDENTS : (Unit 4)
| SID | SNAME | CLASS | CITY | MARKS |
|---|---|---|---|---|
| 101 | Ravi | 11 | Jodhpur | 78 |
| 102 | Priya | 11 | Jaipur | 91 |
| 103 | Mohit | 12 | Jodhpur | 65 |
| 104 | Sunita | 11 | Bikaner | 88 |
| 105 | Rahul | 12 | Jaipur | 72 |
Write SQL queries for the following :
- Display the names and marks of all students from Class 11 who scored more than 80 marks. (1 Mark)
- Display all records in descending order of MARKS. (1 Mark)
- Display SNAME and CITY of students whose city is either 'Jodhpur' or 'Jaipur'. (1 Mark)
Q. 14.3 Marks
Write SQL statements for the following : (Unit 4)
- Create a table EMPLOYEE with columns : EID (int, primary key), ENAME (varchar 30), DEPT (varchar 20), SALARY (float), DOJ (date). (1½ Marks)
- Write SQL statements to : (i) Insert one record of your choice, (ii) Update salary to 55000 for EID = 101, (iii) Delete the record where DEPT = 'HR'. (1½ Marks)
Q. 15.2 Marks
Answer any TWO of the following in about 30–40 words each : (Unit 5)
- What is Artificial Intelligence ? Name any two real-life applications of AI.
- Differentiate between Big Data and traditional data. State any two characteristics of Big Data (3 Vs).
- What is Blockchain technology ? Give one real-life example of its use.
Q. 16.3 Marks
Write a complete Python program that : (Unit 2)
- Accepts a list of n integers from the user. (1 Mark)
- Counts and prints the number of even and odd numbers separately. (1 Mark)
- Prints the list in reverse order without using the
reverse()function. (1 Mark)
SECTION — C : Long Answer Type Questions 25 Marks
Each question carries 5 marks | Internal choice in Q.17, Q.19, Q.21
Q. 17.5 Marks
(a) Explain the following Python data types with syntax and one example each : (3 Marks)
- List — creation, indexing, and two built-in functions
- Tuple — creation, why it is preferred over list, and two built-in functions
- Dictionary — creation, accessing values, and two built-in functions
(b) Write a Python program that accepts a string from the user and prints : (i) total number of vowels, (ii) whether the string is a palindrome or not. (2 Marks)
OR
(a) Explain the following Python concepts with programs : (3 Marks)
- Mutable vs Immutable data types — with one example each
- Type conversion — explicit and implicit, with one example each
- Identity operators (
is,is not) vs Equality operator (==)
(b) Write a Python program to find the second largest number in a list of n numbers accepted from the user, without using built-in
max() or sort(). (2 Marks)
Q. 18.5 Marks
(a) Write a complete NumPy program for the following : (3 Marks)
- Create a 1D NumPy array of integers from 1 to 20 using
np.arange(). Print its shape, size, and dtype. - Reshape it into a 4×5 2D array and print the reshaped array.
- From the 2D array, print: (i) the second row, (ii) the last column, (iii) the element at position [2][3].
(b) Given two NumPy arrays
A = [5, 10, 15, 20] and B = [2, 4, 6, 8], write NumPy statements to find : (i) element-wise sum, (ii) element-wise product, (iii) concatenation of A and B, (iv) mean of the concatenated array, (v) standard deviation of array A. (2 Marks)
Q. 19.5 Marks
Consider the following table PRODUCTS :
| PID | PNAME | CATEGORY | PRICE | STOCK |
|---|---|---|---|---|
| P01 | Laptop | Electronics | 45000 | 15 |
| P02 | Chair | Furniture | 3500 | 50 |
| P03 | Mobile | Electronics | 18000 | 30 |
| P04 | Table | Furniture | 7500 | 20 |
| P05 | Headphones | Electronics | 2500 | 100 |
| P06 | Keyboard | Electronics | 1200 | 60 |
Write SQL queries for the following :
- Display all products from the 'Electronics' category with price between 1000 and 20000. (1 Mark)
- Display PNAME and PRICE of the most expensive product in each CATEGORY. (1 Mark)
- Display all product names that contain the letter 'a' anywhere in the name. (1 Mark)
- Update the price of 'Mobile' to 20000 and increase stock of all 'Furniture' items by 10. (1 Mark)
- Display the total stock and average price for each category separately. (1 Mark)
OR
(a) Write complete SQL statements to : (3 Marks)
- Create a database named
SCHOOLand select it for use. - Create table TEACHER : TID (int primary key), TNAME (varchar 40 not null), SUBJECT (varchar 30), SALARY (float), EXPERIENCE (int).
- Add a new column PHONE (varchar 15) to the TEACHER table using ALTER.
- Drop the column PHONE from the TEACHER table.
- Display teacher names and salary where EXPERIENCE is more than 5 years, ordered by salary descending.
(b) Explain the difference between DDL and DML commands with two examples each. (2 Marks)
Q. 20.5 Marks
(a) Write a Python function
statistics_summary(data) that takes a list of numbers and returns (does not print) the mean, median, and mode. Display the results by calling the function with the list [4, 8, 6, 5, 3, 8, 2, 8, 6, 4]. Do not use any statistics module. (3 Marks)(b) Write a Python program using while loop and a dictionary to count the frequency of each character in the string
"RAJASTHAN" and display the result. (2 Marks)
Q. 21.5 Marks
(a) Write a complete NumPy program to : (3 Marks)
- Create two 2D arrays X and Y of shape (3×3) with values of your choice.
- Perform matrix addition and matrix multiplication (element-wise) and print results.
- From array X, print all elements greater than 5 using boolean indexing.
- Compute max, min, sum, mean, and variance of array X.
(b) Explain the concept of Relational Data Model in DBMS. Define the following terms with one example each : (i) Tuple, (ii) Attribute, (iii) Domain, (iv) Primary Key, (v) Foreign Key. (2 Marks)
OR
(a) Write complete answers : (3 Marks)
- What is Natural Language Processing ? Give two real-life examples.
- Explain Grid Computing and how it differs from Cloud Computing.
- What are Smart Cities ? List three technologies that make a city "smart."
(b) Write a Python program to create a NumPy array of 10 random integers between 1 and 50 using
np.random.randint(). Then: (i) print the array, (ii) find and print all elements divisible by 5, (iii) replace all elements less than 20 with 0. Print the final array. (2 Marks)
🔗 संबंधित लिंक – RBSE Class 11 Informatics Practices (IP) 2026
No comments:
Post a Comment