The Informatics Practices (065) subject is an important part of the Class 12 curriculum under the Central Board of Secondary Education (CBSE). Every year many students look for important questions that can help them score good marks in the board examination.
To help students prepare effectively for the CBSE Board Exam 2026, we have compiled 100 most important questions with answers based on the latest CBSE syllabus, previous year questions and sample paper trends.
These questions cover all the major topics of Informatics Practices such as:
-
Python Pandas and DataFrame operations
-
SQL queries and database concepts
-
Internet, digital society and data privacy
Students can use these questions for revision, practice and last-minute preparation before the board examination.
📘 Informatics Practices 2026
60 Most Important Questions with Answers
PART 1 – MCQ (1–25)
-
Which library is used in Python for data analysis?
Answer: Pandas -
What is a DataFrame in Pandas?
Answer: A two-dimensional tabular data structure consisting of rows and columns. -
Which function displays the first five rows of a DataFrame?
Answer: head() -
Which function displays the last rows of a DataFrame?
Answer: tail() -
Which function gives a statistical summary of the data?
Answer: describe() -
What is the full form of CSV?
Answer: Comma Separated Values -
Which command is used to import Pandas?
Answer:import pandas as pd -
What is the full form of SQL?
Answer: Structured Query Language -
Which SQL command is used to retrieve data from a table?
Answer: SELECT -
Which clause is used to filter records in SQL?
Answer: WHERE -
Which clause is used to sort records in SQL?
Answer: ORDER BY -
Which clause is used to group records in SQL?
Answer: GROUP BY -
Which function counts the number of records in SQL?
Answer: COUNT() -
Which function calculates the average value in SQL?
Answer: AVG() -
Which function finds the maximum value in SQL?
Answer: MAX() -
Which function finds the minimum value in SQL?
Answer: MIN() -
Which symbol is used for lists in Python?
Answer: [ ] -
Which symbol is used for dictionaries in Python?
Answer: { } -
Which key uniquely identifies a record in a table?
Answer: Primary Key -
Which key creates a relationship between two tables?
Answer: Foreign Key -
What is the trace of personal data left on the internet called?
Answer: Digital Footprint -
Give one example of data security.
Answer: Password protection -
What is illegal copying of digital content called?
Answer: Piracy -
What is identity theft?
Answer: Using someone else's personal information without permission. -
Give one example of cybercrime.
Answer: Hacking
PART 2 – Very Short Answer Questions (26–50)
-
What is Pandas?
Answer: Pandas is a Python library used for data analysis and data manipulation. -
What is a Series in Pandas?
Answer: A one-dimensional labeled array. -
What is a DataFrame?
Answer: A two-dimensional data structure with rows and columns. -
What is a CSV file?
Answer: A text file in which values are separated by commas. -
What is SQL?
Answer: A language used to manage and manipulate data in a database. -
What is a Primary Key?
Answer: A field that uniquely identifies each record in a table. -
What is a Foreign Key?
Answer: A field used to link two tables. -
What is a database?
Answer: An organized collection of data. -
What is the Internet?
Answer: A global network connecting millions of computers. -
What is the World Wide Web?
Answer: A collection of websites accessed through the Internet. -
What is a digital footprint?
Answer: The record of a user's online activities. -
What is data privacy?
Answer: Protection of personal data from unauthorized access. -
What is cybercrime?
Answer: Crime committed using computers or the internet. -
What is hacking?
Answer: Unauthorized access to a computer system. -
What is phishing?
Answer: A method of stealing personal information using fake emails or websites. -
What is malware?
Answer: Malicious software designed to damage systems. -
What is a firewall?
Answer: A security system that monitors and controls network traffic. -
What is cloud computing?
Answer: Storing and accessing data over the internet instead of a local computer. -
What is e-commerce?
Answer: Buying and selling goods online. -
What is e-governance?
Answer: Government services delivered through the internet. -
What are Intellectual Property Rights (IPR)?
Answer: Legal rights that protect creations of the mind. -
What is plagiarism?
Answer: Copying someone else's work without giving credit. -
What is the digital divide?
Answer: The gap between people who have access to technology and those who do not. -
What is data ethics?
Answer: Ethical guidelines for using data responsibly. -
What is social media?
Answer: Online platforms used for communication and sharing information.
PART 3 – Short Answer Questions (51–60)
-
Write a Python code to create a DataFrame.
import pandas as pd
data = {"Name": ["Aman", "Riya"], "Marks": [85, 90]}
df = pd.DataFrame(data)
print(df)
-
Write a Pandas code to read a CSV file.
import pandas as pd
df = pd.read_csv("data.csv")
print(df)
-
Write a Pandas code to save data to a CSV file.
df.to_csv("data.csv")
-
Write an SQL query to display all records from a Student table.
SELECT * FROM Student;
-
Write an SQL query to display students with marks greater than 80.
SELECT * FROM Student
WHERE Marks > 80;
-
Write an SQL query to sort students by marks in ascending order.
SELECT * FROM Student
ORDER BY Marks;
-
Write an SQL query to sort students by marks in descending order.
SELECT * FROM Student
ORDER BY Marks DESC;
-
Write an SQL query to calculate the average marks.
SELECT AVG(Marks)
FROM Student;
-
Write an SQL query to count the total number of students.
SELECT COUNT(*)
FROM Student;
-
Write an SQL query to find the highest marks.
SELECT MAX(Marks)
FROM Student;Thank You!!!===============================
No comments:
Post a Comment
Please do not any spam in the comment box.