Class 10 - Information Technology (402)
Sample Paper - 04 (2023-24)
Maximum Marks: 50
Time Allowed: : 2 hours
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.
1. SECTION A: OBJECTIVE TYPE QUESTIONS
2. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
1. Which of the following is not an advantage of working independently?
a) No external pressure b) More efficiency
c) More dependency d) More clarity
2. What should you never do when cleaning a computer?
a) Never use a vacuum cleaner b) All of these
c) Never eat or drink around the computer d) Never unplug the electricity
Which could provide an individual with the motivation to start a new business venture?
a) The financial rewards. b) All of these
c) A desire to be independent . d) challenges
Which of the following method helps the message to be understood clearly and quickly?
a) Face-to-face informal communication b) Notices/posters
c) E-mail d) Business meetings
Which statement is related to the promotion of sustainable development?
a) Treatment of Industrial waste and sewage before releasing in the water bodies
b) Use of biofuels (biogas in the kitchen)
c) Use of hybrid cars instead of conventional cars to reduce air pollution
d) All of these
Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
How many levels of headings does Open Office Writer evaluate to build the Table of contents?
a) 10 b) 9 c) 8 d) 12
Choose the correct option to open picture toolbar.
a) View → Toolbars → Picture b) Tool → Toolbars → Picture
c) View → Picture → Toolbars d) Insert → Toolbars → Picture
Which of the following is a set of formats consisting of such things as fonts, colors, etc?
a) Margin b) Indent c) Leading d) Style
Color toolbar allows us to change
a) All of these b) RGB Color Components c) Gamma effect of image
d) Brightness
Anupama is having one png image. She wants to put it on social media as per profile pic. But
before that, she has to resize it. She is getting many resizing handles there. How many resizing
handles appear when we select any image?
a) 6 b) 12 c) 4 d) 8
Which of the following styles is not offered by Open Office org?
a) Frame Style b) Presentation Style c) Page Style d) Video Style
Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
Raman has received a spreadsheet, which is reviewed by his subordinates Puneet, Kavya and
Aman, who made some corrections in it. Before Raman 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) None of these b) Accept and reject changes
c) Overwrite and keep changes d) Both Accept and reject changes and Overwrite and keep
changes
We can consolidate data by ________.
a) Column Label b) None of these c) Both Row and Column Label d) Row Label
Page margins are the
a) horizontal space b) blank spaces c) vertical space d) cell
We can rename an existing sheet in Calc by
Double click on one of the existing sheet
Right click on existing sheet and then choose rename
Both double click on one of the existing sheet and right click on existing sheet and then choose
rename
None of these
a) (ii) b) (i) c) (iii) d) (iv)
Which command will you choose to convert a column of data into row?
a) Edit >> Paste Special >> Transpose b) Cut and Paste
c) None of these d) Both Cut, Paste and Edit >> Paste Special >> Transpose
Which option is suitable to calculate the effect of different interest rates on an investment.
a) None of these b) consolidate c) Scenario d) Subtotal
Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
Which of the following is suitable to act as a primary key in table student?
a) Roll no b) Name c) Class d) Section
Which of the following clauses can be used with a SELECT command?
a) None of these b) Both of these c) WHERE d) ORDER BY
The default data type for a field is
a) Auto Number b) Currency c) Text d) Number
What do you mean by one to many relationship between Student and class table?
a) Many classes may have many students
b) One class may have many student
c) One student can have many classes
d) Many students may have many classes
Which data type helps you to handle input column that is in boolean format?
a) Yes/No b) OLE Object c) Attachment d) None of these
In which type of database, can you retrieve the data from the related tables.
a) Rational database management system
b) Common database management system
c) Database management system
d) Relational database management system
Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
Networks in which all computers have an equal status are called ________.
a) Client-Server Network
b) Social Network
c) Both Peer-to-Peer and Client-Server Network
d) Peer-to-Peer Network
What are the major different types of network?
a) Local Area Network b) node Network
c) Wide Area Network d) Both Local Area and Wide Area Network
What are the advantages associated with networking?
a) Internet Sharing b) Hardware Sharing c) Data & File Sharing
d) All of these
What is the term for hazards that occur due to occupation?
a) Electrical hazards b) All of these c) Occupational hazards
d) Chemical hazards
OLTP stands for ________.
a) Online Transaction Procedure b) Offlane Transport Process
c) Offline Transaction Process d) Online Transaction Process
In URL, http://www.examin8.com/index.htm, which component identifies the path of a web
page?
a) www.arihant.com b) http c) /index.htm d) all of these
3. SECTION B (Employability Skills)
4. Describe the principle of completeness of effective communication.
5. Differentiate between Interests and Abilities (Strengths).
6. Explain the main features of Windows NT.
7. Why there is a need for innovativeness in entrepreneurship?
8. Explain social development.
9. SECTION B (Subject Specific Skills) Short Answers
10. What is the use of grouping objects in a word processor application?
11. What do you mean by relative referencing?
12. What do you mean by hyperlinks in spreadsheet? Give two different types of hyperlinks
that can be used in spreadsheets.
13. Write one example of each field, for which you would use
i. Text data type
ii. Memo data type
2. What is URL?
3. Why do we use instant messaging?
4. SECTION B (Subject Specific Skills) Long Answers
5. How can you define OLE?
6. Anita is preparing spreadsheet notes for her term exam. Help her to write short note on
the following:
i. Scenarios
ii. Goal Seek
iii. Solver
iv. Subtotal
7. Differentiate between DDL and DML Commands.
8. What is the use of the SELECT command in SQL?
9. What do you mean by Instant Messaging? Also explain one Instant Messaging software.
Class 10 - Information Technology (402)
Sample Paper - 04 (2023-24)
Solution
1. SECTION A: OBJECTIVE TYPE QUESTIONS
2. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)
1. (c) More dependency
Explanation: More dependency
2. (c) Never eat or drink around the computer
Explanation: Never eat or drink around the computer
3. (b) All of these
Explanation: All of these
4. (a) Face-to-face informal communication
Explanation: Face-to-face informal communication
5. (d) All of these
Explanation: All of these
3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (a) 10
Explanation: 10
2. (a) View → Toolbars → Picture
Explanation: View → Toolbars → Picture
3. (d) Style
Explanation: A style is a set of formats consisting of such things as fonts, colors,
font size, and paragraph formats.
4. (a) All of these
Explanation: All of these
5. (d) 8
Explanation: 8
6. (d) Video Style
Explanation: Video Style
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (b) Accept and reject changes
Explanation: Accept and reject changes
2. (c) Both Row and Column Label
Explanation: Both Row and Column Label
3. (b) blank spaces
Explanation: Page margins are the blank spaces between the worksheet data and
the edges of the printed page.
4. (c) (iii)
Explanation: Both double click on one of the existing sheet and right click on
existing sheet and then choose rename
5. (a) Edit >> Paste Special >> Transpose
Explanation: Edit >> Paste Special >> Transpose
6. (c) Scenario
Explanation: Scenario
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (a) Roll no
Explanation: Roll no
2. (b) Both of these
Explanation: Both of these
3. (c) Text
Explanation: Text that allows storing text or a combination of text and numbers.
4. (c) One student can have many classes
Explanation: One student can have many classes
5. (a) Yes/No
Explanation: Yes/No data type will alow boolean value.
6. (d) Relational database management system
Explanation: Relational database management system
6. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. (d) Peer-to-Peer Network
Explanation: Peer-to-Peer Network
2. (d) Both Local Area and Wide Area Network
Explanation: Both Local Area and Wide Area Network
3. (d) All of these
Explanation: All of these
4. (c) Occupational hazards
Explanation: Occupational hazards
5. (d) Online Transaction Process
Explanation: Online Transaction Process
6. (c) /index.htm
Explanation: /index.htm, because path name identifies the path of a web page.
7. SECTION B (Employability Skills)
8. The principle of completeness implies that the message must be complete, which means
that it should convey all the information required by the receiver. Nothing which may be
required by the receiver should be left out of the message.
9. The difference between interests and abilities is given below:
Interests Abilities
Things or activities that you like to do in your The capacity to perform a task is
free time that makes you happy. called ability.
Things or activities you are curious about or It enables you to perform a particular job or
would do even if no one asked you to do it. task with considerable proficiency.
Things or activities you want to learn or would
There will be no choice available.
like to do in the future.
10. Windows NT operating system was built for the server as it was more reliable, stable and
offered a large number of system features to the operating system, namely encryption,
file/ folder level security, auditing, etc.
11. There is a need for innovativeness in entrepreneurship because with the changing needs
and requirements of customers production should meet requirements.
12. Social development is about awareness of and legislation protection of the health of
people from pollution and other harmful activities of a business. Social development
deals with encouraging people to participate in environmental sustainability and teaching
them about the effects of environmental protection.
13. SECTION B (Subject Specific Skills) Short Answers
14. Grouping drawing objects makes it easier to handle several objects as a single entity,
while preserving their relative sizes and positions. When objects are grouped, any editing
operations carried out on that group are applied to all members of the group. If you click
on one member of the group, the whole group is selected.
15. Cell referencing in which the cells are referred by their relative position in the worksheet
relative to a particular cell is called relative referencing.
16. In spreadsheets, Hyperlinks can be used in Cale to jump to a different location from
within a spreadsheet and can leads the other parts of the current file, to different files.
Hyperlinks can be absolute and relative.
An absolute URL. contains all the information necessary to locate a resource.
A relative URL locates a resource using an absolute URL as a starting point.
17.
i. Text data type: It allows to store text or a combination of text and numbers as
well as numbers that don’t require calculations such as phone number. This data
type allows maximum 255 characters to store. e.g. If Employee is a table and
Emp_No, Name and Description are fields, then name will be a Text field.
Because, Name is a character entry field.
ii. Memo data type: It allows long blocks of text that uses text formatting, e.g. In
the Employee table, the field Description will be of Memo data type, because the
length of description of employee may be large.
2. URL means Uniform Resource Locator. It is a unique address of a web page on the
Internet. It specifies the Internet address of a file stored on a host computer connected to
the Internet.
3. Instant messaging is a set of communication technologies used for text based
communication between two or more participants over the Internet or other types of
networks. Many instant messaging services offer video calling features, voice over IP and
web conferencing services. Web conferencing services can integrate both video calling
and instant messaging abilities.
4. SECTION B (Subject Specific Skills) Long Answers
5. OLE (Object Linking and Embedding) is a component document technology from
Microsoft that allows you to dynamically link files and applications together. An object is
a combination of data and the application needed to modify that data. You can thus
embed objects in or link them to documents created with a different application.
For example, An excel spreadsheet can be embedded within a Microsoft: Word document
using OLE.
6.
i. Scenarios: Scenarios are a tool to test "What-if" questions. Each scenario is
named and can be edited and formatted separately. It is essentially a saved set of
values for calculations. We can easily switch between these sets using the
Navigator or a Drop-down list which can be shown beside the changing cells.
ii. Goal Seek: It is used to calculate a result based upon existing values. Using Goal
Seek option under Tools menu, we can discover what values will produce the
result that we want.
iii. Solver: It is an elaborated form of Goal seek. The difference is that the solver
deals with equations with multiple unknown variables. It is specifically designed
to minimize or maximize the result according to a set of rules defined by us.
iv. Subtotal: lt is a function listed under the Mathematical category when we use the
Function Wizard (Insert > Function). Because of its utility, the function has a
graphical interface.
SUBTOTAL, gets the total/adds the data arranged in array-that is, a group of cells
with labels for columns and /or rows. For increasing the efficiency, we can choose
up to three groups of arrays to which the function can be applied.
7.
DDL DML
It stands for Data Definition Language It stands for Data Manipulation Language
Example: Create, Alter, Drop Example: Insert, Update, Delete
8. DDL (Data Definition Language) and DML (Data Manipulation Language) are two types
of SQL commands. DDL commands are used to create and define the structure of a
database, including creating tables and changing their characteristics. DML commands
are used to manage the data within the database, including adding, retrieving, and
updating data.
DDL commands affect the entire table of the database, while DML commands only affect
one or more rows.
Some examples of DDL commands include: ALTER, DROP.
Some examples of DML commands include: UPDATE, SELECT.
DDL commands affect the entire table of the database, while DML commands only affect
one or more rows.
9. The SELECT command is used to retrieve zero or more records from one or more tables
of a database or a different database. It is the most commonly used DML
command. Following optional clauses can be used with the select command:
o WHERE Specifies which rows are to be retrieved
o ORDER BY specifies the order in which the rows are to be retrieved
10. Instant Messaging (IM), form of text based communication in which two persons
participate in a single conversation over their computers or mobile devices within an
Internet based chatroom. Various softwares provide instant messaging services as
Whatsapp, Google Talk, Skype, Meebo, eBuddy etc. Google Talk.
It is an instant messaging and VoIP service developed by Google. This client lets you to
log in to the service to chat and hold video-conferences with your friends from the
Windows desktop.
Google Talk is more than just a regular chat, you can also make free PC to PC VoIP calls
and even leave voice messages like an answering machine. If your contacts are also using
the Google Talk client, you can send files too.
Google Talk was integrated into gmail where users could send instant messages to other
gmail users. As it worked within a browser, the Google Talk client did not need to be
downloaded to send instant messages to gmail users.
