Information Technology (402)

Sample Question Paper

Max. Time: 2 Hours Max. Marks: 50

General Instructions:

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.
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 (4 x 1 = 4
marks)

i. Which force is within you that drives you to do things? 1

a. Self-awareness
b. Self-regulation
c. Self-motivation
d. Self-control

ii. Which of the following is not an example of multi-tasking operating system? 1

a. Linux b. Apple Mac

c. Windows d. DOS

iii. ________can be defined as a reaction to any external stimuli that triggers 1

changes in one’s personality.

a. Stress
b. Stressors
c. Stress management
d. Self- reliant

iv Which of the following is not a main function of an entrepreneur? 1

a. Decision making
b. Innovation
c. High Risk takers
d. Division of income
1
 v. “Well Done!” “Great Job” are which type of feedback? 1

a. Specific Feedback
b. Non-Specific Feedback
c. Descriptive Feedback
d. Effective Feedback

vi. Name any two factors that are main cause of ecological imbalance. 1

i.__________________ ii._______________

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

i. To create figure and shapes in a document _________ feature of word 1

processor is used.

a. Image b. Clip Art c. Drawing object d. Word Art

ii. Header & Footer option is available under _____ menu. 1

a. Edit b. View c. Insert d. Layout

iii. Area where cut and copy object is stored is called_________. 1

a. Work area
b. Document
c. Clipboard
d. Menu

iv. ______ are used in a document for applying a set of formatting effects on a 1
group of selected objects in one click.

a. Frame b. Smart Art c. Template d. Style

v. A ______ is a group of cells that run from the top to the bottom that is 1
collection of cells in vertical manner.

a. Row b. Column c. Cells d. Table

vi. Karan wants to make a professional resume. He tried many times but the 1
end result was not satisfactory as he was not knowing what all points should
be there and in which
order too. Which one of the following options in Writer would you suggest
him, so that his problem is solved?

a. Frame b. Theme c. Template d. Style

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

2
 i. The _________ tool of Electronic Spreadsheet allows you to repeat the set 1
of commands or tasks performed by user in a single click.

a. Scenario B. Macro c. Consolidate d. Templates

ii. Mohit wants to protect his worksheet, which one is the correct option from 1
the following:

a. Data > Protect sheet b. Review > Protect sheet

c. View > Protect sheet d. Insert > Protect sheet

iii. Scenarios are tool to test ____________ questions. 1

a. Data b. if-else c. what-if d. what-else

iv. It is specifically designed to minimise or maximize the result according to a 1

set of rules that you defined.

a. Solver b. Scenario c. Goal-seek d. Subtotal

v. An argument can be passed through a macro function_______. 1

a. By Value b. By Reference c. By sheet d. Both a and b

vi. _______ means that the query uses criteria you provide to hide some data 1
and display only required data.

a. Filtering b. Sorting c. Report d. Forms

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

i. ________ is a set of related information that belongs to a particular object. 1

a. Tuple b. Fields c. Column d. Attributes

ii. A ____________ refers to an association or connection between two or 1

more tables.

a. Grouping b. Relationship c. Sorting d. Filtering

iii. Which of the following is not a part of database management system? 1

a. Queries b. Forms c. Subtotal d. Report

iv. Tarun is database administrator he wants to take his database information 1

in effective, organised and summarise way. Which option he can choose in
OO base for this task?

a. Consolidation b. Query c. Forms d. Report

3
 v. Which of the following is not a correct command of DML? 1

a. Select b. Insert c. Delete d. Drop

vi. It consists of one or more fields whose value matches with a primary key in 1
another table. It act as cross reference between the tables.

a. Primary key b. Foreign key

c. Composite key d. Candidate key

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

i. This feature is useful for those who face difficulty in pressing more than one 1
key at a time.

a. Function b. Filter c. Toggle d. Sticky

ii. Sending large amounts of junk e‐mails is known as _____________. 1

a. Spamming b. Mail merge c. Phishing d. Spoofing

iii. ______ are similar to an online personal diary and simple to use. 1

a. Website b. Blog c. Podcast d. Instant message

iv. HTTP’s and Wi-Fi stands for ____________________. 1

v. What is true about an emergency action plan? 1

a. A standard plan
b. Customised as per workplace present hazards
c. Fixed plan for every floor
d. None of these

vi. Give any two examples of Instant Messaging services? 1

i. __________________________ ii. ___________________

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6

marks) Answer each question in 20 – 30 words.
Q. 6 Write down 7C’s of communication and their importance? 2

Q. 7 Explain any two factors which enhances one’s ability to work independently? 2

4
 Q. 8 Define firewall and cookies? 2

Q. 9 How entrepreneurship gives positive impacts on the society? Explain. 2

Q.10 Explain sustainable development concepts significances and their principals. 2

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

Q.11 Can you edit the labels in writer? If yes, write the steps to perform the task. 2

Q.12 What do you mean by Table of Content (TOC) and its significance in 2
document?

Q.13 Explain computer network and their different types. 2

Q.14 What is basic difference between absolute and relative hyperlinks. 2

Q.15 Explain ‘Goal-Seek’ and ‘Solver’ purpose in CalC. 2

Q.16 List any four features of instant messaging services? 2

Answer any 3 out of the given 5 questions in 50– 80 words each (3 x 4 = 12 marks)
Q.17 Define any two computer components and write down the difference between 4
Peer to Peer and Client Server networks?

Q.18 Explain the use of Scenario and ‘Change’ features in spreadsheet with the 4
examples.

Q.19 Nimisha wants to create a template as a custom template in writer. What steps 3+1
she follows to perform this task? And she wants to know about what is text
wrapping in writer.

Q.20 Ritika is not so much aware about database concepts. Explain following 4
concepts to her:
i. Difference between Primary key and Foreign key
ii. Record, field and Query in database

Q.21 Consider the following Table Book: 4

B_ID Book_Name Code Price
B101 IP 065 560
B102 IT 402 480
B103 AI 417 520
B104 C++ 083 650
B105 C 075 580

1. How can you insert data in this table through Form. Write down steps
2. Write down SQL query to display all records from Table book.
3. Display all records in ascending order according Price of Book.
4. How can you create Report of Book table in dBase? Write down all
steps.