HPSSC JOA IT Previous Question Papers PDF Download
The HPSSC JOA IT Previous Question Papers PDF Download are essential resources for candidates preparing for the Junior Office Assistant (IT) exam conducted by the Himachal Pradesh Staff Selection Commission (HPSSC). These previous question papers provide insights into the exam’s structure, types of questions, and important areas of focus, including general knowledge, computer proficiency, and IT-specific topics. By studying these papers, candidates can gain a better understanding of the question format and improve their time management and accuracy skills.
HPSSC JOA IT Previous Question Papers PDF Download
Accessing and practicing with HPSSC JOA IT Previous Question Papers PDF Download allows candidates to assess their preparedness and identify areas needing improvement. These papers are particularly useful for boosting confidence and refining problem-solving strategies, helping candidates approach the exam with a well-rounded preparation.
HPSSC JOA IT Previous Question Papers PDF Download
➤ 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?
- 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.