SEKSARIA SUSHILA DEVI PUBLIC SCHOOL, HATHRAS

PREBOARD EXAMINATION (2023-24)

CLASS – X

SUBJECT – INFORMATION TECHNOLOGY (402) Date :17/01/2024

TIME :2 hour 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

Q 1. Answer any 4 out of the given 6 questions on Employability Skills (1 × 4 = 4 marks)

1) ______ is a common response to danger in all people and animals.
(a) Survival stress (c) Fatigue related stress
(b) Internal stress (d) Environmental stress
2) A ______ is a group of sentences dealing with a particular topic.
(a) word (b) paragraph (c) value (d) None of these
3) 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
4) In ______, we change from our normal activities to silence.
(a) worries (b) survival (c) meditation (d) stress
5) ______ 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
6) There is no ______ income available to an entrepreneur.
(a) regular or fixed (b) leadership (c) motivator (d) None of these

SSDPS / A.Y. 23-24 / PREBOARD 2 / X / INFORMATION TECHNOLOGY Page 1 of 5

Q 2. Answer any 5 out of the given 6 questions (1 × 5 = 5 marks)
1) Akshat wants to store a huge amount of information about his firm in a database. Which type of table
organization would be most suitable for this purpose?
(a) Hierarchical (b) Relational (c) Flat file (d) Either b or d
2) Safari is a web browser developed by_____.
(a) Apple (b) Google (c) Microsoft (d) None of these
3) When you apply a______, you apply a group of formatting effects together in one single step.
(a) style (b) effect (c) format (d) template
4) 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
5) To copy a formula from one cell to another.
(a) Cut the cell (c) Both (a) and (b)
(b) Drag the autofill handle (d) None of these
6) A ______ is a language that enables users to access and manipulate data in a database.
(a) DCL (b) TCL (c) DDL (d) DML

Q 3. Answer any 5 out of the given 6 questions (1 × 5 = 5 marks)

1) In______topology, each node is connected to two and only two neighbouring nodes.
(a) ring (b) mesh (c) tree (d) star
2) 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
3) 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
4) 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
5) State True or False.
‘Goal seek in Calc, helps us to find the desired result by adjusting an input value.’
6) 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

SSDPS / A.Y. 23-24 / PREBOARD 2 / X / INFORMATION TECHNOLOGY Page 2 of 5

Q 4. Answer any 5 out of the given 6 questions (1 × 5 = 5 marks)
1) ______are the ways to produce the data stored in databases and tables in a printed form.
(a) Data (b) Reports (c) Forms (d) Queries
2) 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
3) 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
4) What dialog box opens on choosing File > Templates > Manage Templates in Writer?
(a) The Templates dialog box (c) The File dialog box
(b) The Record Template dialog box (d) The Manage Templates dialog box
5) 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
6) _______ are pre-defined formulas in Calc.
(a) Autofill (b) Solver (c) Subtotal (d) Functions

Q 5. Answer any 5 out of the given 6 questions (1 × 5 = 5 marks)

1) Which tab is used to create Table of Contents in a document?
(a) Insert tab (b) Styles tab (c) File tab (d) Format tab
2) A______is a set of instructions used to perform a specific task or operations.
(a) Spyware (b) Software (c) Firewall (d) Hardware
3) 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
4) 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 (c) Data redundancy
(b) Data inconsistency (d) Data piracy
5) How much space does the DATE/TIME data type hold in Base?

SSDPS / A.Y. 23-24 / PREBOARD 2 / X / INFORMATION TECHNOLOGY Page 3 of 5

 (a) 8 bytes (b) 10 bytes (c) 2 bytes (d) 4 bytes
6) ______ 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

Answer any 3 out of the given 5 questions on Employability Skills. Answer each question in 20 – 30
words. (2 × 3 = 6 marks)
Q 6. Give the short term solutions for sustainable development.
Q 7. Write the advantages of non-verbal communication.
Q 8. What do you mean by internal stress?
Q 9. Explain innovativeness as a quality of entrepreneur.
Q 10. What are the facilities provided by operating system?

Answer any 4 out of the given 6 questions in 20 – 30 words each (2 × 4 = 8 marks)

Q 11. State any two practices for internet security.
Q 12. What do you mean by template?
Q 13. Elucidate the following terms:
(a) PAN (b) WiMAX
Q 14. What is the difference between absolute and relative hyperlinks as used in Calc?
Q 15. Write the steps to insert a record in a Datasheet View.
Q 16. Explain the significance of primary and foreign keys.

Answer any 3 out of the given 5 questions in 50 – 80 words each (4 × 3 = 12 marks)

Q 17. What is sorting? How to use ascending or descending sort which depends on one column?
Q 18. Pinky had heard about the words types of networks. She had some doubts. Answer to her queries to
clear her doubts.
(a) What is PAN?
(b) Define the term WAN.
(c) Define the term MAN.
(d) Write a disadvantage of both LAN and WAN.
Q 19. Shaurya had already created a paragraph style. Now, he wants to delete it. What are the steps required
to delete the created style?

SSDPS / A.Y. 23-24 / PREBOARD 2 / X / INFORMATION TECHNOLOGY Page 4 of 5

Q 20. What do you understand by Network Architecture? Name and explain the types of Network
Architecture.
Q 21. Consider the following table: Employee
Table : Employee

Emp_no E_name Profile Manager Hire_date Salary Commission Dept_no

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 MAHADEVAN MANAGER 8839 1991-04-02 29850 NULL 20

8654 MOMIN SALESMAN 8698 1991-09-28 12500 1400.00 30

8698 BINA MANAGER 8839 1991-05-01 28500 NULL 30

1) Write the SQL queries for the following:

(a) Display E_name and Salary of those employees whose Salary is greater than or equal to
22000.
(b) Display details of employees those are not getting Commission.
(c) Display all the details of the employee profile ‘SALESMAN’.
2) How many fields and records are there in the table Employee?

For Visually Impaired Students only.

Q 21. Define the following types of integrity:

(a) Entity integrity
(b) Domain integrity
(c) Referential integrity
(d) User defined integrity

______________

SSDPS / A.Y. 23-24 / PREBOARD 2 / X / INFORMATION TECHNOLOGY Page 5 of 5