# Term 2 IT Question Paper Class 10 with Solution

Share with others

## IT Question Paper Class 10 with Solution

IT – 402 Sample Paper – 2020

IT – 402 Sample Paper – 2021 (Term-1)

IT – 402 Term 2 CBSE Sample Paper

## IT Question Paper Class 10 with Solution

Max. Time Allowed: 1 Hour (60 min)

Max. Marks: 25

General Instructions:

2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.
3. Section A is of 05 marks and has 06 questions on Employability Skills.
a) Questions numbers 1 to 4 are one mark questions. Attempt any three questions.
b) Questions numbers 5 and 6 are two marks questions. Attempt any one question.
4. Section B is of 12 marks and has 12 questions on Subject Specific Skills.
a) Questions numbers 7 to 12 are one mark questions. Attempt any four questions.
b) Questions numbers 13 to 18 are two marks questions. Attempt any four questions.
5. Section C is of 08 marks and has 03 competency-based questions.
a) Questions numbers 19 to 21 are four marks questions. Attempt any two questions.
6. Do as per the instructions given in the respective sections.
7. Marks allotted are mentioned against each section/question

## IT Question Paper Class 10 with Solution

Q21. Consider the following table “Chips” and write the queries for the following: 4

1. Display all the records from the table.
2. Display all the records of chips whose price is 10.
3. To display the list of names of all the chips in alphabetical order.
4. To list the details of all the chips whose quantity is greater than 20 and less than 35.

Ans. Queries are

1. Select * from Chips;
2. Select * from Chips where Price = 10;
3. Select C_Name from Chips order by C_Name ;
4. Select * from Chips where Quantity >20 and Quantity < 35;

## IT Question Paper Class 10 with Solution

Max. Time Allowed: 1 Hour (60 min)

Max. Marks: 25

General Instructions:

2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.
3. Section A is of 05 marks and has 06 questions on Employability Skills.
a) Questions numbers 1 to 4 are one mark questions. Attempt any three questions.
b) Questions numbers 5 and 6 are two marks questions. Attempt any one question.
4. Section B is of 12 marks and has 12 questions on Subject Specific Skills.
a) Questions numbers 7 to 12 are one mark questions. Attempt any four questions.
b) Questions numbers 13 to 18 are two marks questions. Attempt any four questions.
5. Section C is of 08 marks and has 03 competency-based questions.
a) Questions numbers 19 to 21 are four marks questions. Attempt any two questions.
6. Do as per the instructions given in the respective sections.
7. Marks allotted are mentioned against each section/question

## IT Question Paper Class 10 with Solution

Q21. Consider the following table “Class” and write the queries for the following: 4

## IT Question Paper Class 10 with Solution

1. Display all the records from the table.
2. Display all the records of class whose strength is more than 40.
3. To display all the records in alphabetical order of sections.
4. To display the details of all the classes whose Fees is greater than 2250 and less than 2400.

Ans. Queries are

1. Select * from Class;
2. Select * from Class where Strength > 40;
3. Select * from Class order by Section ;
4. Select * from Class where Fee >2250 and Fee < 2400;

Disclaimer : I tried to give you the correct solution of “IT Question Paper Class 10 , but if you feel that there is/are mistakes in “ IT Question Paper Class 10 ” given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE official website are used as a reference to create above “ IT Question Paper Class 10

## IT Question Paper Class 10 with Solution

Unit 1 : Introduction to IT–ITeS Industry BOOK SOLUTIONS

Unit 1 : Introduction to IT–ITeS Industry NOTES

Unit 1 : Introduction to IT-ITeS MCQ

Unit 3 : Digital Documentation NOTES

Unit 3 : Digital Documentation BOOK SOLUTIONS

Unit 3 : Digital Documentation MCQ

Unit 4 : Electronic Spreadsheet BOOK SOLUTIONS

Unit 4 : Electronic Spreadsheet MCQ

Unit 5 : Digital Presentation MCQ

UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) MCQ