Chap 1 Sample Paper 2 Page 1

Sample Paper 2
INFORMATION TECHNOLOGY (402)
Class X Session 2022-23
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.

SECTION - A
Objective Type Questions

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

(i)______is a common response to danger in all people and animals.

(a) Survival stress (b) Internal stress
(c) Fatigue related stress (d) Environmental stress

(ii) A______is a group of sentences dealing with a particular topic.

(a) word (b) paragraph
(c) value (d) None of these

(iii) The idea of sustainable development gained wide acceptance due to environment concerns in the_______.
(a) 20th century (b) 21th century
(c) 18th century (d) 19th century

(iv) In______, we change from our normal activities to silence.

(a) worries (b) survival
(c) meditation (d) stress

(v) ______is the arrangement of elements on the slide with which the slide is available.
(a) Custom animation (b) Slide transition
(c) Slide layout (d) None of these

Install NODIA App to See the Solutions.

Click Here To Install
Page 2 Sample Paper 2 Chap 1

(vi) There is no______income available to an entrepreneur.

(a) regular or fixed (b) leadership
(c) motivator (d) None of these

2. Answer any 5 out of the given 6 questions

(i) Akshat wants to store a huge amount of information about his firm in a database. Which type of table organisation
would be most suitable for this purpose?
(a) Hierarchical (b) Relational
(c) Flat file (d) Either relational or flat file

(ii) Safari is a web browser developed by_____.

(a) Apple (b) Google
(c) Microsoft (d) None of these

(iii) When you apply a______, you apply a group of formatting effects together in one single step.
(a) style (b) effect
(c) format (d) template

(iv) When you define a field for a table, in which of the following parameters do access always considered optional?
(a) Field size (b) Field name
(c) Description (d) Data type

(v) To copy a formula from one cell to another.

(a) Cut the cell (b) Drag the autofill handle
(c) Both (a) and (b) (d) None of these

(vi) A______is a language that enables users to access and manipulate data in a database.
(a) DCL (b) TCL
(c) DDL (d) DML

3. Answer any 5 out of the given 6 questions

(i) In______topology, each node is connected to two and only two neighbouring nodes.
(a) ring (b) mesh
(c) tree (d) star

(ii) Select_____> Track changes > Record from the menu bar. Thereafter, every change you record on the spreadsheet
will have a red border around it.
(a) Format (b) Layout
(c) File (d) Edit

(iii) Rajiv was asked to highlight the cells with green colour where the value entered is either greater than or equals
to 120 in the worksheet containing thousands of data entries. Which feature of Calc should he use to get this
work done within seconds?
(a) Filtering (b) Sorting
(c) Simple formatting (d) Conditional formatting

Install NODIA App to See the Solutions.

Click Here To Install
Chap 1 Sample Paper 2 Page 3

(iv) Calc considers any data that it does not recognise as a number, date, time or formula, as:
(a) Text (b) Expression
(c) Function (d) Equation

(v) State True or False.

‘Goal seek in Calc, helps us to find the desired result by adjusting an input value.’
(a) False
(b) True

(vi) Which of the following tools will help Swati, if she wants to arrange the height of students in her class in
ascending order ?
(a) Sorting data (b) Presenting data
(c) Referring data (d) Ordering data

4. Answer any 5 out of the given 6 questions

(i) ______are the ways to produce the data stored in databases and tables in a printed form.
(a) Data (b) Reports
(c) Forms (d) Queries

(ii) In URL, http : // www.abc.com/ index. htm, which component identifies the path of a web page?
(a) /index. htm (b) http
(c) www.abc.com (d) All of these

(iii) Tamanna wants to know the name of the kind of software which seems useful in the beginning, but will cause
damage to the computer once installed. What is such kind of software called?
(a) Malware (b) Virus
(c) Worm (d) Trojan horse

(iv) What dialog box opens on choosing File > Templates > Manage Templates in Writer?
(a) The Templates dialog box
(b) The Record Template dialog box
(c) The File dialog box
(d) The Manage Templates dialog box

(v) Arnab learnt about a software which gets installed on the computer without the user’s knowledge. Help him to
find the name of the same.
(a) Malware (b) Adware
(c) Spyware (d) None of these

(vi) _______are pre-defined formulas in Calc.

(a) Autofill
(b) Solver
(c) Subtotal
(d) Functions

Install NODIA App to See the Solutions.

Click Here To Install
Page 4 Sample Paper 2 Chap 1

5. Answer any 5 out of the given 6 questions.

(i) Rinky wants to know about the Number data type in Calc. Which of the following statement ( s) is/are TRUE
about it?
(a) By default, number and date data is aligned to the right in Calc.
(b) Numbers are generally raw numbers or dates.
(c) Numbers can be started with a dollar sign ($) or with some other currency symbols to display as currency.
(d) All of the above

(ii) If the two departments (HR and IT) access the data simultaneously then only one department will see the
updates by the other department. DBMS solves this issue. Thus, DBMS helps to avoid______which means if a
single database is used by multiple users then it also ensures that the same data is present for all the users.
(a) Data modification (b) Data redundancy
(c) Data inconsistency (d) Data piracy

(iii) Which tab is used to create Table of Contents in a document?

(a) Insert tab (b) Styles tab
(c) File tab (d) Format tab

(iv) A______is a set of instructions used to perform a specific task or operations.

(a) Spyware (b) Software
(c) Firewall (d) Hardware

(v) How much space does the DATE/TIME data type hold in Base?
(a) 8 bytes (b) 10 bytes
(c) 2 bytes (d) 4 bytes

(vi) ______is a form of electronic commerce that allows customers to directly buy goods or services from a seller
on the Internet.
(a) E-buying (b) E-Delivery
(c) E-Shopping (d) E-ticketing

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. Each question carry 2 marks.

6. Give the short term solutions for sustainable development.

7. Write the advantages of non-verbal communication.

8. What do you mean by internal stress?

Install NODIA App to See the Solutions.

Click Here To Install
Chap 1 Sample Paper 2 Page 5

9. Explain innovativeness as a quality of entrepreneur.

10. What are the facilities provided by operating system?

Direction for Q 11-Q 16 : Answer any 4 out of the given 6 questions in 20-30 words. Each question carry 2 marks.

11. State any two practices for internet security.

12. What do you mean by template?

13. Elucidate the following terms:

(i) PAN
(ii) WiMAX

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

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

16. Explain the significance of primary and foreign keys.

Direction for Q 17-Q 21 : Answer any 3 out of the given 5 questions in 50-80 words. Each question carry 4 marks.

17. Shaurya had already created a paragraph style. Now, he wants to delete it. What are the steps required to delete the
created style?

18. What is sorting? How to use ascending or descending sort which depends on one column?

19. Consider the following table: Employee

Table : Employee
Emp_no E_name Profile Man Hire_date Salary Comm Dept no
ager ission
8369 SMITH CLERK 8902 1990-12-18 8000 NULL 20
8499 ANYA SALESMAN 8698 1991-02-20 16000 300.00 30
8521 SETH SALESMAN 8698 1991-02-22 12500 500.00 30
8566 MAHA MANAGER 8839 1991-04-02 29850 NULL 20
DEVAN
8654 MOMIN SALESMAN 8698 1991-09-28 12500 1400.00 30
8698 BINA MANAGER 8839 1991-05-01 28500 NULL 30
(a) Write the SQL queries for the following:
(i) Display E name and Salary of those employees whose Salary is greater than or equal to 22000.
(ii) Display details of employees those are not getting Commission.
(iii) Display all the details of the employee profile ‘SALESMAN’.
(b) How many fields and records are there in the table Employee?

Install NODIA App to See the Solutions.

Click Here To Install
Page 6 Sample Paper 2 Chap 1

20. Pinky had heard about the words types of networks. She had some doubts. Answer to her queries to clear her doubts.
(i) What is PAN?
(ii) Define the term WAN.
(iii) Define the term MAN.
(iv) Write a disadvantage of both LAN and WAN.

21. Define the following types of integrity :

(i) Entity integrity
(ii) Domain integrity
(iii) Referential integrity
(iv) User defined integrity

******

Install NODIA App to See the Solutions.

Click Here To Install