Summary
This video presents a comprehensive set of previous year's multiple-choice questions (MCQs) for the HPSSC JIIT upcoming exam, focusing on computer knowledge. It covers a wide range of topics including embedded systems, computer applications in business, hardware components like motherboards, MS Excel functions and formulas, PowerPoint features, basic computer concepts (digital vs. analog), memory units, hard drive location, machine cycles, printers (dot matrix, inkjet), MS-DOS commands, user interface elements (dialog boxes), MS Word functionalities, spreadsheet concepts (workbooks), presentation timing, Unicode, software errors (bugs/glitches), pseudocode, compilers, operating systems, multiprogramming, mouse settings, trackballs, printing methods, storage devices (CD-ROM), number systems, boot modes (cold, warm), CPU functions, instruction codes, computer generations, Windows versions and features (Cortana, Defender, Control Panel), Wi-Fi standards, IP addressing, guided vs. unguided media, scheduling algorithms, programs in execution (processes), open-source OS (Linux), system software, Excel cell references, OSI model layers, TCP/IP protocol, invalid IP versions, MAC addresses, fiber optics, Java programming concepts, MS Office components, spreadsheet applications, audio/image file formats, internet messaging (spam), e-governance, object-oriented programming (inheritance, constructors), memory types (primary, secondary), LCD displays, input/output devices, computer resolution, HTML/CSS, vacuum tubes, CPU speed units, cache memory, BIOS, ALU, HTTP, HTML structure and tags, URL validation, CSS rules, database concepts (tables, joins, SQL, primary keys, foreign keys, DDL commands), binary conversions, Boolean algebra (De Morgan's Law), sequential digital circuits, data structures (FIFO, stacks, queues), web logs (blogs), malware (worms, Trojans), networking protocols (TCP/IP), Excel functions (WORKDAY, COUNT A), chart types, macros, loopback addresses, ARP, and network distributions (Red Hat).
Key Insights
Computer use in business is attractive due to accuracy, reliability, and speed.
The use of computers for business applications is attractive because of its accuracy, reliability, and speed.
The main job of the CPU is to process data and execute instructions.
The main job of the CPU is to process data and information, and carry out program instructions.
Secondary storage does not require constant power.
Secondary storage does not require constant power to retain information for later retrieval.
Analog computer input is never converted to digital form.
In an analog computer, the input is never converted to a digital form.
Sections
Introduction and App Promotion
Welcome to HimRaksak YouTube channel for exam preparation.
The speaker welcomes viewers to the HimRaksak YouTube channel for an important class discussing computer MCQs for the upcoming HPSSC JIIT exam, focusing on previously asked questions.
Join Telegram and WhatsApp for class links and updates.
Viewers are encouraged to join the Telegram and WhatsApp groups to receive links for important classes and updates.
HimRaksak app offers mock tests and study material for various exams.
The HimRaksak app provides full-length mock test series for HPSSC JIIT, HP Police, HP High Court Clerk, HP Patwari, and complete GK sections for HP TET exams. It also offers PYQs from 2012-2019 for HP Patwari and HPPSC Paper 1, along with Hindi/English sections for HPPSC and HPSSC's 35-question requirement. PDFs of live classes are also downloadable from the app.
All-in-one pack covers multiple exams and GK sections.
An all-in-one pack is available covering HP Patwari, Panchayat Secretary, upcoming JIIT, HP TET (including GK), HPPSC Paper 1, and the HPSSC 35-question Hindi/English section.
Computer MCQs Part 1
An embedded system example is a scientific calculator.
The question asks for an example of an embedded system, with options including a scientific calculator, machine tool, CD-ROM, and magnetic tape. The correct answer provided is a scientific calculator.
Computer use in business is attractive due to accuracy, reliability, and speed.
The use of computers for business applications is attractive because of its accuracy, reliability, and speed.
The first computer architecture was proposed in 1970.
The question asks when the first computer architecture was proposed, with options in the 1970s. The correct answer is 1970.
The main circuit board of a system unit is the motherboard.
The main circuit board of a system unit is identified as the motherboard.
In MS Excel, 'Cell F5' refers to Column F and Row 5.
The reference 'Cell F5' in MS Excel refers to Column F and Row 5.
The result of a formula in an MS Excel cell is its calculated value.
The result of a formula in an MS Excel cell is the calculated value.
The ABS function converts negative values to positive in MS Excel.
The ABS function is used in MS Excel to convert negative values into positive values.
Use 'Shift + F11' to insert a new worksheet in MS Excel.
The shortcut key combination 'Shift + F11' is used to insert a new worksheet in the current workbook in MS Excel. (Note: The video mentions 'Alt + Shift + F1' which is also a shortcut for inserting a new sheet in some contexts, but Shift+F11 is more common).
To view headers and footers in PowerPoint, switch to Print Preview.
To view headers and footers in PowerPoint, you must switch to Print Preview mode.
PowerPoint provides printed copies of presentations via outlines, speaker notes, and audience handouts.
Options like outline view, speaker notes, and audience handouts provide printed copies or representations of a PowerPoint presentation.
Digital computers are not always superior to analog in speed.
A digital computer does not necessarily score over an analog computer in terms of speed.
The basic unit holding a single data unit is a storage location/register.
The basic unit within a computer capable of holding a single unit of data is a storage location or register.
Hard drives are normally located inside the system's main unit.
A hard drive is normally located inside the system's basic unit.
A machine cycle involves fetching, decoding, and executing an instruction.
A machine cycle refers to the process of fetching, decoding, and executing an instruction.
A dot matrix printer is an output device.
A dot matrix printer is classified as an output device.
The MS-DOS 'COPY' command copies files between disks.
While working with MS-DOS, the 'COPY' command is used to copy a specific file from one disk to another.
A dialog box appears when a program needs additional user information.
A window that is displayed whenever a program requires additional information from the user is called a dialog box.
Use 'Ctrl' + click to select a line in MS Word.
To select a line in MS Word, press the 'Ctrl' key and click anywhere in the sentence.
A workbook contains related worksheets in a spreadsheet program.
In a spreadsheet program, a document that contains related worksheets is called a workbook.
Use 'Rehearsal Timing' for custom slide timings in PowerPoint.
The 'Rehearsal Timing' option can be used to set custom timings for slides in a PowerPoint presentation.
Unicode binary system uses 16 bits per byte.
The Unicode binary system uses 16 bits per byte.
An alternative term for a software/hardware error (bug) is 'glitch'.
An error in software or hardware, called a bug, has an alternative computer-specific terminology known as a glitch.
Pseudocode is a high-level programming language.
Regarding pseudocode, the correct statement is that it is a high-level language.
Compilers depend on both operating systems and hardware.
Compilers are dependent on both the operating system and the hardware.
Operating systems are a type of system software.
An operating system is the most common type of system software.
Multiprogramming is enabled by operating systems and independent I/O units.
Multiprogramming is made possible by operating systems and input/output units that operate independently of the CPU.
The 'Control Panel' adjusts mouse cursor speed.
The 'Control Panel' option is used for increasing and decreasing the speed of the mouse cursor.
A trackball is an example of a pointing device.
A trackball is an example of a pointing device.
Dot matrix printers use a hammer-like key striking through an ink ribbon.
A printer that has a tiny hammer-like key striking the paper through an ink ribbon is typically not an inkjet, non-impact, or laser printer.
Storage devices can be sequential or direct access types.
Storage devices can be sequential access type only, or direct access type only, or both.
CD-ROM is an optical memory.
A CD-ROM is neither magnetic memory, semiconductor memory, nor a memory register; it is a type of optical memory.
The radix of the decimal number system is 10.
The base or radix of the decimal number system is 10.
Safe Mode is a diagnostic mode for Windows boot issues.
Safe Mode is a way to boot a Windows-based computer in diagnostic mode when critical system problems interfere with normal operation.
The main job of the CPU is to process data and execute instructions.
The main job of the CPU is to process data and information, and carry out program instructions.
Op-code specifies basic operations in machine/assembly language for the CPU.
Instruction codes used in machine or assembly language that specify basic operations in the CPU are called op-codes.
IBM PCs are considered fourth-generation computers due to microprocessors.
Personal computers (PCs) are considered fourth-generation computers and contain microprocessors.
Windows 9 is not a valid Microsoft Windows operating system version.
Among the given options, Windows 9 is not a valid version of the Microsoft Windows operating system.
Cortana is the virtual assistant for Windows 10.
Cortana is the virtual assistant for the Windows 10 operating system.
Use 'Windows + R' to open the Run box in Windows.
The shortcut key combination 'Windows + R' is used in Windows to show the Run box where commands can be typed.
Microsoft Defender is the antivirus program in Windows 10.
Microsoft Defender is an antivirus program built into the Microsoft Windows 10 operating system.
The Control Panel allows viewing and changing system settings in Windows.
The Control Panel is a component of Microsoft Windows that provides the ability to view and change system settings.
The IEEE standard for Wi-Fi networking is 802.11.
The IEEE standard for Wi-Fi networking is 802.11.
The IP address range 192.168.0.0 is reserved for private use.
The IP address range 192.168.0.0 to 192.168.255.255 is reserved for private network use.
Wi-Fi has the longest range among common wireless communication technologies.
Among the given wireless communication technologies, Wi-Fi has the longest range.
Radio waves, microwaves, and infrared rays are unguided transmission media.
Radio waves, microwaves, and infrared rays are examples of unguided transmission media.
FCFS, Round Robin, and SJF are CPU scheduling algorithms.
First Come First Serve (FCFS), Round Robin, and Shortest Job First (SJF) are types of CPU scheduling algorithms.
A process is a program in execution.
A process is defined as a program in execution.
Linux is a free and open-source computer operating system.
Linux is a computer operating system that is free and open-source.
Operating systems are examples of system software.
An operating system is an example of system software.
MS Excel's absolute cell reference uses dollar signs (e.g., $A$10).
In MS Excel, '$A$10' is an example of an absolute cell reference.
The Physical layer of the OSI model handles raw bit transmission.
In the ISO OSI reference model, the Physical layer is responsible for transmitting raw bits over the communication channel.
Vint Cerf and Bob Kahn developed TCP/IP.
Vint Cerf and Bob Kahn are credited with developing the TCP/IP protocol.
10.0.0.1 is an invalid IP version.
10.0.0.1 is considered an invalid IP version (likely referring to an invalid IPv4 address format in some contexts, though it's a valid private IP).
A MAC address has 48 bits.
A MAC (Media Access Control) address has 48 bits.
Single mode and multimode are types of optical fiber cables.
Single mode and multimode are two types of optical fiber cables.
Java does not support preprocessor directives.
The statement 'It supports the concept of preprocessor directives' is not true about the Java programming language.
The 'new' operator creates objects of a class in Java.
The 'new' operator is used in Java to create an object of a class.
'Prosperity' is not an access control specifier in Java classes.
'Prosperity' is not an access control specifier in a Java class.
DOS is not a component of the MS Office suite.
Among the given options, DOS is not a part of the MS Office suite.
MS Excel is a spreadsheet application software.
MS Excel is an example of a spreadsheet application software.
Various data types (text, numbers) can be entered into MS Excel cells.
Text, numbers, and other data types can be entered into cells in an MS Excel worksheet.
Use 'Ctrl + End' to go to the end of an MS Word document.
The shortcut key 'Ctrl + End' is used to go to the end of an MS Word document.
WAV is a file format for digital audio files.
WAV (Waveform Audio File Format) is a file format for digital audio files.
PDF is not a digital image file format.
PDF is not a digital image file format.
Photoshop is used for image editing.
Photoshop is a software application used for image editing.
Spam refers to unsolicited email advertisements.
Unsolicited email messages, usually advertisements, sent to a large number of systems are known as spam.
E-governance is the application of ICT for delivering government services.
E-governance is the application of ICT (Information and Communication Technology) for delivering government services to citizens.
Inheritance allows deriving new classes by extending existing ones in OOP.
The property of object-oriented programming languages that enables deriving new classes by extending existing classes is called inheritance.
A constructor is a special class method executed automatically.
A constructor is a special method of a class which is executed automatically upon object creation. (The video mentions exam time, which is irrelevant context).
RAM is considered primary memory in a computer.
RAM (Random Access Memory) is considered primary memory in a computer system.
LCD stands for Liquid Crystal Display.
LCD stands for Liquid Crystal Display.
A printer is used to create a hard copy of a document.
A printer is an output device used to create a hard copy of a document.
Keyboard, mouse, and scanner are input devices.
A correct list of computer input devices includes keyboard, mouse, and scanner.
Memory speed order: Secondary Storage < RAM < Cache Memory.
Different memory types in a computer system, in increasing order of their speed, are: Secondary Storage, RAM, Cache Memory.
Monitor screen pixel density is measured by resolution.
The maximum number of pixels that can be displayed on a monitor screen is called its resolution.
Link HTML elements using the <link> tag for external CSS.
An external CSS file is linked in an HTML document using the <link> tag.
First-generation computers used vacuum tubes.
The first generation of computers used vacuum tubes.
CPU processing speed is measured in Gigahertz (GHz).
A unit of measuring CPU processing speed is Gigahertz (GHz).
Cache memory is the fastest memory type.
Cache memory is the fastest memory type in a computer.
BIOS allows users to change boot option priorities.
The Basic Input/Output System (BIOS) provides the user with the facility to change the priority of booting options in the computer system.
The Arithmetic Logic Unit (ALU) is a fundamental part of the CPU.
The Arithmetic Logic Unit (ALU) is a fundamental part of the CPU (Central Processing Unit).
Tim Berners-Lee invented the Hypertext Transfer Protocol (HTTP).
Tim Berners-Lee is the inventor of the Hypertext Transfer Protocol (HTTP).
Apache is a popular web server software.
Apache is a popular web server software.
GET and POST are HTTP form data submission methods.
'GET' and 'POST' are form data submission methods in HTTP.
Correct HTML document structure: <html> <head> ... </head> <body> ... </body> </html>
The correct structure of an HTML document starts with <html>, followed by <head> and <body> sections.
Invalid URL example: 'mysite.com/'.
'mysite.com/' can be considered an invalid URL structure in many contexts.
Use the '<br>' tag for a line break in HTML.
The '<br>' HTML tag is used to insert a line break.
Use the '<img>' tag to insert an image in HTML.
The '<img>' HTML tag is used to insert an image.
CSS is used to style HTML elements in web pages.
CSS (Cascading Style Sheets) is a language used to describe the styles of HTML elements in a web page.
The 'href' attribute specifies the URL of a hyperlink.
The 'href' attribute of an HTML <a> tag is used to specify the URL of the hyperlink.
Use 'colspan' to merge adjacent cells in an HTML table row.
To merge two adjacent cells of a table row in HTML, 'colspan' is used.
Visiting each element of a data structure for processing is called Traversal.
Visiting each element of a data structure for some processing is called traversal.
A Queue data structure follows the First-In, First-Out (FIFO) principle.
The Queue data structure is known as a First-In, First-Out (FIFO) structure.
Stacks support push and pop operations.
The Stack data structure supports push and pop operations.
The INTERSECT operation combines common rows from two database tables.
The INTERSECT operation of two database tables contains all rows which are common in both tables.
SQL query to find distinct surnames: SELECT DISTINCT surname FROM employee;
The correct SQL query to find distinct surnames from an 'employee' table is 'SELECT DISTINCT surname FROM employee;'.
MongoDB is not a relational database management system (RDBMS).
Among the options, MongoDB is not a relational database management system.
123 (decimal) is equivalent to 1111011 (binary).
The equivalent binary representation of the decimal number 123 is 1111011.
De Morgan's Law in Boolean algebra relates NOT, AND, and OR operations.
The Boolean algebra equation shown (likely `(A+B)' = A'B'` and `(AB)' = A'+B'`) represents De Morgan's Law.
A flip-flop is a sequential digital circuit.
A flip-flop is a type of sequential digital circuit.
A primary key uniquely identifies records in a database table.
A primary key consists of one or more columns of a database table used to uniquely identify the records of that table.
Cartesian product of 2 columns/4 rows tables results in 4 columns/16 rows.
The Cartesian product of two database tables, each having 2 columns and 4 rows, will result in a relation with 4 columns (2+2) and 16 rows (4*4).
Foreign keys enforce referential integrity in relational databases.
The 'Foreign Key' constraint in relational databases is used to enforce referential integrity.
ALTER is a DDL SQL command.
ALTER is a Data Definition Language (DDL) SQL command.
SQL stands for Structured Query Language.
SQL stands for Structured Query Language.
Personal logs and journal entries on the web are known as blogs.
Personal logs and journal entries posted on the web are known as blogs.
Worms infect other machines through computer networks.
Worms normally move around and infect other machines through computer networks.
NAND gates can perform NOT, OR, and AND operations.
NAND gates can be used to perform NOT, OR, and AND type of operations.
New program installation usually adds to 'All Programs'.
When a new program is installed on a computer, it typically adds to 'All Programs'.
Use 'Edit' in MS Word to correct text.
The term used in MS Word to describe the act of correcting something is 'Edit'.
MS Excel default cell alignment: text left, numbers right.
By default, the cell content alignment in MS Excel is: text is aligned left, and numbers are aligned right.
PowerPoint presentations can use ready-made slide files called Templates.
A file containing ready-made style slides that can be used for presentations in MS PowerPoint is called a Template.
Physical level abstraction describes how data is stored in a DBMS.
In a DBMS, the Physical level of abstraction describes how data is stored.
Interactive data transmission in time-sharing may use half-duplex lines.
The interactive transmission of data within a time-sharing system may best be done using a half-duplex line.
MICR stands for Magnetic Ink Character Recognition.
MICR stands for Magnetic Ink Character Recognition.
Laser printers use light beams and electrostatic powder.
A printer that uses a light beam and electrostatically sensitive black powder is a laser printer.
Secondary storage does not require constant power.
Secondary storage does not require constant power to retain information for later retrieval.
The decimal number 74 is equivalent to 1001010 in binary.
The equivalent binary representation of the decimal number 74 is 1001010.
Operating Systems control computer operations.
A collection of system programs that together control the operations on a computer system is known as the Operating System.
Machine language is classified as a low-level language.
Machine language is classified as a low-level language.
Use the 'style' attribute for inline CSS in HTML.
Inline CSS is used in an HTML document by using the 'style' attribute of the HTML element.
CSS rule for red H1 background: H1 { background-color: red; }
The correct CSS rule to set the background color of an H1 element to red is 'H1 { background-color: red; }'.
The '<a>' tag creates hyperlinks in HTML.
The '<a>' HTML tag is used to create a hyperlink in a web page.
Analog computer input is never converted to digital form.
In an analog computer, the input is never converted to a digital form.
The logic unit in a CPU compares data.
The responsibility of the logic unit in the CPU of a computer is to compare data.
Cookies store browsing session information on the client's computer.
Plain text information about a browsing session stored on the client computer by the web server, via the web browser, is called a cookie.
Tim Berners-Lee is considered the father of the World Wide Web.
Tim Berners-Lee is known as the father of the World Wide Web.
WinZip is a popular file compression utility.
WinZip is a popular file compression utility.
A multiplexer selects one of many input lines for a single output.
A multiplexer is a combinational logic circuit that selects one of several input lines through a single common output line.
Use the '<hr>' tag to draw a horizontal line in HTML.
The '<hr>' HTML tag is used to draw a horizontal line.
HTML supports six heading levels (H1 to H6).
Six heading levels (H1 through H6) are supported by HTML.
Use the '<td>' tag to create a cell in an HTML table row.
The '<td>' HTML tag is used to create a cell in a table row.
The 'src' attribute specifies the image file URL in HTML.
The 'src' attribute of an image HTML element is used to specify the URL of the image file.
260.x.x.x is not a valid IPv4 address.
260.x.x.x is not a valid IPv4 address.
The PING command tests network reachability using ICMP messages.
The PING command makes use of ICMP messages to test the reachability of a specified computer over the network.
Red Hat is a popular Linux distribution supported by IBM.
Red Hat is a popular Linux distribution supported by IBM.
Cloud computing offers on-demand IT resources over the internet.
Cloud computing is the on-demand delivery of IT resources over the internet with pay-as-you-go pricing.
The 'Brain' virus (1986) is considered the first IBM PC compatible virus.
The 'Brain' virus, released in 1986, is considered the first IBM PC compatible virus.
Trojan horses appear as genuine applications but are malware.
A type of malware that appears to users as a legitimate application is a Trojan Horse.
TCP/IP stands for Transmission Control Protocol/Internet Protocol.
TCP/IP stands for Transmission Control Protocol/Internet Protocol.
MS Excel aligns text left and numbers right by default.
In MS Excel, text is aligned left, and numbers are aligned right by default.
WORKDAY function returns Feb 1, 2022, for the given parameters.
The value returned by the formula WORKDAY(DATE(2022,1,1), 1, DATE(2022,1,1)) in Excel, assuming Sunday, January 1, 2022, is February 1, 2022.
Transposing changes data orientation from rows to columns or vice versa.
Rotating data from rows to columns or vice versa is called transposing.
Volume charts are not a supported MS Excel chart type.
Among the given options, Volume chart is not a chart type supported by MS Excel.
Macros record and replay keyboard strokes in MS Excel.
The 'Macro' feature in MS Excel lets you record a sequence of key strokes and play them again when required.
127.0.0.1 is an IP address loopback address.
127.0.0.1 is a loopback IP address.
ARP maps IPv4 addresses to MAC addresses.
The Address Resolution Protocol (ARP) network protocol is used for mapping IPv4 addresses to Media Access Control (MAC) addresses.
Cell address for Row 25, Column 30 in Excel is AD25.
The address of the cell at Row 25 and Column 30 of an Excel worksheet is AD25.
'Cell K27:p32' is not a valid cell address in MS Excel.
'Cell K27:p32' is not a valid cell address in MS Excel.
The cell range V2 to F12 contains 55 cells.
The cell range from V2 to F12 calculation: Columns (F - V + 1) = (6 - 22 + 1) = -15. This might be an error in the question or implies wrapping. Assuming standard ranges, V2 to F12 is typically invalid. If interpreted as V2 to V12 and F2 to F12, it's complex. The stated answer '55' implies non-standard calculation. (Standard calculation: F column is 6, V column is 22. (6-22+1) = -15. If it meant V2:Z12 combined with F2:F12, it's still unclear. If it's just 5 columns wide (say V:Z) and 11 rows tall (2-12), then 5*11=55. This interpretation is used to match the answer).
$A$10 is an absolute cell reference in MS Excel.
$A$10 is an absolute cell reference.
The formula result is 45.
The value returned by the given formula is 45.
The cell range from A3 to G5 is represented as A3:G5.
The address of a cell range from A3 to G5 in MS Excel is A3:G5.
COUNT A function counts non-empty cells in a range.
The COUNT A function in MS Excel is used to count the number of non-empty cells in a given range.
Ask a Question
*Uses 1 Wisdom coin from your coin balance
![Learn C Programming and OOP with Dr. Chuck [feat. classic book by Kernighan and Ritchie]](https://i.ytimg.com/vi/PaPN51Mm5qQ/hqdefault.jpg)
