1. Which of the following is not used as secondary storage

Semiconductor memory

Magnetic disk

Magnetic drum

Magnetic tape

2. MICR system is used in which of the following field

Bank

Hotel

Hospital

House

3. The disadvantage of dynamic RAM over static RAM is

Higher power consumption

Variable speed

Need to refresh the capacitor charge every once in two milliseconds

Higher bit density

4. Which of the following codes needs 7 bits to represent a character

ASCII

BCD

EBCDIC

Gray

5. Which one of the following is not a client-server application

Internet chat

Web browsing

E-mail

Ping

6. The hexadecimal number A23F is represented in binary by

1010 0010 0011 1110

1010 0100 0011 1111

1010 0010 0011 1111

1111 0011 0010 1010

7. Error detection at the data link level is achieved by

Bit Stuffing

Hamming Codes

Cyclic Redundancy Codes

Equalization

8. Which of the following is single user operating system

MS-DOS

Unix

OS/2

None

9. Plasma Panel is

Input Device

Output Device

Memory Device

Communication Device

10. Baud means

The number of bits transmitted per unit time.

The number of bytes transmitted per unit time.

The rate at which the signal changes.

None of the above

11. www uses protocol

FTP

HTTP

WBC

MTP

12. Which of the following is an example of an optical disk

Digital Versatile Disk

Magnetic Disk

Memory Disk

Databus Disk

13. To access a mainframe or super computer, users often use

Terminal

Node

Desktop

Hand held

14. Which is the fastest memory

CD-ROM

RAM

Registers

Cache

15. A name or number used to identify a storage location is called

Byte

Carry bit

Record

Address

16. A acts like a translator between the device and programs that use the device.

Interpreter

Device driver

Compiler

None of these

17. A storage area used to store data to compensate for the difference in speed at which different units can handle data is

Memory

Accumulator

Buffer

Address

18. What is the name of the arrangements where several central processing units share one memory

Multitasking

Multiprogramming

Concurrent programming

Multiprocessing

19. A page fault occurs

when the page is in the memory.

when the page is not in the memory.

when the process enters the blocked state.

when the process is in the ready state.

20. A tree structured file directory system

is not essential when we have millions of files.

is a much debated unnecessary feature.

allows easy storage and retrieval of file names.

none of the above

21. What is shell

It is hardware component.

It is a part of compiler.

It is a tool in CPU scheduling.

It is a command interpreter.

22. Which of the following is most likely to use an embedded OS

Computerized life-support system

Macintosh computer

Desktop PC

None of the above

23. In a GUI, the window that is currently in use is called as

Top window

Active window

Framed window

None of the above

24. Multiprogramming is

writing two or more programs at a time.

using more than two programs to solve a problem.

processing of two or more programs at the same time.

None of the above

25. An assembler in computer is a

Program

Language

Hardware

Person

26. Unix and its software are written in highlevel language

C

PL/1

Ada

None of these

27. The operating system manages

Memory

Processor

Disk and I/O devices

All of the above

28. Cryptographic technique is used in

Pooling

Job scheduling

Protection

File management

29. Modulation is the process of

sending a file from one computer to another.

converting digital signal to analog signal.

converting analog signal to digital signal.

echoing every character that is received.

30. FDDI is a

Ring Network

Star Network

Mess Network

Bus Based Network

31. Junk E-mail is also called

Spam

Spoof

Sniffer script

Spool

32. Data transfer rate in modems is measured in

Bits per minute

Bits per second

Bandwidth

None of the above

33. Which of the following wired transmission media is the fastest

Twisted pair

Coaxial cable

Optical fiber

None of the above

34. When data is sent during set time periods, what do you call the transmission mode

Synchronous

Asynchronous

Protocol

None of the above

35. Which of the following networking solution is suitable for networking within a building

WAN

LAN

MAN

None of these

36. IRC stands for

Internet Real Time Communication

Internet Relay Chat

Internet Real-Time Chat

None of the above

37. Devices on one network can communicate with devices on another network via a

File Server

Utility Server

Printer Server

Gateway

38. CSMA/CD

is a protocol

is used in IEEE 802.3 (Ethernet)

both and

None of the above

39. With electronic mail you can do which of the following

send and read mail

delete, reply to, or forward

delete some one else's mail

both and

40. Which service is used on internet to exchange files

Telnet

Gopher

FTP

SP

41. Two commonly used web browser are internet explorer and

Netscape Network

Mozilla Firefox

Network Navigator

Internet Navigator

42. The first network that planted the seeds of Internet was

ARPANET

NSFNET

VNET

INET

43. The server on the Internet is also known as

Repeater

Gateway

Host

None of these

44. What does DNS stands for

Data Naming Service

Domain Name System

Data Numeric System

Decentralized Naming System

45. POP is referred to as

Primary Offline Protocol

Public Object Protocol

Post Office Protocol

None of the above

46. The language used in application programs to request data from DBMS is referred to as

DML

DDL

DCL

All of these

47. Which of the following is not an RDBMS

Oracle

Sybase

Microsoft Word

Ingres

48. The order of logical operations in SQL is

AND, OR, NOT

NOT, AND, OR

OR, NOT, AND

None of the above

49. A file consist of

databases and fields

fields and sorts

records and sorts

fields and records

50. The distinguishable parts of a record are called

Data

Files

Fields

All of these

51. An SQL command should be terminated with a









52. In relational schema, each tuple is divided into fields is called

Relations

Domains

Queries

All of these

53. The command used to compare the files is known as

du

comp

ccp

cmp

54. The column of a table is referred to as the

tuple

attribute

entity

degree

55. Multimedia elements are

Text and picture

Animation

Movie, video and sound

All of the above

56. TIFF stands for

Tagged Image File Format

Template Image File Format

Temporary Interchange File Format

None of the above

57. Which technique is used to blend two or more images to form a new image

Rendering

Wrapping

Morphing

Animating

58. A has length, width, tone and texture.

Point

Colour

Line

None of these

59. Periodically adding, changing and deleting file records is called file

Updating

Upgrading

Restructuring

None of these

60. Good quality video and higher resolution image is achieved through

Quick time

MPEG

AVI

None of these

61. A menu driven system

is required only for online system.

increases the operator's work.

can be used only by computer operator.

presents options and allows the user to make selections.

62. To select a window as active using mouse, simply click on portion of the window.

top

bottom

any

None of these

63. Which of the following shows icons for all servers and workstations in your network

Network Neighbourhood

My Document

Recycle Bin

None of the above

64. Whenever you view or manage files and folders, then you will use a program called

Internet Explorer

Windows Explorer

Recycle Bin

None of the above

65. Windows 98 was develop in

1994

1998

2001

2004

66. All the deleted file go to

Recycle Bin

Taskbar

Tool bar

My Computer

67. Windows is

Hardware

Modem

Input Device

Operating System

68. Which of the following is not an operating system

DOS

UNIX

LINUX

MS-Office

69. GUI stands for

Gnutella Universal Interface

Graphical User Interface

Graphic Universal Information

General Utility Interface

70. The Recycle Bin stores deleted items until

another user logs on

the computer is shut down

the end of the day

you empty it

71. Windows Me operating stands for

Windows My Edition

Windows 98

Windows Millennium Edition

None of the above

72. Which button can be used to switch the active window

Start

Documents

Task bar

None of these

73. The process of moving from one open window to another is called

Task switching

System call

Moving

None of these

74. Which is not an operating system task

Document Editing

Managing Memory

Allocating Processor

Loading Programs

75. Which is not a system software

DOS

Unix

Windows

MS-Office

76. Which of the following is not a GUI component

Radio button

Menu

Command

Text Box

77. A program in execution is called

Process

Instruction

Procedure

Function

78. The main reason to encrypt a file is to

Reduce its size

Secure it for transmission

Prepare it for backup

None of the above

79. Date and time are available on the desktop at

My Computer

Recycle Bin

Task bar

None of the above

80. A folder can contain

Files only

Files and Folders

Folders only

None of these

81. When a computer systems hardware communicates with input or output hardware, the operating system works through

Device Driver

Network

Processor

None of these

82. A network printer is a printer over a network shared by

only two people

two server

several people

None of the above

83. For accessing the networks we use the icon

Network Neighbourhood

Recycle bin

My Documents

None of the above

84. A DBMS file is a collection of

Logically related multiple records

Multiple related fields

Multiple related keys

None of these

85. Following are the file compression programs, except

WinRAR

PKZIP

RAID

WinZIP

86. A software is also called as a

Procedure

Data

Program

Information

87. Which of the following attribute prevents changes to files and folders

Read only

Hidden

Archive

System

88. is a windows utility for optimizing disk space.

Backup

Disk fragmentation

Disk format

Restore

89. Additional information about a program is displayed through box.

minimize

maximize

dialog

None of these

90. Windows is based on

Multitasking

Parallel Processing

Real Time

Batch Processing

91. Spelling and grammar can be detected by pressing key

Shift F7

Ctrl F7

F7

Alt F7

92. Which key underline the selected text

Ctrl W

Ctrl C

Ctrl Z

Ctrl U

93. Which of the following line spacing is invalid in MS-Word

Single

Triple

Multiple

Double

94. What is the shortcut key you can press to create a copyright symbol in MS-Word

Alt C

Ctrl C

Ctrl Shift C

Alt Ctrl C

95. Bullets and numbering is in

Insert Tab

View Tab

Home Tab

Page Layout Tab

96. You can use to copy selected text and to paste it in a document.

Ctrl Ctrl V

Ctrl Ctrl P

Ctrl Ctrl S

Shift Alt P

97. MS-Office was developed by

Novel

Coral

Lotus

Microsoft

98. The name a user assigns to a document is called a

File name

Program

Record

Data

99. By default, your documents are printed in which orientation

Landscape

Portrait

Rotate by 180 degree

None of these

100. What menu is selected to change Font and Style

File

Tools

Edit

Format

101. For creating a document, you use command at file menu.

Open

Close

New

Save

102. What menu is selected to save or save as

File

Format

Tools

Edit

103. Where does a header appear in a document

At the top of every page

At the bottom of every page

Only on the first page

Only on the last page

104. Which menu is selected to cut, copy and paste

File

Tools

Table

Edit

105. Which is the standard file format for text files

.jpg

.bmp

.txt

.xls

106. An arrangement of information in row and column is called as

Column

Table

Case

Row

107. How many types of alignment available in MS-Word

1

2

3

4

108. Ctrl Z is used

To Undo

To Delete

To Copy

None of these

109. The is a dictionary of synonyms which you can use to find words that are synonymous with a term.

Spelling

Research

Translate

Thesaurus

110. To create a form letter which you intend to print or e-mail multiple times, sending each copy to different recipient is called

Create label

Mail merge

Cross reference

None of the above

111. is a technique used to take out unwanted background areas.

Framing

Clipping

Cropping

None of these

112. The blinking point which shows your position in the text is called

Blinker

Cursor

Causer

Pointer

113. To save an existing file with new name at new location we should use command.

Save

Edit

Save and Replace

None of the above

114. What menu is selected to print

Tools

View

File

Edit

115. Which of the following is graphics solution for word processor

Clip art

Word pad

Drop cap

All of these

116. Any data that is typed in a worksheet appears

in both the active cell and the formula bar.

in the active cell only.

in the formula bar first and when you press Enter key into the active cell.

None of the above

117. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

G1 G10

B1. G10

B1 G10

B1 .. G10

118. What is entered by the function today

The date value for the day according to system clock.

The time value according to system clock.

Today date as text format

None of the above

119. Which one of the following is a pre-recorded formula for calculation as a shortcut in Excel

Value

Data Series

Field

Function

120. In MS-Excel every cell is referred by cell address which is

Cell column label

Cell column label and worksheet tab name

Cell row label

Cell column and row label

121. When you move your mouse over a sizing handle the pointer becomes a

Round arrow

Two headed arrow

Plus sign

Four headed arrow

122. Which of the following is an absolute cell address

A1

#a¹1





123. Workbook is a collection of in MS-Excel.

Books

Workbooks

Tabs

Sheets

124. A is a visual representation of data in MS-Excel.

Chart

Picture

Graphic

Table

125. In MS-Excel is a method tool which aids you in forecasting values.

Find

Replace

Goal seek

Go To

126. Which of the following functions of MS-Excel 2007 display the sum of the selected cells just after the selected cells

SUM

TOTAL

ADD

None of these

127. Which of the following command of Excel convert a column of data into row

Cut and Paste

Paste special ¾® Transpose

Orientation

None of the above

128. Which of the following function in Excel 2007 count the number of characters in a cell

Length

LGT

LT

LEN

129. The command Home ¾® Edit ¾® Fill Across worksheet of Excel 2007 is active only when

one sheet is selected.

when many sheets are selected.

when no sheet is selected.

None of the above

130. In MS-Excel list of only those entries which meet certain criteria, can be obtained by using menu

Data ¾® Sort

Data ¾® Filter

Format ¾® Sheet

None of the above

131. How do you save a presentation under a new file name

Select the file menu and choose save as

When you choose PowerPoint the file will automatically be saved

Select the file menu and choose save

None of the above

132. A character that is raised and smaller in size and placed above the baseline is known as

Outlined

Raised

Superscript

Subscript

133. Which of the following is a presentation graphics software

MS-Windows

MS-PowerPoint

MS-Excel

MS-Word

134. Which command brings you to the first slide in your presentation

Page Up

Shift Home

Alt Home

Ctrl Home

135. PowerPoint lets you add new slide to your presentation using

Insert-> Slide

Insert-> New Slide

Format New Slide

None of the above

136. To decrease the font size, the shortcut used is in presentation.

Ctrl Shift

Ctrl Shift

Ctrl

Ctrl

137. To personalize your AutoCorrect, use

Tools AutoCorrect

Insert AutoCorrect

Format AutoCorrect

None of the above

138. Ctrl H is used to

Invoke find dialog box

Invoke replace dialog box

Both and

None of the above

139. To add a chart to the slide use

Insert ->Chart

Tools Chart

File Chart

None of the above

140. Which of the following allows you to select more than one slide in a presentation

Alt Click each slide

Shift drag each slide

Shift click each slide

Ctrl click each slide

141. The properties of relational tables are

each row is unique

each column has a unique name

both and

None of the above

142. In MS-Access, the text data type may contain maximum characters of

255 characters

256 characters

1064 characters

No limit

143. In MS-Access size of Yes No field is always

1 bit

1 byte

1 character

1 GB

144. Which of the following database objects can you import from one Microsoft Access database to another

Queries

Tables

Forms

All of these

145. In a database table, the category of information is called

Tuple

Field

Record

All of these

146. Data can be imported into Access database from

Word Files

Excel Files

HTML Files

PowerPoint Files

147. Which of the field has width 8 bytes in MS-Access

Memo

Number

Date Time

Hyperlink

148. Which one is not the way to create reports in MS-Access

Design view

Data form

Report wizard

Label wizard

149. In table design view, which key can be used to switch between the field names and properties panels

F3

F4

F5

F6

150. Which of the following file type indicates the file is an MS-Access document

.msw

.wor

.accdb

.wrd


151. The largest glacier in Uttarakhand is

Sunder Dhunga

Milam

Kafni

Gangotri

152. Initiator of 'Dola Palke' movement in Uttarakhand is

Hemwati Nandan Bahuguna

Premlal Vaid

Bhakta Darshan

Jayanand Bharti

153. When 'Garhwal' word came in existence for 'Garhwal'

1815 A.D.

1515 A.D.

1820 A.D.

1279 A.D.

154. Maula Ram was a

Poet

Doctor

Social worker

Freedom fighter

155. Who was the founder Editor of the newspaper "Shakti" in Almora

Ram Singh Dhoni

Badri Datt Pandey

Prayag Joshi

Victor Mohan Joshi

156. 'Barahat' is the ancient name of

Srinagar

Uttarkashi

Rudraprayag

Joshimath

157. Raj Bhawan of Nainital was established in the year

1860

1875

1879

1890

158. Who is known as 'Kumaun Kesri'

Hargovind Pant

Pt. Badri Datt Pandey

Kalu Mahra

Mohan Singh Mehta

159. Which one of the following is not a 'Folk Dance' of Uttarakhand

Chaunphala

Jhumaila

Chholia

Giddha

160. In which year the "Kumaun" came under the Gorkha Rule

1790

1815

1810

1804

161. Maximum number of the sugarmills are present in which district of Uttarakhand

Dehradun

Haridwar

Udham Singh Nagar

None of the above

162. The total forest covered area in Uttarakhand is about

68.79%

64.79%

63.19%

59.29%

163. In which year Tehri estate was merged into Republic of India

1945

1947

1949

1951

164. Kalagarh Dam is constructed on

Ramganga river

Bhagirathi river

Sharda river

Yamuna river

165. Which place among the following is called as the 'Bardoli of Kumaun"

Nainital

Ranikhet

Salt

Almora

166. 'Milasara Tax' in Tehri estate was levied on

Irrigated land

Pastures

Reunion of divorced couples

Seasonal crops

167. The Kaundali festival of Chaundas is celebrated by

Shaukas

Tolchas

Jaads

Boxas

168. Who planted apple orchard in Harsil

S.G. Scott

Admond Hillari

Jim Corbett

Fredrick Wilson

169. Which tribe among the following of Uttarakhand worship 'Mahasu Devta'

Tharu

Jaunsari

Boxa

Raji

170. Match the following and mark the correct answer from the codes given below Glacier District
A. Pindari 1. Pithoragarh
B. Milam 2. Bageshwar
C. Gangotri 3. Bageshwar
D. Kafni 4. Uttarkashi

Codes
A B C D

1 2 3 4

2 1 4 3

4 3 2 1

2 1 3 4

171. On which date the inauguration of the session of Legislative Assembly of Uttarakhand for the first time took place at Gairsain

November 03, 2012

January 14, 2013

November 09, 2013

June 09, 2014

172. Which of the following is the governing body of Rural Panchayat System

Gram Sabha

Gram Panchayat

Block Panchayat

Zila Panchayat

173. The date of implementation of the special integrated industrial promotion policy for hilly and remote areas of Uttarakhand is

April 01, 2000

April 01, 2005

April 01, 2008

April 01, 2010

174. Which one among the following rivers of Uttarakhand is not a snow fed river

Tons

Bhilangna

Ramganga (West)

Goriganga

175. Match the following and select the correct answer from the codes given below

Glacier River
A. Satopanth 1. Alaknanda
B. Milam 2. Gori
C. Khatling 3. Bhilangna
D. Pindari 4. Pindar
Codes

A B C D

1 2 3 4

4 3 2 1

2 1 4 3

3 4 1 2

176. The famous 'Baghnath' temple in Uttarakhand is situated at

Gopeshwar

Bageshwar

Jageshwar

Someshwar

177. Meaning of 'Talaun Land' is

Stoney land

Barren land

Forest land

Irrigated land

178. 'Green Day' is celebrated in Uttarakhand on which day

3rd July

5th July

8th July

15th July

179. Name the district in Uttarakhand where 'Naini-Saini' aerodrome is being constructed.

Almora

Uttarkashi

Chamoli

Pithoragarh

180. Kalsi is famous for

Historical stone inscription

Religious centre

Battle ground

Tourist place

181. Name the place where IIM has been established in Uttarakhand.

Dehradun

Haldwani

Kashipur

Rudrapur

182. 'Mana Pass' is located between

Chamoli and Tibet

Chamoli and Uttarkashi

Chamoli and Pithoragarh

Pithoragarh and Champawat

183. When natural calamity took place in Kedarnath Valley

May, 2013

June, 2013

July, 2013

August, 2013

184. Which one among the following temples is located at the highest place of Uttarakhand

Badrinath

Kedarnath

Rudranath

Tungnath

185. Match the following and mark the correct answer from the codes given below

Person Specialization

A. Mrinal Pande 1. Social movement
B. Madhumita Bisht 2. Mountaineering
C. Chandraprabha Aitwal 3. Badminton
D. Gaura Devi 4. Journalism

Codes
A B C D

1 2 3 4

4 3 2 1

3 4 1 2

2 1 4 3

186. Total area of Tehri Dam (Swami Ramteerth Sagar) is

42 sq. km.

45 sq. km.

46 sq. km.

48 sq. km.

187. Match the following and select the correct answer from the codes given below

Pass Region
A. Lipulekh 1. Uttarkashi Tibet
B. Barahoti 2. Pithoragarh Tibet
C. Trail pass 3. Chamoli Pithoragarh
D. Thangla 4. Bageshwar Pithoragarh

Codes
A B C D

1 2 3 4

2 3 4 1

3 2 1 4

2 3 1 4

188. Who is known as the initiator of 'Save Seed Movement'

Vandana Shiva

Sarpal Singh

Shamsher Singh Bisht

Vijai Jaddhari

189. Which Prayag is not correctly matched

Devprayag Alaknanda Bhagirathi

Nandprayag Alaknanda Nandakini

Rudraprayag Alaknanda Mandakini

Vishnuprayag Gauriganga Dhauliganga

190. How many district of Uttarakhand touch the International Borders

Two

Four

Six

Five

191. Who is known as 'Garh Kesri' in Uttarakhand

Ansuya Prasad Bahuguna

Bhakta Darshan

Mukundi Lal

Keshar Singh Rawat

192. What is the present name of Govisan

Khatima

Kashipur

Rudrapur

Champawat

193. What is Dhakar

Tax

Tradition

Foodgrains transportation

Name of the place

194. Match the peaks with place and select the correct answer from the codes given below

Peaks Place
A. Bandar Poonch 1. Chamoli
B. Panchchuli 2. Uttarkashi
C. Nanda Devi 3. Bageshwar
D. Nanda Kot 4. Pithoragarh

Codes
A B C D

1 2 3 4

4 3 2 1

3 2 4 1

1 4 3 2

195. In which place "Dr. Pitamber Dutt Barthwal Hindi Academy" has been established

Haridwar

Nainital

Dehradun

Rishikesh

196. In which year the population and health policy of Uttarakhand was announced

2001

2002

2003

2004

197. Who participated in the 'Dandi March'

M.M. Kandpal

Jyoti Ram Kandpal

Ansuya Prasad Bahuguna

Badri Datt Pandey

198. In which place a training school was opened for the Satyagrahis in 1940

Ranikhet (Almora)

Nainital

Salt (Almora)

Gan Nath (Almora)

199. Rajaji National Park of Uttarakhand is spread in how many districts

1

2

3

5

200. Based on the census data of 2011, match the following and mark the correct answer from the codes given below

District Sex Rate Per 1000
A. Haridwar 1. 935
B. Nainital 2. 879
C. Pauri Garhwal 3. 902
D. Dehradun 4. 1102
Codes
A B C D

1 2 3 4

2 1 4 3

1 3 4 2

4 2 3 1