Home   »   Sample Papers   »   CBSE Class 10 Information Technology(IT) Term...

CBSE Class 10 Information Technology (IT) Term 2 Sample Paper with Solutions 2021-22

Class 10 Information Technology (IT) Sample Paper Term 2

The Central Board of Secondary Education has scheduled the Class 10 IT exam for 24th May 2022. The students can solve the Class 10 Information Technology(IT) Sample Paper Term 2 given on this page to assess their preparation for the final examination. With the help of Class 10 Information Technology(IT) Sample Paper Term 2, the students can know the marking scheme, question pattern, and difficulty level of the question paper. We have given Class 10 Information Technology(IT) Sample Paper Term 2 with solutions on this page so if students get stuck in any question they can check the solution and can know the art of framing answers by taking the reference of solutions given in Class 10 Information Technology(IT) Sample Paper Term 2.

Click Here To Check CBSE Class 10 Information Technology (IT) Term 2 Answer Key 2022

CBSE Term 2 Sample Paper Class 10 Information Technology (IT): Exam Pattern

As per CBSE Term 2 Sample Paper Class 10 Information Technology(IT), Class 10 Information Technology subject consists of 25 marks and students will get 1 hour to solve the question paper of Class 10 Term 2 Information Technology. According to CBSE Term 2 Sample Paper Class 10 Information Technology(IT), the Class 10 Term 2 Information Technology question paper is divided into three sections namely Section A, Section B, and Section C. Check the details of these sections listed below:

Section A: This section consists of 5 marks and has 6 questions on Employability Skills.

Section B: This section consists of 12 marks and has 12 questions on Subject Specific Skills.

Section C: This section consists of 8 marks and has 3 competency-based questions.

Class 10 Information Technology(IT) Term 2 Sample Paper 2021-22 with PDF Solutions

SECTION A

Q.1 Give any one quality of a successful entrepreneur

They are confident

Q.2 Name the term used for a false belief or opinion about something.

Myth

Q.3 Give any one practice / sustainable process that is being used to help preserve the environment.

one such practice is : organic farming/ vermicomposting etc.

Q.4 Give an example of large scale production of solar power in India

Charanka – Gujarat Solar Park

Q.5 Explain any two functions of an entrepreneur.

Any two functions of an entrepreneur are :
a. making decisions:
b. Managing the business

Q.6 ‘Reduced Inequalities’ is one of the Sustainable development goals set by the UN. Give any two ways to reduce inequalities.

Two easy to reduce inequalities are :
– be helpful to one another.
– be friendly with everyone

SECTION B

Q.7 Name the device that converts digital signal to analog that can travel over phone lines.

MODEM

Q.8 _____key is an accessibility function which is designed for people who have vision impairment or cognitive disabilities

Toggle key

Q.9 Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called _____networks

Client server

Q.10 Mention any two integer data types of a table field in database.

TINYINT, SMALLĪNT, INTEGER, NUMERIC, BIGINT

Q.11 Name the relationship in which one column of the primary key table is associated with all the columns of the associated table and vice versa.

One to Many Relationship or Many to One Relationship

Q.12 Define Reports of a database.

A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format. You can create reports in the database.

Q.13 List any 4 advantages associated with networking

Four advantages are :
Data Sharing
Files Transfer
Hardware Sharing.
Internet Access Sharing
Usage of network based applications

Q.14 Differentiate between wired and wireless access. Give one example for each type.

A wired setup uses physical cables to transfer data between different devices and computer systems. Wireless network does not use wires for data or voice. Examples Wired: Dial-up, DSL or Cable Internet Access etc

Wireless .3G or WiMAX or Wi-Fi

Q.15 What do you understand by ISP with respect to web applications? Name any two connection type that home users use.

An Internet service provider (ISP) is an organization which provides you with access to the Internet via a dial-up (using modem) or direct (hard wired) or wireless connection. DSL, cable modem, dial-up, broadband wireless, WiMAX etc

Q.16 How Entry Required and Default Value properties of a table field in a database are different from each other?

Entry Required – if set to yes then it will be necessary for the user to insert the value in the field which means that field cannot be left blank.
Default Value – A default value can be set for a field if user don’t provide any value while entering the values in the table

Q.17 What is Referential Integrity? Explain its two(any) purposes.

Referential Integrity is used to maintain accuracy and consistency of data in a relationship. In Base, data can be linked between two or more tables with the help of primary key and foreign key constraints. Referential integrity helps to avoid:
1. Records can be added to a related table, if there is no associated record available in the primary key table.
2. The values can be modified in a primary if any dependent records are present in the associated table(s).
3. Deleting records from a primary key table if there are any matching related records available in associated table(s)

Q.18 Identify the columns and data types of a table: Airlines. Mention at least four columns with data type.

Columns                               Data type
Flight No                               Text
No.of Passengers                 Integer
Airlines                                  Text
Arrival Time                       Date/Time
Departure Time                   Date/Time
Fares                                      Float

SECTION C

Q.19 Rahul and Amit are working on a school project assigned to them by their teacher. They have to send instant messages to each other and also do video conferencing after school hours in order to complete the project on time.
a. Suggest any 4 good instant messaging software that they can use.
b. Apart from computers, list 4 hardwares that Rahul and Amit need for videoconferencing.

a. Google Talk , Yahoo! Messenger , Skype , Windows Live Messenger , Rediff Bol, MS-Teams, ZOOM etc.

b. Headphone, Speaker & Microphone & Web Camera

Q.20 Rahul has purchased some stationary items from an online site. He has to make online payment for the items to complete the transaction. Help by answering his following queries.
1. Suggest any two options that he can use to make payment of his bill on the online shopping website.
2. Name any 2 situations where online shopping could be useful.
3. Name any 2 popular online transaction websites.
4. Write full form of COD in reference to online shopping.

1. credit, debit card or by internet banking etc(1/ 2
marks for each correct options)
2.
• A customer does not have sufficient time to visit stores.
• Visiting a store is more expensive than purchasing a product online.
• A product or service that is not available in the local market is available online. etc

3. Flipkart , amazon, Myntra etc

1. Cash On Delivery

Q.21

Number Name Age Subject Data of Join  Salary Gender
1 Jugal 34 Computer 10/01/2019 12000 M
2 Pratigya 31 Science 24/03/2019 20000 F
3 Sandeep 32 Maths 12/12/2019 30000 M
4 Sangeeta 35 Science 01/07/2020 40000 F
5 Satti 42 Maths 05/09/2020 25000 M
6 Shyam 50 Science 27/06/2021 30000 M
7 Shiv Om 44 Computer 25/02/2021 21000 M
8 Shalakha 33 Maths 31/07/2020 20000 F

Write SQL commands:
a. To show all the information about IT teachers.
b. To list the details of all the teachers who are getting salary between 20000 to 35000.
c. To display the subject of all the teachers whose age is more than 40 years.
d. To display the list of names of all the teachers in alphabetical order

a. Select * from Teachers where subject = “COMPUTER”;
b. Select * from teachers where salary >= 20000 and salary <= 35000;
c. Select Subject from Teachers where age > 40;
d. Select * from Teachers order by name

Q. 21 FOR VISUALLY IMPAIRED STUDENTS.
Define the following:
a. Data Integrity
b. Data Inconsistency
c. Composite Primary Key
d. Relationship (with respect to DBMS)

a. Data Integrity: Data Integrity is very important as there are multiple databases in
a DBMS. It means that the data is accurate and consistent in the database.
b. Data Inconsistency: Data inconsistency is when the same data exists in different forms in multiple tables. Which can provide a unreliable or meaningless information.
c. Composite Primary Key: It is also called a composite key. It is a combination of two or more columns to form a primary key for a table
d. Relationship: A relationship refers to an association or connection between two or more tables. When we relate two tables, we don’t need to enter the same data in separate tables.
Three types of relationships are:
1. One to One relationship
2. One to many or many to one relationship
3. Many to many relationships

Related Post:

Class 10 Information Technology(IT) Term 2 Sample Paper with Solutions 2021-22: FAQs

Q. Which sample paper is best for CBSE Class 10 Term 2 Information Technology?
The sample paper given on this page is best for CBSE Class 10 Term 2 Information Technology(IT).
Q. Where can I get Information Technology(IT) sample papers for CBSE Class 10 Term 2?
You can get Information Technology(IT) sample papers for CBSE Class 10 Term 2 on this page.
Q. When will CBSE conduct CBSE Class 10 Term 2 Exam 2022 for Information Technology?
The CBSE will conduct the CBSE Class 10 Term 2 Exam 2022 for Information Technology on 24th May 2022.

Sharing is caring!

Thank You, Your details have been submitted we will get back to you.