CBSE Class 12 Informatics Practices Sample Paper 2021 Set B

Read and download the CBSE Class 12 Informatics Practices Sample Paper 2021 Set B, designed by expert teachers according to the latest 2025-26 curriculum and examination pattern issued by CBSE, NCERT, and KVS. These Class 12 Informatics Practices sample papers include detailed step-by-step solutions, helping students to practice and evaluate their performance against the most recent marking schemes.

Solved Sample Paper for Class 12 Informatics Practices PDF

Our Class 12 Informatics Practices model papers are important for understanding the weightage of different chapters and the difficulty level of expected questions. By solving these guess papers Class 12 students can identify weak areas and improve time management. We also suggest referring to our Class 12 Informatics Practices Question Papers of previous years to further strengthen your exam preparation.

Class 12 Informatics Practices Sample Paper with Solutions

CBSE Class 12 Informatics Practices Sample Paper 2021 Set B. CBSE issues sample papers every year for students for Class 12 board exams. Students should solve the CBSE issued sample papers to understand the pattern of the question paper which will come in class 12 board exams this year. The sample papers have been provided with marking scheme. It’s always recommended to practice as many CBSE sample papers as possible before the board examinations. Sample papers should be always practiced in examination condition at home or school and the student should show the answers to teachers for checking or compare with the answers provided. Students can download the sample papers in pdf format free and score better marks in examinations. Refer to other links too for latest sample papers. 

1. a) Consider the following table name "GARMENT". Write command of SQL from (i) to (iv) and output for (v) to (vii).

Class 12 Informatics Practice SamplePaper 2021 Set B

 

I. To display name of those garments that are available in 'XL' size

II. To display codes and names of those garments that have their names starting with 'Ladies'.

III. To display garment names, codes and prices of those garments that have price in the range 1000.00 to 1500.00 (both 1000.00 and 1500.00 included).

IV. To change the colour of the garment with code as 116 to "Orange".

V. SELECT COUNT(DISTINCT SIZE) FROM GARMENT

VI. SELECT AVG (PRICE) FROM GARMENT;

VII. SELECT GNAME FROM GARMENT WHERE SIZE IN ('M', 'L') AND PRICE>1500;

b) What is the degree and cardinality of 'Garment table'.

c) What is the transaction? Which command is used to make changes done by a transaction permanent]on a database?

2. a) Write MySQL command to create the Table 'LIBRARY' with given constraints.

 Class 12 Informatics Practice SamplePaper 2021 Set B1

 

b) In a Database Company, there are two tables given below:
CBSE-Class-12-Informatics-Practices-Sample-Paper-2021-Set-B 1
 

CBSE-Class-12-Informatics-Practices-Sample-Paper-2021-Set-B 2

 

 

 

Write SQL queries for the following:

 

I. To display SalesmanID, names of salesman, LoactionID with corresponding location names. 

 

II. To display names of salesman, sales and corresponding location names who have achieved Sales more than 130000. 

 

III. To display names of those salesmen who have 'SINGH' in their names.

 

 IV. Identify Primary key in the table SALES. Give reason for your choice.

 

 V. Write a SQL command to change the LocationID to 104 of the Salesman with 


Please click the link below to download CBSE Class 12 Informatics Practices Sample Paper 2021 Set B


How to download CBSE Class 12 Informatics Practices Sample Paper 2021 Set B in PDF?

Students can easily download the CBSE Class 12 Informatics Practices Sample Paper 2021 Set B from our website to prepare for their upcoming examinations. To score high marks, it is important for Class 12 students to understand the exaact pattern as per which teachers design the question papers. We strongly suggest that you practice these latest sample papers for Informatics Practices and solve different types of questions that are expected to come this year. You can downloadin PDF format so that you can practice offline. We also recommend that Class 12 students solve these papers actual exam conditions at home.

Why should you solve CBSE Class 12 Informatics Practices Sample Paper 2021 Set B?

Practicing these model papers has several benefits for Class 12 students:

  • New Question Bank: This set has fresh questions for Informatics Practices which are different from previous years.
  • Exam Pattern Knowledge: Solving more sets will help you to understand the weightage of each chapter in Class 12 and also the type of questions asked.
  • Identify Weak Areas: Comparing your score in each set to find out topics in Class 12 Informatics Practices for which you need hard work.
  • Speed and Accuracy: Attempting MCQ questions and long-form problems for Class 12 Informatics Practices makes you faster and better and you will be able to finish your exam on time.

What should you do after solving CBSE Class 12 Informatics Practices Sample Paper 2021 Set B?

  1. Check Your Work: Match your answers with the solutions given by our teachers in the Informatics Practices Sample Paper PDF.
  2. Learn from Mistakes: Class 12 students should focus on the questions which you solved incorrectly and understand the error.
  3. Revision: If you find a question difficult you shoul refer to NCERT book for Class 12 Informatics Practices to understand concepts and then try the question again.
  4. Continuous Practice: Solve multiple sets of Informatics Practices sample papers from studiestoday.com to build confidence before the CBSE exams.
Where can I download the PDF for CBSE Class 12 Informatics Practices Sample Paper 2021 Set B?

You can download the complete PDF for CBSE Class 12 Informatics Practices Sample Paper 2021 Set B for free from StudiesToday.com. Our resources for Class 12 Informatics Practices are updated for the latest academic session and follow the official exam pattern.

Are solutions provided for CBSE Class 12 Informatics Practices Sample Paper 2021 Set B?

Yes, CBSE Class 12 Informatics Practices Sample Paper 2021 Set B comes with detailed, teacher-verified solutions. We have provided step-by-step answers for Informatics Practices to help students of Class 12 understand correct methodology and marking scheme.

How can practicing CBSE Class 12 Informatics Practices Sample Paper 2021 Set B help in exam preparation?

Practicing this Informatics Practices paper helps in time management and identifying important topics. For Class 12, solving mock papers is the best way to gain confidence and reduce exam-day anxiety.

Is the CBSE Class 12 Informatics Practices Sample Paper 2021 Set B accessible on mobile and tablets?

Yes, all our study materials for Class 12 Informatics Practices are provided in a mobile-friendly PDF format. You can easily download CBSE Class 12 Informatics Practices Sample Paper 2021 Set B on your mobile device.