Solved Paper JOA (IT) 2021 [Part-3] – HPSSC Hamipur

(121) One word substitution for the ‘The normal abode of any animal or plant ‘ is

1. Environment
2. Habitat
3. Settlement
4. Niche

(122) When I met her last year , she ______ for five years.

1. Was married
2. Had been married
3. Had married
4. Would have married

(123) Meaning of the idiom ‘ To look down one ‘s nose at ‘ is

1. To backbite
2. To show anger
3. To insult in the presence of others
4. To regard with half-hidden displeasure or contempt

(124) ‘अ-याय’ में समास है

1. तत्पुरुष
2. अव्ययीभाव
3. द्वंद्व
4. बहुव्रीहि

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

1. तपस्या
2. तपस्वी
3. तपी
4. तपना

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

1. को
2. कोश
3. शिश
4. इश

(128) Which of the following is not a valid type of a table field in MS access 2013?

1. Email
2. Hyperlink
3. Long text
4. Currency

(129) Two types of table views in MS access are _______ and design view.

1. Outline view
2. User view
3. Datasheet view
4. Spreadsheet view

(130) 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?

1. (AB)*
2. \AB%
3. {AB}$
4. [AB]*

(131) Which of the following field types in an MS Access table is read only?

1. Short text
2. Currency
3. Data/time
4. Calculated

(132) What is the full form of ODBC?

1. Open database connectivity
2. Object database connectivity
3. Other database connectivity
4. Oracle database connectivity

(133) A______key consists of one or more attributes of a table that is a primary key of some other table in the database.

1. Foreign
2. Secondary
3. Alternate
4. Candidate

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

1. 210
2. 164
3. 170
4. 168

(135) What will be the representation of -25 in 2’s complement form ?

1. Stack
2. Tree
3. Queue
4. Array

(136) Consider the following data in an excel sheet. What will be the value return by the Excel formula “=count (A1:C5)”?

	A	B	C
1	Sr no	Name	Marks
2	1	Aman	6
3	2	Anuj	7
4	3	Chinmay	7
5	4	Dhruv	2

1. 12
2. 15
3. 4
4. 8

(138) A_______ is a powerful tool in Excel to calculate, summarise and analyse data to find out patterns and trends.

1. Pivot table
2. Filter
3. Macro
4. Range

(139) 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)”?

1. December
2. Friday
3. 344
4. 6

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

1. 212
2. 200
3. 210
4. 215

(141) what will be the value returned by MS Excel formula ” =BASE(212,2,8)”?

1. 10010101
2. 11010011
3. 1101011
4. 11010100

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

1. 8.6
2. 8
3. 8.5
4. 8.3

(143) 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)” ?

1. 13.5
2. 14.5
3. 16.5
4. 17

(144) In MS Excel, a ______ is a sequence of recorded keystrokes and mouse events that can be replied as many times as one wants.

1. Formula
2. Macro
3. Table
4. Array

(145) Which of the following is not a valid cell address in MS Excel?

1. A:A1
2. BA$10
3. AC210
4. $AB10

(146) How many cells are there in the cell range A10:D30 in MS Excel?

1. 80
2. 76
3. 84
4. 60

(147) The concept of _________ was developed by JM jacquard in the 18th century to control textile looms.

1. Abacus
2. Napier bones
3. Punch card
4. Difference engine

(148) Fourth generation computers used microprocessors which were designed using ________ technology.

1. Transistors
2. VLSI
3. Vacuum tubes
4. Mechanical relay

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

1. Floating-point operation per second
2. File listing operation per second
3. Foreman Libniz operations per second
4. Fast long operations per second

(150) B2B,B2C ,G2C and Ç2Ç are formats of _______.

1. Cloud model
2. Programming style
3. E-commerce
4. Document formats

(151) The _________ sensor in mobile phones track the orientation whenever the device is rotated.

1. NFC
2. Gyroscope
3. GPS
4. Accelerometer

(152) Microsoft__________is a cloud storage service that lets you store and backup your files

1. S3
2. Dropbox
3. Hi drive
4. Onedrive

(153) in mobile phone systems, a geographic region is divided up into ________ to implement the concept of frequency reuse.

1. ISP’S
2. grids
3. Cells
4. Locations

(154) What is the full form of IOT?

1. Input/output test
2. Internet open telecommunication
3. Input output terminal
4. Internet of things

(155) _________ is the platform provided by Amazon that provides scalable and cost effective cloud computing services.

1. AWS
2. BFS
3. NTFS
4. GFS

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

1. Program counter
2. Accumulator
3. Memory address register
4. Instruction pointer

(157) In_______ CPU addressing mode, the operand is included in the instruction itself

1. Direct
2. Intermediate
3. Indirect
4. Indexed

(158) Which is an example of a secondary storage device?

1. ROM
2. Pendrive
3. RAM
4. cache memory

(159) Which of the following memory types has the highest speed and minimum latency?

1. CPU registers
2. Secondary memory
3. Cache memory
4. Primary memory

(160) Cache memory works on the principle of__________.

1. Last in first out
2. Locality of reference
3. Total internal reflection
4. First in first out

(161) The two cache memory write policies are write back and __________.

1. Write on
2. Read front
3. Dirty bit
4. Write through

(162) The programs stored in ROM , PROM and EPROM of computer systems are called_________.

1. Utility programs
2. Booth sector
3. Software
4. Firmware

(163) The __________ keys on qwerty keyboard have small bumps on them to help position the fingers without looking at the keyboard .

1. F and J
2. A and L
3. K and S
4. Z and M

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

1. Redundant array of independent disks
2. Rapid access to independent disks
3. Read only access to interlinked disks
4. Reduced access to interlinked disks

(165) Which of the following optical media storage has the highest capacity?

1. Blu ray disk
2. Compact disk
3. Compact disk R
4. Digital video disc

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

1. Drum
2. Imaging unit
3. Mirror
4. Fuser

(167) Which of the following storage media uses flash memory?

1. Solid-state disk
2. CD ROM
3. HDD
4. Floppy disk

(168) Arithmetic logic unit (ALU) is a fundamental part of_________of a computer.

1. CPU
2. Memory
3. Input/Output
4. Operating system

(169) The___________ in a computer provides the option to change the priority of booting options in computer systems.

1. System registry
2. BIOS settings
3. Control panel
4. System recovery

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

1. WEP
2. SSID
3. MIMO
4. WAP

Read the previous parts: Part-1 | Part-2