Previous Year Question Paper with Answer of “Information Technology – Code: 402” for Class 10 NSQF Vocational, CBSE Session 2021-2022.

CBSE| Vocational Education

Information Technology – Code: 402

Class 10

(Session 2021-2022)

Previous Year Solved Question Paper for Term – 2

Max. Time Allowed: 1 Hour (60 Min) Max. Marks: 25

General Instructions:

1. Please read the instructions carefully
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.
4. a) Questions numbers 1 to 4 are one mark questions. Attempt any three questions.
5. b) Questions numbers 5 and 6 are two marks questions. Attempt any one question.
6. Section B is of 12 marks and has 12 questions on Subject Specific Skills.
7. a) Questions numbers 7 to 12 are one mark questions. Attempt any four questions.
8. b) Questions numbers 13 to 18 are two marks questions. Attempt any four questions.
9. Section C is of 08 marks and has 03 competency-based questions.
10. a) Questions numbers 19 to 21 are four marks questions. Attempt any two questions.
11. Do as per the instructions given in the respective sections.
12. 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. 1 x 3 = 3

Q.1 Give any one quality of a successful entrepreneur 1

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

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

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

Answer any 1 question out of the given 2 questions. Each question is of 2 marks. 2 x 1 = 2

Q.5 Explain any two functions of an entrepreneur. 2

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

SECTION B

(4 + 8 = 12 marks)

Answer any 04 questions out of the given 06 questions 1 x 4 = 4

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

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

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

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

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. 1

Q.12 Define Reports of a database. 1

Answer any 04 questions out of the given 06 questions 2 x 4 = 8

Q.13 List any 4 advantages associated with networking. 2

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

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

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

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

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

SECTION C

(2 x 4 = 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.

1. Suggest any 4 good instant messaging software that they can use.
2. Apart from computers, list 4 hardwares that Rahul and Amit need for videoconferencing. 4

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. 4

Q.21

Write SQL commands:

1. To show all the information about IT teachers.
2. To list the details of all the teachers who are getting salary between 20000 to 35000.
3. To display the subject of all the teachers whose age is more than 40 years.
4. To display the list of names of all the teachers in alphabetical order. 4
5. FOR VISUALLY IMPAIRED STUDENTS.

Define the following:

1. Data Integrity
2. Data Inconsistency
3. Composite Primary Key
4. Relationship (with respect to DBMS)

ANSWERS

 SECTION A

(3 + 2 = 5 marks)

Answer any 3 questions out of the given 4 questions. Each question is of mark. 1 x 3 = 3

ANS.1 They are confident 1

ANS.2 Myth 1

ANS.3one such practice is : organic farming/ vermicomposting etc. 1

ANS.4 Charanka – Gujarat Solar Park 1

Answer any 1 question out of the given 2 questions. Each question is of 2 marks. 2 x 1 = 2

ANS.5 Any two functions of an entrepreneur are :

1. making decisions:
2. Managing the business 2

ANS. 6 Two easy to reduce inequalities are :

– be helpful to one another.

– be friendly with everyone 2

SECTION B

(4 + 8 = 12 marks)

Answer any 04 questions out of the given 06 questions 1 x 4 = 4

ANS .7 MODEM 1

ANS.8 Toggle key 1

ANS.9 Client server 1

ANS.10 TINYINT, SMALLĪNT, INTEGER, NUMERIC, BIGINT (½ mark for each integer datatype) 1

ANS.11 One to Many Relationship or Many to One Relationship 1

ANS.12 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. 1

Answer any 04 questions out of the given 06 questions 2 x 4 = 8

ANS.13 Four advantages are:

Data Sharing

Files Transfer

Hardware Sharing.

Internet Access Sharing

Usage of network based applications

½ marks for each correct advantage listed 2

ANS.14 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

1 marks for correct difference

½ marks for each correct example 2

ANS.15 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

1 marks for the correct definition and 1/2 each for correct connection type 2

ANS.16

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 doesn’t provide any value while entering the values in the table. (1 mark for each property) 2

ANS.17

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) ( 1 mark for definition. ½ mark each for any two purposes.) 2

ANS.18 Columns Data type

Flight No Text

No.of Passengers Integer

Airlines Text

Arrival Time Date/Time

Departure Time Date/Time

Fares Float (½ mark for each column & data type) 2

SECTION C

(2 x 4 = 8 marks)

(COMPETENCY-BASED QUESTIONS)

Answer any 02 questions out of the given 03 questions

ANS.19 a. Google Talk , Yahoo! Messenger , Skype , Windows Live Messenger , Rediff Bol, MS-Teams, ZOOM etc. ½ marks for each correct name

1. Headphone, Speaker & Microphone & Web Camera – ½ marks for each correct hardware listed 4

ANS.20

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. (1/ 2 marks for each correct situation )

3.Flipkart , amazon, Myntra etc. (1/ 2 marks for each correct name of website)

1. Cash On Delivery

1 marks for correct full form 4

ANS.21

1. Select * from Teachers where subject = “COMPUTER”;
2. Select * from teachers where salary >= 20000 and salary <= 35000;
3. Select Subject from Teachers where age > 40;
4. Select * from Teachers order by name 4

ANS 21

for FOR

VISUALLY

IMPAIRED

STUDENTS

1. 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.
2. Data Inconsistency: Data inconsistency is when the same data exists in different forms in multiple tables. Which can provide a unreliable or meaningless information.
3. 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
4. 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 (1 mark each for all the parts.)