Series ARSP/09 Set ~ 9

Roll No. Q.P Code 15/9/9

Candidates must write the Q.P Code
on the title page of the answer-book.

 Please check that this question paper contains 05 printed pages.

 Q.P. Code given on the right hand side of the question paper should be written
on the title page of the answer-book by the candidate.
 Please check that this question paper contains 21 questions.
 Please write down the serial number of the question in the answer-book
before attempting it.
 15 Minute times has been allotted to read this question paper. The question
paper will be distributed at 10:15 a.m. From 10.15 a.m to 10.30 a.m, the students
will read the question paper only and will not write any answer on the answer –
book during this period.

INFORMATION TECHNOLOGY

Time allowed: 2 hours Maximum 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):

1. This section has 05 questions.

2. Marks allotted are mentioned against each question/part.

3. There is no negative marking.

4. Do as per the instructions given.

7. SECTION B - SUBJECTIVE TYPE QUESTIONS (26 MARKS):

1. This section has 16 questions.

2. A candidate has to do 10 questions.

3. Do as per the instructions given.

4. Marks allotted are mentioned against each question/part.

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) [4]
(a) Which of the following technique provide you with the strength to do your daily work efficiently? [1]

a) Holiday with family or friends b) Completing work on time

c) Sleep d) Healthy Diet

(b) What is the full form of CUI? [1]

a) Create User Interface b) Common User Interface

c) Clever User Interface d) Character User Interface

(c) Entrepreneurship is a good option as: [1]

a) Doing charity b) Leading an easy life

c) Making quick money d) A career choice

 (d) Which barrier does occur due to some inherent traits or the frame of mind of the communicator? [1]

a) Cultural b) External

c) Internal d) Emotional
(e) Which of the following are the long-term solutions for SDG [1]
a. Launching of awareness and responsibility campaign for different grades of people
b. Protection of ecology by imposing high taxes and fines
c. More emphasis should be on sustainable development agriculture
d. All of these

a) Option (c) b) Option (b)

c) Option (a) d) Option (d)

2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) Which of the following is correct to open Picture toolbar? [1]

a) Insert → Tools → Picture b) View → Toolbars → Picture

c) Insert → Toolbars → Picture d) View → Tools → Picture

(b) Which of the following Graphic filter is used to increase the contrast of an image in a document? [1]

a) Smooth b) Remove Noise

c) Invert d) Sharpen
(c) We can underline the text by ________. [1]

a) Ctrl + Y b) Ctrl + I

c) Ctrl + B d) Ctrl + U
(d) Ananya wants that her company's logo should automatically appear on the top of the Writer document [1]
whenever she opens a new document. Which feature of Writer will help her to do so?

a) All of these b) Style

c) Automatic d) Template
(e) Which of the following setting is not used for positioning of graphic? [1]

a) Alignment b) Caption

c) Arrange d) Wrap
(f) Which option is used to undo the task? [1]

a) Ctrl + Y b) Both Ctrl + Z and Alt + Backspace

c) Ctrl + Z d) Alt + Backspace

3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) Which function cannot be performed through Subtotal in a Spreadsheet? [1]

a) Sum b) Percentage

c) Product d) Average
(b) If you begin typing an entry into a cell and then realize that you don't want your entry placed into a [1]
cell, you:
 a) Press the Edit Formula button b) Press Esc

c) Press the Enter button d) Press the Erase key

(c) We can shift from one scenario to another by [1]

a) Find and Replace b) Data Source

c) Navigator d) Transfer
(d) To access Freeze Panes, you will click the [1]

a) Format tab b) Insert tab

c) View tab d) Window tab

(e) The Paste Special command Lets you copy and paste: [1]

a) formatting options b) multiply the selection by a copied vlaue

c) the resulting values of a formula instead d) cell comments

of the actual formula
(f) To view a cell comment: [1]

a) click the edit comment command on the b) click the comment command on the
insert menu view menu

c) click the display comment command on d) position the mouse pointer over the cell
the window menu
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) Which of the following is not a component of the database? [1]

a) Software b) User

c) Hardware d) Memory
(b) Data in RDBMS is organized in ________. [1]

a) files b) text related only

c) linked through network d) tables

(c) The complete information about an entity in a database is called: [1]

a) Data b) Information

c) Field d) Record
(d) Which command is used to modify data in table? [1]

a) select b) delete

c) update d) modify
(e) Which of the following is suitable to act as a primary key in table student? [1]

a) Roll no b) Name

c) Class d) Section
(f) Which of the following is not the main building block of a database? [1]

a) Reports b) Lists
 c) Forms d) Queries
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(a) Which of the following is the social and civic responsibility of every human being? [1]

a) Computer skills b) Handling electrical equipment

c) Injuries d) First Aid

(b) What type of password can help reduce the risk of a security breach? [1]

a) Small b) Weak

c) Strong d) Week
(c) ISP stands for ________. [1]

a) Internet Social Provider b) Internet Sharing Provider

c) All of these d) Internet Services Provider

(d) What could a firewall be? [1]

a) Hardware b) Both Hardware and Software

c) Programming language d) Software

(e) ________ provides wireless communication and mobile broadband connection across cities and [1]
countries.

a) DSL b) WiMax

c) Fiber d) Wi-Fi
(f) ________ helps to share hardware components such as printers, scanners etc. [1]

a) Hardware Network b) Computer Network

c) Information Network d) Social Network

SECTION B (Employability Skills)
Attempt any 3 questions
6. Enlist seven elements of the communication cycle. [2]
7. Why is stress called a silent killer? [2]
8. Define word wrap. [2]
9. What are the functions of entrepreneur? [2]
10. Why do you think the United Nations has made the 17 Sustainable Development Goals? [2]
SECTION B (Subject Specific Skills) Short Answers
Attempt any 4 questions
11. Write the steps to insert date/time into Header or Footer. [2]
12. What do you mean by Page Break? [2]
13. Write down the significance of electronic spreadsheets. [2]
14. Write any four numeric data types in DBMS. [2]
15. Give the names of models of computer networking. [2]
16. Difference between circuit switching and packet switching. [2]
SECTION B (Subject Specific Skills) Long Answers
Attempt any 3 questions
17. What is OLE? How do you link or embed an object? [4]
18. How can an original and edited worksheet be compared? [4]
19. Define the following terms. [4]
i. Insert Command
ii. Select Command
iii. Delete Command
iv. DCL Command
v. Template
20. Explain any four data types of DBMS. [4]
21. How can anyone book the ticket online? [4]