The CBSE Class 10 IT 402 Sample Question Paper 2021-22 Term 2 with Solution is a helpful resource for students getting ready for their board examinations. In Term 2, the exams focused more on descriptive and application-based questions after the COVID period, so practicing this sample paper allows students to understand the new exam pattern, improve writing skills, and manage time effectively.
With the help of the solved answers, students can revise important topics, check their preparation level, and clear their doubts easily. Class 10 Information Technology Code 402 sample paper is a great tool to gain confidence and perform better in the Term 2 examination by becoming familiar with the question style used by CBSE.
CBSE Class 10 IT 402 Sample QP 2021-22 Term 2 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 10 Information Technology (402) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 10 IT 402 Sample Question Paper Session (2021-22) Term 2
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATION TECHNOLOGY (SUBJECT CODE - 402)
Sample Question Paper (SQP) Solution for Class X (Session 2021-2022)
Max. Time: 2 Hours
Max. Marks: 50
General Instructions:
- Please read the instructions carefully
- This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.
- Section A is of 05 marks and has 06 questions on Employability Skills.
- Questions numbers 1 to 4 are one mark questions. Attempt any three questions.
- Questions numbers 5 and 6 are two marks questions. Attempt any one question.
- Section B is of 12 marks and has 12 questions on Subject Specific Skills.
- Questions numbers 7 to 12 are one mark questions. Attempt any four questions.
- Questions numbers 13 to 18 are two marks questions. Attempt any four questions.
- Section C is of 08 marks and has 03 competency-based questions.
- Questions numbers 19 to 21 are four marks questions. Attempt any two questions.
- Do as per the instructions given in the respective sections.
- Marks allotted are mentioned against each section/question
SECTION A: (3+2=5 Marks)
Answer any 3 questions out of the given 4 questions. Each question is of mark. (1X3=3)
Q.1 Give any one quality of a successful entrepreneur.
Ans: They are confident
Ans: They are confident
Q.2 Name the term used for a false belief or opinion about something.
Ans: Myth
Ans: Myth
Q.3 Give any one practice / sustainable process that is being used to help preserve the environment.
Ans: one such practice is : organic farming/ vermicomposting etc.
Q.4 Give an example of large scale production of solar power in India.
Ans: Charanka - Gujarat Solar Park
Answer any 1 question out of the given 2 questions. Each question is of 2 marks. (2X1=2)
Q.5 Explain any two functions of an entrepreneur.
Ans: Any two functions of an entrepreneur are:
(i) making decisions: An entrepreneur takes important decisions related to the business such as what to produce, how much to produce, where to invest money, and which resources to use. Good decision-making helps the business grow and run smoothly.
(ii) Managing the business: An entrepreneur manages all the activities of the business like hiring workers, organizing work, controlling expenses, and ensuring that work is completed on time. Proper management helps in achieving business goals efficiently.
Q.6 ‘Reduced Inequalities’ is one of the Sustainable development goals set by the UN. Give any two ways to reduce inequalities.
Ans: Two easy to reduce inequalities are:
(i) be helpful to one another.
(ii) be friendly with everyone
SECTION B (4+8=12 marks)
Answer any 04 questions out of the given 06 questions (1X4=4)
Q.7 Name the device that converts digital signal to analog that can travel over phone lines.
Ans: MODEM
Q.8 key is an accessibility function which is designed for people who have vision impairment or cognitive disabilities.
Ans: Toggle key
Q.9 Networks in which certain computers have special dedicated tasks, providing services to other computers (in the network) are called networks.
Ans: Client server
Q.10 Mention any two integer data types of a table field in database.
Ans: 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.
Ans: One to Many Relationship or Many to One Relationship
Q.12 Define Reports of a database.
Ans: 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.
Answer any 04 questions out of the given 06 questions (2X4=8)
Q.13 List any 4 advantages associated with networking.
Ans: 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.
Ans: 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.
Ans: 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?
Ans: 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.
Ans: 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:
(i) Records can be added to a related table, if there is no associated record available in the primary key table.
(ii) The values can be modified in a primary if any dependent records are present in the associated table(s).
(iii) 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.
Ans:
| Columns | Data Type |
|---|---|
| Flight No | Text |
| No. of Passengers | Integer |
| Airlines | Text |
| Arrival Time | Date/Time |
| Departure Time | Date/Time |
| Fares | Float |
SECTION C (2X4=8 marks) (COMPETENCY BASED QUESTIONS)
Answer any 02 questions out of the given 03 questions.
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.Ans: WhatsApp, Google Talk , Yahoo! Messenger , Skype , Windows Live Messenger , Rediff Bol, MS-Teams, ZOOM etc.
b) Apart from computers, list 4 hardwares that Rahul and Amit need for videoconferencing.Ans: 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.Ans: credit, debit card or by internet banking etc
2. Name any 2 situations where online shopping could be useful.Ans: (i) A customer does not have sufficient time to visit stores.(ii) Visiting a store is more expensive than purchasing a product online.(iii) A product or service that is not available in the local market is available online. etc
3. Name any 2 popular online transaction websites.Ans: Flipkart , amazon, Myntra etc.
4. Write full form of COD in reference to online shopping.Ans: Cash On Delivery
21.
NUMBER
NAME
AGE
SUBJECT
DATE 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.Ans: Select * from Teachers where subject = “COMPUTER”;
b) To list the details of all the teachers who are getting salary between 20000 to 35000.Ans: Select * from teachers where salary >= 20000 and salary <= 35000;
c) To display the subject of all the teachers whose age is more than 40 years.Ans: Select Subject from Teachers where age > 40;
d) To display the list of names of all the teachers in alphabetical order.Ans: Select * from Teachers order by name;
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.
Ans: WhatsApp, Google Talk , Yahoo! Messenger , Skype , Windows Live Messenger , Rediff Bol, MS-Teams, ZOOM etc.
b) Apart from computers, list 4 hardwares that Rahul and Amit need for videoconferencing.
Ans: 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.
Ans: credit, debit card or by internet banking etc
2. Name any 2 situations where online shopping could be useful.
Ans: (i) A customer does not have sufficient time to visit stores.
(ii) Visiting a store is more expensive than purchasing a product online.
(iii) A product or service that is not available in the local market is available online. etc
3. Name any 2 popular online transaction websites.
Ans: Flipkart , amazon, Myntra etc.
4. Write full form of COD in reference to online shopping.
Ans: Cash On Delivery
21.
| NUMBER | NAME | AGE | SUBJECT | DATE 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.
Ans: Select * from Teachers where subject = “COMPUTER”;
b) To list the details of all the teachers who are getting salary between 20000 to 35000.
Ans: Select * from teachers where salary >= 20000 and salary <= 35000;
c) To display the subject of all the teachers whose age is more than 40 years.
Ans: Select Subject from Teachers where age > 40;
d) To display the list of names of all the teachers in alphabetical order.
Ans: Select * from Teachers order by name;
Download Now - Class 10 IT 402 Sample Question Paper 2021-22 Term 2 with Solution
