CBSE class 10 x IT 402 computer exam paper INFORMATION TECHNOLOGY (402)Class X Session 2023-24

CBSE class 10 x IT 402 computer exam paper

INFORMATION TECHNOLOGY (402)

Class X Session 2023-24

Time: 2 Hours Max. Marks: 50

General Instructions:

1. Please read the instructions carefully.

2. This Question Paper consists of 21 questions in two sections: Section A & Section B.

3. Section A has Objective type questions whereas Section B contains Subjective type questions.

4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the allotted 

(maximum) time of 2 hours.

5. All questions of a particular section must be attempted in the correct order.

6. SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS):

i. This section has 05 questions.

ii. Marks allotted are mentioned against each question/part.

iii. There is no negative marking.

iv. Do as per the instructions given.

7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):

i. This section has 16 questions.

ii. A candidate has to do 10 questions.

iii. Do as per the instructions given.

iv. Marks allotted are mentioned against each question/part.

SECTION - A

Objective Type Questions

1. Answer any 4 out of the given 6 questions based on Employability Skills

(i) Which of the following is not a symptom of stress?

(a) Irritability (b) Insomnia

(c) Fatigue (d) Fever

(ii) Which of the following is not a type of entrepreneurship activities?

(a) Social (b) Agricultural

(c) Women (d) Leader

(iii)When you start a computer, the operating system gets loaded into the main memory from the hard disk. This is 

called _____.

(a) uploading (b) booting

(c) starting (d) downloading

(iv) The drive within you that compels you to complete tasks is

(a) self-motivation (b) self-regulation

(c) self-awareness (d) self-sufficient

(v) Which of the following is a barrier to effective communication?

(a) Use of jargon and technical terms 

(b) Clear and concise messaging

(c) Active listening (d) Mutual understanding

(vi) What is the role of green skills in waste management?

(a) Encouraging unsustainable disposal methods (b) Promoting recycling and composting practices

(c) Increasing landfills and waste accumulation (d) Disregarding the concept ofresource conservation

2. Answer any 5 out of the given 6 questions

(i) Template includes placeholder text that is surrounded by _____.

(a) arrow (b) brackets

(c) data source (d) commas

(ii) Which of the following is an attribute whose value is derived from the primary key of some other table?

(a) Primary key (b) Foreign key

(c) Alternate key (d) None of these

(iii) Do not use the elevator in times of fire in the building. Always use _____ for such emergencies.

(a) office space (b) staircase

(c) washroom (d) None of these

(iv) Solve option under Tools menu amounts to a more elaborate form of _____. The difference is that the Solver

deals with equations with multiple _____.

(a) unknown variables, goals seek (b) variables, equation

(c) goal seek, unknown variables (d) subtotal, goal seek

(v) Databases have the ability to

(a) store a large amount of data in a structured format, easy update, sort query, production of reports.

(b) spell check, perform calculations, library of mathematical functions, replication.

(c) rotate images, copy and paste, fill scale.

(d) None of the above

(vi) In the Load Style dialog box, option loads the paragraph and the character styles from the selected document 

into the current document.

(a) Page (b) Paragraph

(c) Overwrite (d) Text

3. Answer any 5 out of the given 6 questions

(i) Editing Custom Shapes feature allows _____ of small segments of a drawing.

(a) shaping (b) reshaping

(c) rehearse (d) None of these

(ii) Which tab is used to share the worksheet data?

(a) Home (b) Review

(c) Insert (d) Layout

(iii) _____ is used to transfer files between computers on a network.

(a) Web server (b) FTP

(c) Multimedia (d) Web browser

(iv) A tuple in RDBMS is referred to _____of a table.

(a) record (b) field

(c) table (d) key

(v) Which of the following is not a spreadsheet software?

(a) VisiCalc (b) MS-Excel

(c) Writer (d) Lotus 1-2-3

(vi) _____ function takes data from a series of worksheets or workbooks and summaries it into a single worksheet 

that you can update easily.

(a) Summation (b) Data Consolidation

(c) Data Format (d) Data Chart

4. Answer any 5 out of the given 6 questions

(i) By dragging any _____ handle you can increase or decrease the _____ of the image diagonally.

(a) corner, size (b) side, quality

(c) top, depth (d) corner, quality

(ii) Wireless broadband can be

(a) mobile (b) fixed

(c) Both (a) and (b) (d) None of these

(iii) _____ can deal with multiple variables as the goal seek is used to manipulate one variable cell.

(a) Solver (b) Goal Seek

(c) Scenario (d) what-if

(iv) _____ ensure that all the documents have a standard layout, look and feel.

(a) Graphics (b) Layout

(c) Properties (d) Templates

(v) To join the Internet, the computer has to be connected to a

(a) Internet Architecture Board (b) Internet society

(c) Internet Service Provider (d) None of these

(vi) A relational database is a collection of

(a) attributes (b) tables

(c) records (d) fields

5. Answer any 5 out of the given 6 questions

(i) Which of the following is an AutoShape?

(a) Line (b) Circle

(c) Curve (d) All of these

(ii) _____ determines the range of field values.

(a) Field Name (b) Data Type

(c) Field Size (d) Description

(iii)Which type of hazard can cause skin irritation, illness or breathing problems?

(a) Chemical hazard (b) Biological hazard

(c) Slipping hazard (d) None of the above

(iv) If you have unsafe and unhealthy workplace, there will be higher days lost and will have higher

(a) employee satisfaction (b) productivity

(c) stress levels (d) None of these

(v) Which of the following is/are TCL commands?

(a) COMMIT (b) SAVE POINT

(c) ROLL BACK (d) All of the above

(vi) Rajat has received a spreadsheet, which is reviewed by his subordinates Puneet, Kavya and Aman, who made 

some corrections in it. Before Rajat shared the spreadsheet with his subordinates, he has activated the track 

changes feature. Which of the following option he should use now to keep some of the changes made by them?

(a) Accept and reject changes (b) Overwrite and keep changes

(c) Both (a) and (b) (d) None of the above

SECTION - B

Subjective Type Questions

Direction for Q 6-Q 10 : Answer any 3 out of the given 5 questions on Employability skills. Answer each question in 

20-30 words.

6. What is an operating system?

7. What is fatigue related stress? Why is it difficult to avoid?

8. What is the contribution of the entrepreneurs in the execution of Government policies?

9. In what way does inadequate planning hinder effective communication?

10. How can individuals acquire green skills?

Direction for Q 11-Q 16 :Answer any 4 out of

 the given 6 questions in 20-30 words each.

11. What is the difference between absolute and relative hyperlinks as used in Calc?

12. What do you mean by template?

13. Elucidate the following terms:

(i) PAN

(ii) WiMAX

14. What is the role of a foreign key in a database management system (DBMS)?

15. State any two practices for internet security.

16. Write the steps to insert a record in a Datasheet View.

Direction for Q 17-Q 21 :Answer any 3 out of the given 5 questions in 50-80 words each.

17. Riddhima wants to know about mailing labels in word processor. Help her to find the answers of the given questions.

(a) What is a mailing label?

(b) What are the ways to prepare and print mailing labels?

18. Shubham is learning about DBMS. He wants to know about the following:

(a) The purpose of DBMS

(b) Any two uses of DBMS

19. Consider the following table PRODUCT

TABLE: PRODUCT

S_NO  P_Name  S_Name    Qty    Cost  City

S1      Biscuit     Priyagold   120   12.00 Delhi

S2      Bread       Britannia    200   25.00 Mumbai

S3    Chocolate  Cadbury     350  40.00 Mumbai

S4    Sauce         Kissan        400 45.00 Chennai

(i) How many fields and records are there in PRODUCT table?

(ii) Write SQL queries for the following:

(a) Display all Products whose Qty is between 100 and 400.

(b) Display S_Name, P_Name, Cost for all the Products whose Qty is less than 300.

(c) Display all the records alphabetically by S_Name.

20. Rita is working in spreadsheet. She wants to know about the use of the following terms:

(a) Quick Sort

(b) Filtering Data

21. Rahul has purchased some stationary items from an online site. He has to make online payment for the items to 

complete the transaction. Help him by answering the following queries :

(i) Suggest any two options that he can use to make payment of his bill on the online shopping website.

(ii) Name any 2 situations where online shopping could be useful.

(iii)Name any 2 popular online shopping websites.

(iv) Write full form of COD in reference to online shopping.

******