Skip to main content
·7 chapters

CBSE Class 12 Informatics Practices — NCERT Solutions

CBSE Class 12 Informatics Practices NCERT solutions, chapter by chapter — 166 textbook questions solved across 7 chapters. Follows the CBSE syllabus.

About these solutions

166 NCERT textbook questions for CBSE Class 12 Informatics Practices, solved step by step across 7 chapters. Each chapter page has every exercise: half the solutions are open to read and the rest are free with a Super Tutor account.

1

Querying and SQL Functions

42 questions solved

  • Exercise · 42 questions
Q1a.Define RDBMS. Name any two RDBMS software.

An RDBMS is a Relational Database Management System. It stores data in the form of related tables (relations) and manages relationships among them.

Two examples are MySQL and Oracle.

Q1b(i).What is the purpose of the following clauses in a select statement?

ORDER BY clause का उपयोग परिणामों को क्रमबद्ध करने के लिए किया जाता है। इसके द्वारा रिकॉर्ड्स को ascending या descending क्रम में दिखाया जा सकता है।

2
  • Exercise · 44 questions
Q1.What is a Series and how is it different from a 1-D array, a list and a dictionary?

A Series is a one-dimensional array in Pandas that stores a sequence of values of any data type and has index labels for each value.

Differences:

  • 1-D array (NumPy ndarray): stores elements in a one-dimensional form, but uses only integer positions for indexing.
  • List: a general Python collection; it does not provide Pandas-style labeled indexing and built-in data analysis methods.
  • Dictionary: stores key:value pairs, while a Series stores values with an index. A Series can be created from a dictionary, but it is not the same thing.
Q2.What is a DataFrame and how is it different from a 2-D array?

A DataFrame is a two-dimensional labelled data structure like a table. It contains rows and columns, and each column may have a different data type.

Difference from a 2-D array:

  • A 2-D array usually stores homogeneous data and is accessed mainly by numeric positions.
  • A DataFrame can store different data types in different columns and uses row and column labels for easier access and analysis.
  • Exercise · 28 questions
Q1.Write the statement to install the python connector to connect MySQL i.e. pymysql.

The statement to install the MySQL connector pymysql is:

pip install pymysql
Q2.Explain the difference between pivot() and pivot_table() function?

pivot() is used to reshape a DataFrame when the entries for the specified index and columns are unique. It rearranges data from rows into a new table.

pivot_table() works like pivot(), but it can handle duplicate entries by applying an aggregate function such as mean, sum, max, or min. The default aggregate function is mean.

So, the main difference is:

  • pivot() does not work with duplicate values for the chosen index/columns.
  • pivot_table() can reshape data even when duplicates are present, by aggregating them.
4
  • Exercise · 11 questions
Q1.What is the purpose of the Matplotlib library?

The Matplotlib library is used for creating static, animated, and interactive 2D plots or figures in Python.

5

Internet and Web

17 questions solved

  • Exercise · 17 questions
Q1.Fill in the blanks:

a) To transmit data for sharing on a network, it has to be divided into smaller chunks called packets.

b) The set of rules that decide the functioning of a network is called Ethernet.

c) A LAN can be extended up to a distance of 1 km.

d) The router connects a local area network to the internet.

e) The tree topology is of hierarchical nature.

f) URL is a standard naming convention used for accessing resources over the Internet.

g) Website is a collection of related web pages.

h) A server is a computer that provides services to other programs or computers.

6

Societal Impacts

20 questions solved

  • Exercise · 20 questions
Q1.After practicals, Atharv left the computer laboratory but forgot to sign off from his email account. Later, his classmate Revaan started using the same computer. He is now logged in as Atharv. He sends inflammatory email messages to few of his classmates using Atharv's email account. Revaan's activity is an example of which of the following cyber crime? Justify your answer.

Revaan is using Atharv’s logged-in email account as if he were Atharv and sending messages in Atharv’s name. This means he is misusing another person’s identity to act online, which is identity theft. It is not just hacking because he did not break into the system; he used the already open account.

7

Project Based Learning

4 questions solved

  • 7.4 Project Descriptions · 4 questions
Q7.4.1.Project I : Online Shopping Platform

डेटा संरचना और कार्य-योजना

Murugan की APPAREL EASY परियोजना के लिए डेटा को इस तरह व्यवस्थित किया जा सकता है कि हर रिकॉर्ड में आवश्यक जानकारी रहे और Pandas की मदद से उसे आसानी से संसाधित किया जा सके।

1) मुख्य डेटा फ़ाइल की संरचना

एक CSV/डेटा फ़ाइल में ये फ़ील्ड रखे जा सकते हैं:

  • Apparel Code
  • Name
  • Category
  • Size
  • Price
  • Customer Name
  • Payment Mode
  • Discount Code

यदि आवश्यक हो तो और फ़ील्ड भी जोड़े जा सकते हैं, जैसे:

  • Credit Card No.
  • Card Holder Name
  • CVV
  • Validity
  • Sale Type
  • Quantity
  • Revenue

2) श्रेणियाँ और उप-श्रेणियाँ

  • Broad Categories: Men, Women
  • Sub-categories: Clothing, Footwear, Accessories

उदाहरण के लिए:

  • Men: Men’s Trousers, Men’s Shirt, Men’s Jeans, Men’s T-shirt
  • Women: Skirts, Top, Pants, Jeans, Kurta, etc.

3) भुगतान के नियम

  • यदि Payment Mode = Credit/Debit Card है, तो:
  • Credit card number
  • Card holder name
  • CVV
  • Validity

दर्ज करनी होगी।

  • यदि Payment Mode = COD है, तो कोई card details नहीं पूछी जाएँगी।

4) छूट (Discount) का नियम

  • FEST = 10% discount
  • EOS = 15% discount

5) Sale के लिए merchandise चयन

प्रश्न के अनुसार sale के लिए merchandise को randomly चुनना है, लेकिन चुना गया merchandise कुल merchandise का 70% से अधिक नहीं होना चाहिए।

6) Pandas से कार्यान्वयन का तरीका

Pandas में एक DataFrame बनाकर:

  • data को store किया जा सकता है,
  • filter किया जा सकता है,
  • discount लागू किया जा सकता है,
  • monthly revenue निकाला जा सकता है,
  • category-wise sales की गणना की जा सकती है,
  • visitors और orders का record रखा जा सकता है।

7) विश्लेषण और plotting

Murugan के निर्णय लेने के लिए उपयुक्त charts बनाए जा सकते हैं, जैसे:

  • bar chart — category-wise sales के लिए
  • line chart — monthly revenue trends के लिए
  • pie chart — sale items या discount distribution के लिए

निष्कर्ष

इस परियोजना में एक ऐसा software बनाया जाएगा जो apparel data को संग्रहित करे, payment और discount rules लागू करे, 70% तक merchandise को sale के लिए चुन सके, और Pandas तथा charts की मदद से बिक्री व ग्राहकों से जुड़ी जानकारी का विश्लेषण कर सके।

Get chapter-wise help for CBSE Class 12 Informatics Practices

Super Tutor gives you chapter summaries, revision notes, practice quizzes and flashcards, organised around the CBSE syllabus. Free to start.

Try Super Tutor free

Frequently Asked Questions

Where can I find CBSE Class 12 Informatics Practices NCERT Solutions?

This page has NCERT solutions for 7 chapters of CBSE Class 12 Informatics Practices for the board exams 2027. Each chapter links to its own page with the full set.

Go through the syllabus first, then work chapter by chapter: learn the ideas, practise questions, and revise with notes and flashcards. Leave time at the end to revise every chapter once more under timed conditions.

Half of the solutions on each chapter page are open to read. The rest are free with a Super Tutor account — signing up is free and needs no card.

Browse NCERT Solutions by Chapter

7 chapters

More Informatics Practices Resources

CBSE Class 12

Other CBSE Class 12 Subjects