PRACTICE PAPER

Class X
Information Technology (402)
Max. 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) Marks allotted are mentioned against each question/part.
(iv) Do as per the instructions given.

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills: (1 × 4 = 4 Marks)
(i) A response to the received message is called ........................... . (1)
(a) Result (b) Answer
(c) Feedback (d) Conversation
(ii) ........................... are small bits of data stored as text files on your computer by the websites you
visit. (1)
(a) Firewalls (b) Temporary files
(c) Cookies (d) Virus
(iii) Which of the following is a role of green skills? (1)
(a) Rainwater harvesting (b) Conserving Energy
(c) Reducing pollution (d) All of these
(iv) Enterprises where you get ready set-up and facilities like training, support, branding, etc., are called
........................... . (1)
(v) How we deal with adversities and hardships develops our ........................... . (1)
(a) Confidence (b) Belief
(c) Agility (d) Motivation
(vi) OS that runs on smart phones is ........................... . (1)

2. Answer any 5 out of the given 6 questions on Subject-specific Skills: (1 × 5 = 5 Marks)

(i) Applying a set of values on a dataset to analyse the changes in calculations and results is achieved by
........................... . (1)
(a) Consolidation (b) Analysis
(c) Subtotals (d) Scenarios
 (ii) ........................... are for helping visually impaired people. (1)
(a) Sticky Keys (b) Toggle Keys
(c) Filter Keys (d) Navigation Keys
(iii) Which of the following client computers rely on the server for data processing? (1)
(a) Smart Client (b) Dumb Client
(c) Virtual Client (d) Remote Client
(iv) Which of the following is referred to as ‘records’ in a database table? (1)
(a) Columns (b) Fields
(c) Rows (d) None of these
(v) Which of the following is a saved sequence of commands stored for later use? (1)
(a) Solver (b) Auto sum
(c) Consolidate (d) Macro
(vi) Greyscale is an example of which of the following? (1)
(a) Image Filter (b) Image Mode
(c) Image Transparency (d) None of these

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

(i) DELETE command in SQL is used to ........................... . (1)
(a) Delete the entire table
(b) Delete the database
(c) Delete rows based on conditions
(d) Delete all the rows of the table
(ii) An embedded image is a linked image whose link option is removed. (True/False) (1)
(iii) In the formula book1:A2*book3:A4+D4, cell D4 belongs to (1)
(a) Different workbook (b) Different worksheet
(c) Current sheet (d) Current workbook
(iv) A set of rules that provide correct and consistent data in DBMS are ........................... .(1)
(v) Which of the following is a DML command? (1)
(a) SELECT (B) CREATE
(c) DROP (d) ALTER
(vi) A block of text inside a paragraph is affected by ........................... Styles. (1)

4. Answer any 5 out of the given 6 questions: (1 × 5 = 5 Marks)

(i) DROP command is a DML query. (True/False) (1)
(ii) The object that floats over the text and hides the text is ........................... .(1)
(iii) Shortcut key for cut is ........................... . (1)
(a) CTRL X (b) CTRL T
(c) CTRL C (d) None of these
(iv) ........................... is an internet device that is used to convert digital to analog signals and vice
versa. (1)
(a) Web Browser (b) Router
(c) Repeater (d) Modem
(v) Graphics styles can be applied using ........................... Styles. (1)
(a) List (b) Frame
(c) Paragraph (d) Page

P.2 Essentials of Information Technology–X

 (vi) A message that incorporates regard and respect for others is ........................... . (1)
(a) Clear (b) Concrete
(c) Courteous (d) Concise
5. Answer any 5 out of the given 6 questions: (1 × 5 = 5 Marks)
(i) What is the primary function of electronic spreadsheet? (1)
(a) Word Processing
(b) Data Visualisation
(c) Data analysis and manipulation
(d) Data Training
(ii) For devices that are cities apart, which of the following is best suited? (1)
(a) LAN (b) WAN
(c) PAN (d) MAN
(iii) In a spreadsheet, what does a hyperlink allow you to do? (1)
(a) Change font colour of a cell
(b) Navigate to another cell in the same worksheet
(c) Create a connection to a website or external file
(d) Apply filter
(iv) Arithmetic operation =Average(3,5) results in ........................... . (1)
(v) The most suitable medium for an instant but formal message is ........................... . (1)
(vi) File extension for OpenOffice Writer is........................... . (1)
(a) .oot (b) .odt
(c) .ods (d) .docx

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions in 20-30 words. (2 × 3 = 6 Marks)
6. Define any two Communication Barriers. (2)
7. How does Gender Equality help in overcoming the challenges in Sustainable Development? (2)
8. Define types of Stress. (2)
9. “Success is quick if we start with a small enterprise.” Do you agree with the statement? Justify your
answer. (2)
10. Describe the following: (2)
(a) Spyware
(b) Boot Sector Virus

Answer any 4 out of the given 6 questions in 20-30 words. (2 × 4 = 8 Marks)

11. Define the following: (2)
(a) Primary Key
(b) Foreign Key
12. Mention any two preventive steps for online frauds. (2)
13. Define resizing and cropping of an image. (2)
14. How can data redundancy be controlled through DBMS? (2)
15. List any 4 types of Styles. (2)
16. Explain Macros with an example. (2)

Practice Question Paper P.3

Answer any 3 out of the given 5 questions in 50-80 words: (4 × 3 = 12 Marks)
17. Explain the advantages of networking. What limitations of LAN are overcome by WAN? (4)
18. Write a short note on the following: (4)
(i) Write any one advantage of DBMS.
(ii) Differentiate between Tuple and Attribute of a relation.
(iii) What is the default date format in SQL?
(iv) Define Cardinality of a relation.
19. Describe a scenario where Solver is the best choice to apply. (4)
20. Keshav is making a list of students who have some impairment or disability due to which they are not able to
use the computer. Identify which accessibility option will allow them to use the computer regardless of their
disability.(4)
Ambuj: Suffering from hand tremor

Shikhar: Auditory impairment

Simran: Difficulty in using mouse

Ramesh: Difficulty in using both mouse and keyboard

21. Define the following: (4)
(i) Flat File Database
(ii) Relational Database
(iii) DDL
(iv) Composite Primary Key

P.4 Essentials of Information Technology–X