Sardar Patel University Mandi JOA IT Question Paper

spu mandi joa it answer key

Sardar Patel University Mandi JOA IT Exam held on 20 October 2022 Question Paper with answers

 

Question No.1 ………is a
simple CRM and Marketing Tools Built for Small to midsize business. 

 (A)  Netsuite    

 (B)  Hubspot

 (C)  Hatchbuck (Correct Answer)            

 (D)  Leads          

 

Question No.2  ………is a set of web development techniques
used in ecommerce sites to create          

asynchronous web
applications request.                            

(A)  AJAX (Correct Answer)        

 (B) CDN

(C)  VPN              

 (D) HTML

 

Question No.3 ……… How
many bits make one Nibble?

 (A) 8 bit

(B)  4 bit (Correct Answer)

(C) 1024 bit

(D) 0 or 1 bit

 

Question No.4 ………What does BCC denote in emails?

 (A) Blind Communication Copy

(B)  Blind Common Copy

 (C) Blind Complete Copy

 (D) Blind Carbon Copy (Correct Answer)


Question No.5 ………Which of the following is an e-mail service provider?

 (A) Chrome

 (B) Yahoo (Correct Answer)

(C)  FireFox

 (D) Internet Explorer

 

Question No.6 ………The allows scheduling business meetings, calculating the budget and billing     

the suppliers.   

               

(A) SRM (Correct Answer)          

 (B) Database    

 (C)  MIS              

 (D) HRM             

 

Question No.7 ………is also called baseband video or RCA video.

(A)  Composite video (Correct Answer)

(B)  Readonly video

(C)  Sequential Video

(D)  Raw Video

 

Question No.8 ………In 1971, Alan Shugart led a team of IBM engineers who invented   .

 (A)  VRAM

 (B)  Floppy disk (Correct Answer)

(C)  Hard disk drive

 (D) Tape drive


Question No.9 ………Which feature in MS Word allows a person to do proofing of a document and mark suggested
editing and deletions?

 (A) Validation

 (B) Track Changes (Correct Answer)

 (C) Compare

 (D) Proofing (Chosen option)

 

Question No.10  ………is the center of your internet network that serves as the point of contact for all your connected devices.

 (A) Cable

 (B) Router (Correct Answer)

 (C) Node

 (D) Modem

 

Question No.11  ……… chart type in MS Excel is useful when you want to find optimum combinations between two sets of data.

 (A) Surface chart (Correct Answer)

 (B) Bar chart

 (C) Stock Chart

 (D) Line chart

 

Question No.12                ………How many types of document views are available in MS Word?

 (A) 6 Layout

(B) 3 Layout

(C) 5 Layout (Correct Answer)

(D) 4 Layout

 

Question No.13 ………A is a single point in a graphic image.

 (A) Digit

 (B) Cell

 (C) Bit

 (D) Pixel (Correct Answer)

 

Question No.14 ………What is the full form of ‘MAN’ in networking?

 (A) Main Area Network

 (B) Multimedia Area Network

 (C) Mini Area Network

 (D) Metropolitan Area Network (Correct Answer)

 

Question No.15 ………Which of the following is an example for application software?

 (A) Unix

 (B) Windows XP

 (C) MS Office (Correct Answer)

 (D Windows Vista

 

Question No.16  ………A disk’s content that cannot be electronically modified after the manufacture of the memory device is called
a disk.

 (A) Write only

 (B) Memory only

 (C) Read only (Correct Answer)

 (D) Run only

 

Question No.17  ………command is used to set page orientation, width, height, number of slides in the MS Powerpoint presentation.

 (A) Pack and Go

 (B) Page Setup (Correct Answer)

(C) Save as Web page

 (D) Print

 

Question No.18 ………If all devices are connected to a central hub, then the topology is called  .

 (A) Star Topology (Correct Answer)

 (B) Tree Topology

 (C) Ring Topology

 (D) Bus Topology

 

Question No.19 ………The process of conversion of analogue audio signals into digital audio is termed as

 (A) Sampling (Correct Answer)

 (B) Fidelity

 (C) Digitalization

 (D) Versatile

 

Question No.20 ………. is used when two organizations replace paper in transactions with electronic connections and transmission of data.

 (A) EDI (Correct Answer)

 (B) Database

 (C) Mailmerge

 (D) Virtual network

 

Question No.21 ……… is a proprietary journaling file system developed by Microsoft.

(A) NTFS (Correct Answer)

(B) UTF

(C) HFS

(D) ACLS

 

Question No.22                ………Which key allows you to invoke paste special dialog box in MS Applications?

 (A) Ctrl+Alt+P

 (B) Ctrl+Alt+V (Correct Answer)

(C) Ctrl+Alt+S

(D) Ctrl+Alt+C

 

Question No.23 ……… Which is the shortcut key to copy any text in a notepad?

 (A) Ctrl+Q Ctrl+Q

(B)  Ctrl+R Ctrl+R

(C)  Ctrl+C (Correct Answer)

 (D) Ctrl+S Ctrl+S

 

Question No.24 ………What is the shortcut key for warm booting?

 (A) Ctrl+F2+Del

 (B) Ctrl+UpwardArrow+Del

(C) Ctrl+Alt+Del (Correct Answer)

 (D) Ctrl+Shift+Del

 

 

 Question No.25 ………The file extension of MS PowerPoint presentation is       .

 (A) .pow

 (B .jpg

 (C .pxt

 (D .ppt (Correct Answer)

 

 Question No.26 ………In MS Word, is used to track all the changes made to the document.

 (A) Tracking (Correct Answer)

 (B) Compare

 (C) Proofing

 (D) Protect

 

 Question No.27 ………The attribute specifies the URL of the page to which the contents of the form are submitted.

 (A)  validate

 (B) post

 (C) action (Correct Answer)

 (D) method

 

Question No.28 ………In MS Word, which of the following menus is used to add Headings that are displayed automatically in the top margin of all the pages?

 (A) Format Menu

 (B) View Menu

 (C) Tools Menu

 (D) Insert Menu (Correct Answer)

 

Question No.29 ………Each hexadecimal symbol is an encoding for how many digit binary number?

 (A)  4-digit binary number (Correct Answer)

(B)  8-digit binary number

(C) 16-digit binary number

(D) 2-digit binary number

 

Question No.30  ………What is SRAM?

 (A)  Secondary RAM

 (B) Synchronous RAM

 (C) Static RAM (Correct Answer)

 (D) Selective RAM

 

Question No.31 ……… feature
in MS Word allows you to create a variety of documents that can be personalized
for each person receiving it.

 (A) Send as Email
option

 (B) Mail merge (Correct Answer)

(C) Sync mail

 (D) File->Share
with people

 

Question No.32 ……… enables MS Excel to dynamically produce new outputs when one or more inputs in the referenced cells are changed.

 (A) Cell References (Correct Answer)

 (B )Pastespecial  

(C)  Queries

 (D) Wordwrap

 

Question No.33 ………gathers data from multiple online systems, analyzes the information and reports data to aid in management decision making

(A) DSS

(B) ERP

(C) MIS (Correct Answer)

(D) EIS

 

Question No.34  ………The component that contains the pin which prints a dot in an impact printer is called

 (A) Ink spray

 (B) sprockets

 (C) Print head (Correct Answer)

 (D) Print ribbon

 

Question No.35 ……….In MS Word,         is used as reference points for cross references, index and macros.

 (A) Citation

 (B) Bookmark (Correct Answer)

 (C)Caption

 (D) Hyperlink

 

Question No.36 ………In MS Powerpoint, s the place where we design the slide by typing, formatting.

  (A) Slide Pane (Correct Answer)

 (B) Task pane

 (C)  Notes Pane

 (D) Slide Sorter Pane

Question No.37  ………In MS Excel, chart is used to show a percent of total for a data set at a specific point in time.

 (A) Pie (Correct Answer)

 (B) Legend

 (C) Bar

 (D) Line

 

Question No.38  ………Which feature of MS Excel will help you to automate data entered in a defined sequence?

 (A) ALIGNMENT

 (B) EDITING

 (C ) AUTO FILL (Correct Answer)

 (D) STYLES

 

Question No.39  ………What is the shortcut key to center align text in MS Word?

 (A) Ctrl+P

(B) Ctrl+R

(C) Ctrl+C

(D) Ctrl+E (Correct Answer)

 

Question No.40  ………High level languages were introduced in which generation of computers?

 (A) Second

 (B) Fourth

 (C) First

 (D) Third (Correct Answer)

 

Question No.41 ……… What is the base for binary number system?

 (A) Four

 (B) Seven

 (C) Two (Correct Answer)

 (D) One

 

Question No.42  ………Which option in MS Word enables the user to send the same letter to different recipients?

 (A) Indent

 (B) Template

 (C) Macros

 (D) Mail merge (Correct Answer)

 

Question No.43 ………In MS Word, which section of document appears in the top margin?

 (A) Footer

 (B) Foot area

 (C) Header (Correct Answer) (Chosen option)

 (D) Head area

 

Question No.44 ………What does DSS stand for?

 (A) Decision Support System (Correct Answer)

 (B) Data Storage Server

 (C)Data Systems Support

 (D)Domain Sap Service

 

 

Question No.45 ………The first operating system used for read work by General Motors Research division was

(A) GM-NAA I/O (Correct Answer)

(B) GM-WIN32

(C) GM-OS

(D ) GM-8088

 

Question No.46  ………was the first personal computer with a graphical user interface.

 (A) Apple’s LISA (Correct Answer)

 (B) IBM Image

 (C) Microsoft DOS

 (D) AT&T GUI

 

Question No.47 ………Which among the following is the first computer with a single-circuit board?

 (A) APPLE I (Correct Answer)

 (B) INTEL 1103

 (C) BASIC

 (D) IBM 1500

 

Question No.48 ………is a framework that brings structure to security and can be used to demonstrate a baseline level of security especially for ecommerce websites.

  (A) AJAX

  (B) ISMS (Correct Answer)

 (C)  RCP

 (D)  SOAP

 

Question No.49 Which feature of MS Powerpoint is used to publish a presentation into an eLearning file?

(A)  Review Template

(B)  Transition Template

 (C) Articulate Template (Correct Answer)

 (D) Animation Template

 

Question No.50  ………A collection of related web pages is known as       .

 (A) html

(B) webinar

 (C) web browser

 (D) website (Correct Answer)

 

Question No.51 ………Which of the following attributes on the < video > tag is used to specify an image to be displayed while the video is downloading?

(A) icon

(B) poster (Correct Answer)

(C) splash

(D) altimage

 

Question No.52 ………The Rows are labelled as in MS Excel Spreadsheets.

(A) I, II, III, ….

(B)1, 2, 3,…. (Correct Answer)

(C) A1, B1, C1,…

(D) A, B, C,…

 

Question No.53 ………In MS Powerpoint, the ‘Compare’ option is available in which menu?

(A)Format

(B  Review (Correct Answer)

 (C)File

 (D)View

 

Question No.54 ………are computer virus programs that will start or stop functioning after a predetermined date or time is
reached.

 (A)Time bombs (Correct Answer)

(B)Worms

 (C)Boot-sector viruses

 (D)Macro viruses

 

Question No.55  ………In MS Excel, which feature helps us to color the marks as red and green for fail and pass respectively?

 (A) format() function

 (B) if() function

(C)Conditional Formatting (Correct Answer)

 (D)Format cells

 

Question No.56 ………DHCP stands for

(A) Dynamic Host Configuration Protocol (Correct Answer)

 (B) Digital Host Connect protocol

 (C)Dynamic Hypertext configuration protocol

 (D)Dynamic Host Connect Protocol

 

Question No.57 ………In MS Word, if you are working with a file and want to open the last autosaved draft you need to
enable .

 (A) File->Info->Manage Versions (Correct Answer)

 (B)File->Save->Manage Versions

 (C)File->Version->Manage Versions

 (D)File->Info->Recovery

 

Question No.58                ………is the theft of personal information using a small electronic device to swipe and store hundreds of victims’ card numbers.

 (A) Dependency injection

 (B) Skimming (Correct Answer)

 (C) Sql injection

(D) Ip   sniffing

 

Question No.59 ………In MS Excel, the percentage style(%) button is available under     group.

 (A) Insert->Page group

  (B) Home->Insert group

 (C) Home->Save group

 (D) Home->Number group (Correct Answer)

 

Question No.60 ………Which among the following holds the 1st computer instructions available on bootup?

(A) ROM BIOS (Correct Answer)

(B) CPU

(C) Config.sys

(D) Boot.ini

 

Question No.61 ………In MS Word, table of contents lists the headings and their corresponding            

numbers.

 (A) Sheet

 (B)File

 (C)Table

 (D)Page (Correct Answer)

 

Question No.62 ………Encryption is processed on layer of the OSI model.

 (A) Session

 (B) Physical

 (C) Presentation (Correct Answer)

 (D) Application

 

Question No.63 ………is referred to as discovering patterns based on a large set of previous year’s data.

 (A) Data mining (Correct Answer)

 (B) Data collection

 (C) Data sampling

 (D) Data validation

 

Question No.64 ………Which location management technique does the 4G technology use, to report the network that they are
concatenated to a common object?

 (A)  Concurrent Location Register

 (B)  Concatenated Management

 (C)  Concatenated Location Registration (Correct Answer)

 (D)  Collated Location Registration

Question No.65 ………In MS Word option is used to provide additional information about a word within a document.

 (A) Tables and Objects

 (B) Header and Footer

 (C) Footnotes and Endnotes (Correct Answer)

(D)Word art and Object

 

Question No.66 ……A unique number that is assigned to any device connected to the Internet.

 (A)  MAC address

(B) Website address

 (C) Email address

 (D) IP address (Correct Answer)

 

Question No.67 ………What does .edu refers to with respect to website?

 (A) educational (Correct Answer)

 (B) economical

 (C) academy

 (D) ecological

 

Question No.68 ………In MS Excel, the combination of Row number and Column alphabet is called        

 (A) column address

 (B) cell

 (C)  row address

 (D) cell address (Correct Answer)

 

 

Question No.69 ………What is the full form of DNS?

 (A) Data Name system

 (B) Domain Name System (Correct Answer)

(C) Data Network System

 (D)Domain Network System

 

Question No.70 ………The MS Excel feature that allows you to show only selected rows based on a condition is:

 (A) Sort

 (B) Merge

 (C) Flash File

 (D) Filter (Correct Answer)

 

General English –
General English

Question No.1 ……Choose the best option from the given alternatives which can be substituted for the
given word/sentence.

The art of writing or solving codes

 (A) Pedantic

(B)  Potable

(C) Infallible

(D)  Cryptograph (Correct Answer)

 

Question No.2 ……Choose the word which best expresses the similar meaning of the given word ” GAZE
“. Choose the word which best expresses the similar meaning of the given word ” GAZE “.

(A) Moderate

(B) Look (Correct Answer)

(C) Ignorance

(D)  Important

 

Question No.3 ………Fill in the blanks with suitable Article from the given alternatives.

Tina’s mother is sensitive to cigarette smoke.

 (A) the

(B) a

 (C) an

(D) No article (Correct Answer)

 

Question No.4 ………Replace the underlined phrase grammatically and conceptually with the help of the given
options. If the given sentence is correct then select the option ‘The given sentence is correct’.

Most colleges employ
an behavior specialist in order to correct troubled students. Replace the
underlined phrase grammatically and conceptually with the help of the given
options. If the given sentence is correct then select the option ‘The given
sentence is correct’.

Most colleges employ
an behavior specialist in order to correct troubled students.

(A)  Most colleges
employs a behavior specialist in Most colleges employs a behavior specialist in

(B) Most colleges employs an behavior specialist in

 (C) Most colleges employ a behavior specialist
in (Correct Answer)

 (D)The given sentence
is correct The given sentence is correct

 

Question No.5 ………Fill
in the blank with suitable tense.

 The team leader             the target of production for the previous week.

 (A)  have successfully achieved

(B) has successfully achieved (Correct Answer)

(C) have successfully achieves

(D) had successfully achieves

 

Question No.6 ………Fill in the blanks with suitable Preposition from the given alternatives.

We have been living in this palace          1956.

 (A) through

(B)  against

(C) since (Correct Answer)

 (D) for

 

Case Study – 7 to 9           3.00

Read the passage
carefully and answer the questions that follow.

Indonesia’s tsunami has raised fears about the few dozen Javan rhinos still living in the world. There are believed to be fewer than 70
of the critically endangered species in Ujung Kulon National Park not far from the volcano that triggered the killer wave. None of the animals are killed in the disaster but officials are warning that another deadly wave could slam into the stricken region. That is putting pressure on conservationists at the National Park to ramp up a longstanding plan to find a suitable secondary habitat for the rhinos. Plans to find a second home for the species have been in the works. The shy creature once numbered in the thousands and roamed across Southeast Asia. But, like other rhino species across the world, poaching and human encroachment on its habitat has led to a dramatic population decline. The rhino horns are used in traditional Asian medicine fetching ever higher prices on the black market. Read the passage carefully and answer the questions that
follow.

Indonesia’s tsunami has raised fears about the few dozen Javan rhinos still living in the world. There are believed to be fewer than 70
of the critically endangered species in Ujung Kulon National Park not far from the volcano that triggered the killer wave. None of the animals are killed in the disaster but officials are warning that another deadly wave could slam into the stricken region. That is putting pressure on conservationists at the National Park to ramp up a longstanding plan to find a suitable secondary habitat for the rhinos. Plans to find a second home for the species have been in the works. The shy creature once numbered in the thousands and roamed across Southeast Asia. But, like other rhino species across the world, poaching and human encroachment on its habitat has led to a dramatic population decline. The rhino horns are used in traditional Asian medicine fetching ever higher prices on the black market.

 Question No.7 ………According to the passage, why were the Javan rhinos poached? According to the passage, why were the Javan rhinos poached?

(A) They are highly dangerous

(B) The rhinos’ horns have medicinal value (Correct Answer)

(C) They were huge in numbers

(D) They are edible

 

Question No.8 ………Why were the conservationists at the National Park planning to find a second habitat for the species?

 (A) Because there are volcanoes in Indonesia

(B)  They fear that another deadly wave could wipe out the Javan rhinos species (Correct Answer)

 (C)  The rhinos did not get enough food in the old habitat

(D) They are planning to renovate the old habitat

 

Question No.9 ………What is the reason for the decline in the population of Javan rhinos?

(A) Human encroachment only

(B)  Poaching only

(C)  Forest fire only

 (D) Both Human encroachment and Poaching (Correct Answer)

 

Question No.10 ………Find the word which is correctly spelt from the given options. Find the word which is correctly spelt from the given options.

(A)  Unfortunately (Correct Answer)

 (B) Sceince

(C) Negligant

(D)  Uncomfortabel

 

General Ability –
General Ability

Question No.1 ………Suppose the first and the second letters of the word EXPECTATIONS changed places, also
the third and the fourth, the fifth and the sixth, and so on. In the new word,
thus formed, which letter would be the 8th?

 (A) P

 (B) A (Correct Answer)

(C) C

(D) O

 

Question No.2 ………What value should come in the place of question mark (?) in the following question?
2.7×(27×6×597.5)÷72.9 = ?

 (A) 3385

 (B)3585 (Correct Answer)

(C) 3485

(D) 3285

 

Question No.3 ………Replace the question mark with an option that follows the same logic applied in the first pair

Dog : Bark :: Lion :
??

 (A) Mew

 (B) Trumpet

(C) Roar (Correct Answer)

 (D)Bleat

 

 

Question No.4 ………Find the next number in the series. 4, 9, 20, 43, 90, ?

 (A) 190

(B) 185 (Correct Answer)

(C) 175

(D)270

 

Question No.5 ………Christian obtained 174, 161, 180, 169 and 181 marks(out of 200) in English, Mathematics,
Physics, Chemistry and Biology. What is his average mark?

 (A) 143

 (B)163

(C)153

(D)173 (Correct Answer)

 

Question No.6 ………A girl walks 6km towards West and takes a right turn and walks 4km. She then walks 6km after taking another right turn. Which direction is the ending point from the starting point?

 (A) South

 (B)East

 (C)North (Correct Answer) (Chosen option)

(D) West

 

Question No.7 ………Pointing to a boy, a lady said, ” His mother is my father’s mother’s only daughter’s only brother’s only daughter.” How is the boy related to the lady?

 (A) Nephew

 (B) Son (Correct Answer)

 (C) Uncle

 (D) Brother

 

Question No.8 ………Pipe A can fill a tank in 486 seconds and Pipe B can fill the same tank in 243 seconds. If both pipes are opened together, how many seconds will it take to fill the empty tank?

 (A) 172

(B) 162 (Correct Answer)

(C)192

(D)182

 

Question No.9 ………If
35% of a certain number is 2905, then what is 65% of that number?

(A) 5495

 (B) 5595

 (C) 5295

 (D)5395 (Correct Answer)

 

Question No.10 ………If
15a=16b and b=c, find a:b:c.

 (A) 16:15:15 (Correct Answer)

(B) 15:15:16

 (C)14:15:16

 (D)15:16:15

 

General Knowledge
– General Knowledge

Question No.1………In which of the following months is the Sazo festival celebrated in the Kinnaur district of Himachal Pradesh?

 (A) January (Correct Answer)

 (B) August

 (C)March

 (D) May

Question No.2 ………Which of the following lakes in Mandi district of Himachal Pradesh is famous for its floating reed islands and fishes?

 (A) Manimahesh Lake

 (B)Rewalsar Lake (Correct Answer)

(C) Kareri Lake

 (D)Mahakali Lake

 

Question No.3 ………Which among the following is the largest glacier in Himachal Pradesh?

 (A)Miyar Glacier

  (B) Gora Glacier

 (C)Bara Shigri Glacier (Correct Answer)

(D) Perad Glacier

 

Question No.4 ………In September 2022, the State Government of Himachal Pradesh urged the Union Ministry of Home Affairs to declare the     as
an Epidemic.

 (A) Cancer

 (B) Polio

 (C) Diabetes

 (D)Lumpy Skin Disease (Correct Answer)

 

Question No.5 ………The nine day Shravan Ashtami Fair was recently held at the Chintpurni shrine in which district of Himachal Pradesh?

 (A) Una (Correct Answer)

(B) Mandi

 (C) Bilaspur

 (D)Shimla

 

Question No.6 ………Yamuna River enters Himachal Pradesh at “Khadar Majri” in            District.

 (A) Sirmaur (Correct Answer)

(B) Kinnuar

 (C) Mandi

 (D) Shimla

 

Question No.7 ………Kangri Dham is a traditional food festival celebrated in which of the following districts of Himachal Pradesh?

 (A) Kinnaur

 (B)Kangra (Correct Answer)

(C) Mandi

 (D) Shimla

 

Question No.8 ………Who among the following founded the historical town Tira Sujanpur in Himachal Pradesh?

 (A) Raja Mahendra Chand

 (B) Raja Rajendra Chand

 (C) Raja Maheshwar Chand

 (D) Raja Abhay Chand (Correct Answer)

 

Question No.9 ………In which year did Himachal Pradesh become a full-fledged state?

(A)  1978

 (B)1985

 (C)1965

 (D)1971 (Correct Answer)

 

Question No.10                ………Who among the following led the Sikhs in the Battle of Aliwal in 1846?   

(A) Balbir Sen    

(B)Ranjodh Singh Majithia (Correct Answer)    

(C)Charhat Singh            

(D)Bir singh