HPSSC Hamirpur Solved Paper JOA IT 2021 with Expalnation – Part 3


➤ One word substitution for ‘The normal abode of any animal or plant’ is

  • Environment
  • Habitat
  • Settlement
  • Niche

The term ‘Habitat’ refers to the normal abode of any animal or plant.

➤ When I met her last year, she ______ for five years.

  • Was married
  • Had been married
  • Had married
  • Would have married

‘Had been married’ is the correct tense for describing an ongoing action that was true at a past time.

➤ Meaning of the idiom ‘To look down one’s nose at’ is

  • To backbite
  • To show anger
  • To insult in the presence of others
  • To regard with half-hidden displeasure or contempt

To ‘look down one’s nose at’ means to regard someone with contempt or disdain.

➤ ‘अ-याय’ में समास है

  • तत्पुरुष
  • अव्ययीभाव
  • द्वंद्व
  • बहुव्रीहि

‘अ-याय’ is an example of तत्पुरुष समास (Tatpurush Samas).

➤ ‘सत्यानंद’ का संधि विच्छेद है

  • तपस्या
  • तपस्वी
  • तपी
  • तपना

The sandhi vichchhed of ‘सत्यानंद’ is ‘तपना’.

➤ ‘कोशिश’ में प्रत्यय है

  • को
  • कोश
  • शिश
  • इश

‘कोशिश’ में ‘शिश’ प्रत्यय है.

➤ Which of the following is not a valid type of a table field in MS Access 2013?

  • Email
  • Hyperlink
  • Long text
  • Currency

In MS Access 2013, ‘Currency’ is not a valid type of table field.

➤ Two types of table views in MS Access are _______ and design view.

  • Outline view
  • User view
  • Datasheet view
  • Spreadsheet view

In MS Access, ‘Datasheet view’ and ‘Design view’ are common types of table views.

➤ How will you find the data fields beginning with the letter ‘A’ and ‘B’ by using the “find and replace” dialogue box in the data sheet view of table in MS Access?

  • (AB)*
  • \AB%
  • {AB}$
  • [AB]*

The correct pattern to find data fields beginning with ‘A’ and ‘B’ is ‘{AB}$’.

➤ Which of the following field types in an MS Access table is read only?

  • Short text
  • Currency
  • Data/time
  • Calculated

Calculated fields in MS Access are read-only as they are computed from other fields.

➤ What is the full form of ODBC?

  • Open database connectivity
  • Object database connectivity
  • Other database connectivity
  • Oracle database connectivity

ODBC stands for Open Database Connectivity.

➤ A ______ key consists of one or more attributes of a table that is a primary key of some other table in the database.

  • Foreign
  • Secondary
  • Alternate
  • Candidate

A Foreign key is one or more attributes of a table that serves as the primary key of another table.

➤ What is the decimal number represented by the (10101010)² number in the binary number system?

  • 210
  • 164
  • 170
  • 168

The binary number (10101010)₂ represents the decimal number 170.

➤ What will be the representation of -25 in 2’s complement form?

  • Stack
  • Tree
  • Queue
  • Array

In the given options, the correct answer seems to be misplaced. The representation of -25 in 2’s complement form would typically be a binary value, not a data structure like Tree.

➤ A _______ is a powerful tool in Excel to calculate, summarise and analyse data to find out patterns and trends.

  • Pivot table
  • Filter
  • Macro
  • Range

A Pivot table is used in Excel for analyzing and summarizing data to identify patterns and trends.

➤ In an Excel sheet, the cell A2 contains data value of 10 December 2021, what will be the value returned by the formula “=text(A2,5)”?

  • December
  • Friday
  • 344
  • 6

The formula “=text(A2,5)” will return ‘Friday’ from the date value.

➤ The cell A1 in a certain MS Excel sheet contains the value 212, what will be the value returned by formula “= ceiling (A1,5)”?

  • 212
  • 200
  • 210
  • 215

The formula “=CEILING(A1,5)” will return 215.

➤ What will be the value returned by MS Excel formula “=BASE(212,2,8)”?

  • 10010101
  • 11010011
  • 1101011
  • 11010100

The formula “=BASE(212,2,8)” returns ‘11010100’.

➤ What will be the value returned by MS Excel formula “=CONVERT(1,2,”in,ft”)”?

  • 8.6
  • 8
  • 8.5
  • 8.3

The formula “=CONVERT(1,2,”in,ft”)” returns 8.5 feet.

➤ Consider the following data in an Excel sheet: sno marks 16 219 38 42 540 624. What will be the value returned by Excel formula “=MEDIAN(B2:B7)”?

  • 13.5
  • 14.5
  • 16.5
  • 17

The MEDIAN function returns the middle value of a set of numbers, which in this case is 13.5.

➤ In MS Excel, a ______ is a sequence of recorded keystrokes and mouse events that can be replayed as many times as one wants.

  • Formula
  • Macro
  • Table
  • Array

A Macro records and replays a sequence of actions in Excel.

➤ Which of the following is not a valid cell address in MS Excel?

  • A:A1
  • BA$10
  • AC210
  • $AB10

‘A:A1’ is not a valid cell address in Excel.

➤ How many cells are there in the cell range A10:D30 in MS Excel?

  • 80
  • 76
  • 84
  • 60

The range A10:D30 includes 84 cells.

➤ The concept of _________ was developed by JM Jacquard in the 18th century to control textile looms.

  • Abacus
  • Napier bones
  • Punch card
  • Difference engine

JM Jacquard developed the punch card system for controlling textile looms.

➤ Fourth generation computers used microprocessors which were designed using ________ technology.

  • Transistors
  • VLSI
  • Vacuum tubes
  • Mechanical relay

Fourth-generation computers used VLSI technology in their microprocessors.

➤ FLOPS is a unit to measure the processing speed of computers. What is the full form of FLOPS?

  • Floating-point operation per second
  • File listing operation per second
  • Foreman Libniz operations per second
  • Fast long operations per second

FLOPS stands for Floating-point Operations Per Second.

➤ B2B, B2C, G2C, and C2C are formats of _______.

  • Cloud model
  • Programming style
  • E-commerce
  • Document formats

These formats are related to E-commerce.

➤ The _________ sensor in mobile phones tracks the orientation whenever the device is rotated.

  • NFC
  • Gyroscope
  • GPS
  • Accelerometer

The Gyroscope sensor tracks the orientation of the device.

➤ Microsoft__________ is a cloud storage service that lets you store and backup your files.

  • S3
  • Dropbox
  • Hi drive
  • Onedrive

Microsoft OneDrive is the cloud storage service for file storage and backup.

➤ In mobile phone systems, a geographic region is divided up into ________ to implement the concept of frequency reuse.

  • ISP’s
  • Grids
  • Cells
  • Locations

Geographic regions are divided into Cells for frequency reuse in mobile systems.

➤ What is the full form of IOT?

  • Input/output test
  • Internet open telecommunication
  • Input output terminal
  • Internet of things

IOT stands for Internet of Things.

➤ _________ is the platform provided by Amazon that provides scalable and cost-effective cloud computing services.

  • AWS
  • BFS
  • NTFS
  • GFS

AWS (Amazon Web Services) provides scalable cloud computing services.

➤ __________ is a register in CPU that stores the intermediate result of arithmetic and logical operations.

  • Program counter
  • Accumulator
  • Memory address register
  • Instruction pointer

The Accumulator register in a CPU stores intermediate results of operations.

➤ In_______ CPU addressing mode, the operand is included in the instruction itself.

  • Direct
  • Intermediate
  • Indirect
  • Indexed

In the Intermediate addressing mode, the operand is part of the instruction.

➤ Which is an example of a secondary storage device?

  • ROM
  • Pendrive
  • RAM
  • Cache memory

A Pendrive is an example of a secondary storage device.

➤ Which of the following memory types has the highest speed and minimum latency?

  • CPU registers
  • Secondary memory
  • Cache memory
  • Primary memory

CPU registers have the highest speed and minimum latency.

➤ Cache memory works on the principle of__________.

  • Last in first out
  • Locality of reference
  • Total internal reflection
  • First in first out

Cache memory operates on the principle of Locality of Reference.

➤ The two cache memory write policies are write back and __________.

  • Write on
  • Read front
  • Dirty bit
  • Write through

Cache memory write policies include ‘Write Back’ and ‘Write Through’.

➤ The programs stored in ROM, PROM, and EPROM of computer systems are called_________.

  • Utility programs
  • Boot sector
  • Software
  • Firmware

The programs stored in ROM, PROM, and EPROM are known as Firmware.

➤ The __________ keys on QWERTY keyboard have small bumps on them to help position the fingers without looking at the keyboard.

  • F and J
  • A and L
  • K and S
  • Z and M

The ‘F’ and ‘J’ keys on a QWERTY keyboard have small bumps to assist in finger positioning.

➤ RAID technology combines multiple physical disk drives to achieve speed and redundancy. What is the full form of RAID here?

  • Redundant array of independent disks
  • Rapid access to independent disks
  • Read only access to interlinked disks
  • Reduced access to interlinked disks

RAID stands for Redundant Array of Independent Disks.

➤ Which of the following optical media storage has the highest capacity?

  • Blu-ray disk
  • Compact disk
  • Compact disk R
  • Digital video disc

The Blu-ray disk has the highest capacity among the given options.

➤ Which component of a laser printer melts the toner particles to form a permanent impression on the page?

  • Drum
  • Imaging unit
  • Mirror
  • Fuser

The Fuser component in a laser printer melts toner particles to create a permanent impression.

➤ Which of the following storage media uses flash memory?

  • Solid-state disk
  • CD ROM
  • HDD
  • Floppy disk

A Solid-state disk uses flash memory.

➤ Arithmetic logic unit (ALU) is a fundamental part of_________ of a computer.

  • CPU
  • Memory
  • Input/Output
  • Operating system

The Arithmetic Logic Unit (ALU) is a key component of the CPU.

➤ The___________ in a computer provides the option to change the priority of booting options in computer systems.

  • System registry
  • BIOS settings
  • Control panel
  • System recovery

The BIOS settings allow you to change the boot priority in a computer system.

➤ Which is a wireless technology that uses multiple transmitters and receivers to transfer more data at the same time?

  • WEP
  • SSID
  • MIMO
  • WAP

MIMO (Multiple Input Multiple Output) technology uses multiple transmitters and receivers to transfer more data simultaneously.

Follow us on

  • HP Police Question Paper
  • HPAS Previous Question Papers
  • Himachal Previous Exam PDF

Important Links

Latest Himachal Govt Vacancy

Best Academy in Himachal

Loading