JK Police Constable Exam Computer Terminologies 2024 PDF
Document Details
Uploaded by Deleted User
2024
J&K POLICE
Tags
Summary
This document provides computer science questions focusing on terminologies, suitable for the 2024 JK Police Constable exam. The topics covered include the CPU, memory types, input/output devices, operating systems, networks, and more.
Full Transcript
CRACK JK POLICE CONSTABLE EXAM 2500+ QUESTIONS EVERTHING COVERED IN SINGLE CLASS J&K POLICE FOR JK CONSTABLE POLICE CONSTABLE EXAM 2024 Computer Terminologies GEOGRAPHY 100% FULL FREE COURSE EXAMOF INDIA...
CRACK JK POLICE CONSTABLE EXAM 2500+ QUESTIONS EVERTHING COVERED IN SINGLE CLASS J&K POLICE FOR JK CONSTABLE POLICE CONSTABLE EXAM 2024 Computer Terminologies GEOGRAPHY 100% FULL FREE COURSE EXAMOF INDIA for JK POLICE Constable Exam by NEXT EXAM IQ LECTURE : 01 500 + QUESTIONS COMPUTER EVERY TOPIC ISTERMINLOGIES COVERED IN THIS FOR JK POLICE CONSTABLE EXAM DON’T MISS THIS MOCK TEST SERIES Terminologies for JK Police Constable Exam Explanation Which of the following is considered the 'brain' of Answer: C. CPU the computer? Explanation: The Central Processing Unit (CPU) is often called the 'brain' of the computer because it A. Motherboard performs the core processing tasks and controls B. RAM most of the operations. C. CPU D. Hard Disk Terminologies for JK Police Constable Exam Explanation What type of memory is non-volatile and stores data Answer: B. ROM permanently, even when the computer is turned off? Explanation: ROM (Read-Only Memory) is non-volatile A. RAM and retains its data when the computer is turned off. It B. ROM is typically used to store firmware. C. Cache D. Registers Terminologies for JK Police Constable Exam Explanation Which of the following is the input device? Answer: C. Keyboard Explanation: The keyboard is an input device used to A. Monitor input data into the computer, whereas a monitor, B. Printer printer, and speaker are output devices. C. Keyboard D. Speaker Terminologies for JK Police Constable Exam Explanation Which type of software directly manages and controls Answer: C. Operating System the hardware components of a computer? Explanation: The operating system (OS) controls hardware resources and provides a platform for A. Application Software running application software. B. Utility Software C. Operating System D. Firmware Terminologies for JK Police Constable Exam Terminologies for JK Police Constable Exam Which of the following is the smallest unit of data in a computer? A. Bit B. Byte C. Nibble D. Word Explanation Answer: A. Bit What does 'LAN' stand for? Explanation: A bit is the smallest unit of data in a computer, representing a binary value of 0 or 1. A. Large Area Network B. Local Area Network C. Linked Area Network D. Logical Area Network Explanation Answer: B. Local Area Network There are several types of networks, including: Personal area network (PAN) Explanation: LAN (Local Area Network) is a network A network that connects devices like phones and computers in a personal area. A PAN can be wired or wireless, and typically has a reach of 10 meters. Eg. Bluetooth Local area network (LAN) A network that connects multiple devices in a single building or across different buildings. Eg. that connects computers within a limited area such WIFI Metropolitan area network (MAN) as a building or campus. A network that connects multiple land networks. e.g. Local Telephone Company Wide area network (WAN) A telecommunication network that connects LANs and other networks in different geographical regions. WANs can be basic or hybrid, and use a variety of technologies, including routers, fiber optics, and FSO links. Terminologies for JK Police Constable Exam Explanation Which device is responsible for converting digital Answer: C. Modem signals into analog signals and vice versa? Explanation: A modem (Modulator-Demodulator) converts digital signals from a computer into analog A. Router signals for transmission over phone lines and vice B. Hub versa. C. Modem D. Switch What does URL stand for? Explanation Answer: A. Uniform Resource Locator A. Uniform Resource Locator Explanation: A URL is the address of a resource on B. Universal Resource Locator the internet, such as a web page. C. Uniform Register Locator D. Universal Register Locator Terminologies for JK Police Constable Exam What is the purpose of a firewall in a Explanation computer network? Answer: B. To block unauthorized access A. To scan for viruses Explanation: A firewall is a security system that B. To block unauthorized access monitors and controls incoming and outgoing network C. To control printer access traffic based on security rules. D. To optimize hard disk space Terminologies for JK Police Constable Exam Terminologies for JK Police Constable Exam Which of the following is an example of a Explanation system software? Answer: C. Windows OS A. Microsoft Word Explanation: System software, such as Windows OS, B. Adobe Photoshop manages the computer hardware and serves as a C. Windows OS platform for running application software. D. Google Chrome Which component stores frequently Explanation accessed data to improve processing speed? Answer: B. Cache A. RAM Explanation: Cache memory stores frequently B. Cache accessed data and instructions to speed up C. Hard Drive processing by reducing access time to data stored in the main memory. D. ROM Which of the following is a volatile Explanation memory? Answer: C. RAM A. Hard Disk Explanation: RAM (Random Access Memory) is B. ROM volatile, meaning it loses all data when the power is C. RAM turned off. D. SSD Which of the following protocols is used to Explanation transfer files over the Internet? Answer: B. FTP A. HTTP Explanation: FTP (File Transfer Protocol) is used to B. FTP transfer files between a client and a server on a C. SMTP computer network. D. IP Terminologies for JK Police Constable Exam What does HTTP stand for? Explanation Answer: A. Hypertext Transfer Protocol A. Hypertext Transfer Protocol Explanation: HTTP is the protocol used for B. Hyper Transfer Protocol transmitting web pages over the internet. C. Hypertext Transmission Protocol D. Hyperlink Text Transfer Protocol Which of the following is NOT an operating Explanation system? Answer: C. Python A. Windows Explanation: Python is a programming language, not B. Linux an operating system. Windows, Linux, and macOS C. Python are operating systems. D. macOS What is the main purpose of an IP address? Explanation Answer: B. To identify a device on a network A. To store data Explanation: An IP address uniquely identifies a B. To identify a device on a network device on a network, enabling it to communicate C. To encrypt data with other devices. D. To manage user accounts Which term refers to malicious software? Explanation Answer: C. Malware A. Virus Explanation: Malware is a general term for malicious B. Firewall software designed to harm or exploit computers. C. Malware D. Spam What does AI stand for in computer Explanation science? Answer: B. Artificial Intelligence A. Automated Intelligence B. Artificial Intelligence Explanation: AI (Artificial Intelligence) refers to the C. Advanced Information simulation of human intelligence in machines that D. Assisted Intelligence are programmed to think and learn. John McCarthy is Considered as Father of AI Dennis Ritchie is Father of ‘C’ Programming Language. Which of the following storage devices has Explanation the fastest data access time? Answer: B. SSD A. Hard Disk Drive Explanation: SSD (Solid State Drive) provides faster B. SSD data access and retrieval compared to traditional C. CD-ROM Hard Disk Drives (HDD) or optical storage devices like CDs and DVDs. D. DVD What is cloud computing? Explanation Answer: C. Delivering computing services over the A. Using software on local machines internet B. Storing data on a physical hard drive Explanation: Cloud computing refers to delivering C. Delivering computing services over the internet services like storage, databases, and software over the internet instead of using local servers or D. Encrypting files for security personal devices. CRACK JK POLICE CONSTABLE EXAM Terminologies for JK Police Constable Exam 2500+ QUESTIONS EVERTHING COVERED IN SINGLE CLASS J&K POLICE FOR JK CONSTABLE POLICE CONSTABLE EXAM 2024 Thanks for Watching GEOGRAPHY 100% FULL FREE COURSE EXAMOF INDIA LECTURE : 03 500 + QUESTIONS HARDWARE EVERY TOPIC ISAND SOFTWARE COVERED IN THIS FOR JK POLICE CONSTABLE EXAM DON’T MISS THIS MOCK TEST SERIES Hardware and Software Software and hardware are the two primary components of a computer. Input-output devices, supplementary storage, and other internal components are further divisions of The visible and touchable physical or tangible part of a hardware. computer is called hardware. Hardware and software are mutually dependent on Software is an ethereal element that cannot be seen with the one another and one cannot work without the other. naked eye but is essential to the operation of a computer Hardware and Software Software is a combination of methods, guidelines, Mock Test Available Now documentation that directs a computer exactly what to do and also allows the users to communicate with a Download our App Next Exam IQ computer. One can say Computer Software is a programming code executed on a computer processor. Topic Wise mocks + Full length Mocks Hardware and Software Hardware and Software Examples of software are MS Word, PowerPoint, Excel, For example, if MS-Word is not installed on the MySQL, Google Chrome, Photoshop, etc. Most computer, one cannot make or open any document computers may be inefficient without software. that can be achieved through MS-Word. Also, a user cannot work on the Internet or visit any website if the system does not have Internet browser software. Hardware and Software System software The computer software is classified into two major A system software assists the user and the hardware parts: to operate and communicate with each other. It is software used to manage computer hardware System Software and Application Software behaviour to provide basic functionalities that are required by the user. Examples are Windows, Linux, Unix, etc. Hardware and Software In simple words, we can say that system software is an When a user first turns on the computer, it is the intermediary or a middle layer between the user and the hardware. system software that gets initialized and gets loaded in These computer software sanction an environment or the memory of the system. The system software runs platform for the other software to work in. in the background and is not used by the end-users. This is the reason why system software is very crucial in Hence the system software is also called ‘low-level managing the entire computer system. Operating systems, diagnostic tools, and device drivers are incorporated in software’. system software. Application Softwares Application Software also referred to as end-user programs Why Do We Need Software? or productivity programs are software that aids the user in executing tasks like doing online research, word processing, web browsing, graphics designing, language In this period of software technology, the software is processors, keeping logs of accounts, performing very beneficial and important in day to day life as they calculations, translators, editors or even playing games. are everywhere from TV, Computers, Mobile, Electrical They lie above the system software. appliances, Alarm clock, etc. Software applications are Examples are Word, Excel, PowerPoint, Oracle, etc. majorly developed to enhance our lives. Hardware and Software What Are the Categories of Computer Hardware? Which of the following is an example of application Input Devices software? Output Devices Storage Devices Processing Devices a) Microsoft Windows When a computer collects data from an input device, the data passes through an intermediary stage before it’s transferred to an output device. A processing device is b) Antivirus Program any device within a computer that interprets and manipulates incoming data during this stage. c) Microsoft Excel Some of the examples of a processing device are a central processing unit, graphics d) BIOS processing unit, motherboard, network card, etc. What is Utility Software's? Answer: c) Microsoft Excel Utility software refers to system management tools that help manage, maintain, and control computer resources. These programs are designed to perform a specific task Explanation: Application software is designed for end- related to the management of computer resources such as users to perform specific tasks such as word ensuring the smooth running of the system, optimizing processing, spreadsheets, etc. Microsoft Excel is used performance, or providing security. for spreadsheets and thus is application software. Windows and BIOS are system software, and antivirus Example : Antivirus Software, Firewall Software, Task is utility software. Manager Etc. Hardware and Software Which of the following is NOT an example of system System software includes operating systems like software? Windows, Linux, and macOS, which manage the hardware. Microsoft Word is application software used a) Windows for word processing. b) Linux c) MacOS d) Microsoft Word Hardware and Software Hardware and Software What is the primary purpose of system software? Which protocol is used for secure communication over a network? a) HTTP b) FTP c) HTTPS a) To help users write documents d) SMTP b) To entertain users HTTPS (HyperText Transfer Protocol Secure) is used for secure c) To manage hardware and run application software communication over a network, encrypting data between the browser d) To perform data analysis and the server, while HTTP does not provide this security. Hardware and Software Hardware and Software Which of the following is an example of utility What type of software is Microsoft Word? software? a) System software a) MS PowerPoint b) Utility software b) Disk Cleanup c) Application software c) Mozilla Firefox d) Firmware d) Adobe Photoshop Hardware and Software Hardware and Software Which of the following is a volatile memory? What does "GUI" stand for in computer terminology? a) ROM a) Graphical User Interaction b) RAM b) General User Interface c) Hard Disk c) Graphical User Interface d) Flash Drive d) General Utility Interaction Hardware and Software Hardware and Software Which of the following is a hardware component of What does BIOS stand for? a computer? a) Operating System a) Basic Input Output System b) Processor b) Binary Input Output System c) Word Processor c) Basic Information Output System d) Antivirus d) Binary Information Output System Hardware and Software Hardware and Software Which type of software converts high-level The Compiler translates high-level programming language code into machine language? language code into machine language in a single go before execution. a) Compiler b) Assembler c) Interpreter d) Linker Hardware and Software Hardware and Software Which of the following is NOT an example of Which of the following is the fastest data application software? transmission media? a) MS Word a) Coaxial Cable b) Google Chrome b) Fiber Optic Cable c) Linux c) Twisted Pair Cable d) Adobe Photoshop d) Wireless Network Hardware and Software Hardware and Software What is the function of a router in a computer A router directs data packets between different network? networks and determines the best path for data transmission. a) To assign IP addresses b) To filter viruses c) To forward data packets between networks d) To monitor network traffic CRACK JK POLICE CONSTABLE EXAM 2500+ QUESTIONS EVERTHING COVERED IN SINGLE CLASS Thanks for Watching J&K POLICE FOR JK CONSTABLE POLICE CONSTABLE EXAM 2024 GEOGRAPHY 100% FULL FREE COURSE EXAMOF INDIA LECTURE : 02 500 + QUESTIONS INPUT EVERY ANDIS TOPIC OUTPUT DEVICES COVERED IN THIS FOR JK POLICE CONSTABLE EXAM DON’T MISS THIS MOCK TEST SERIES Computer Input and Output Devices INPUT AND OUTPUT DEVICES The functioning of a computer system is based on the combined usage BY NEXT EXAM IQ of both input and output devices. Using an input device we can give instructions to the computer to perform an action and the device reverts to our action through an output device. Download our App Next Exam IQ to attempt Mock test for JK POLICE CONSTABLE EXAM Input and Output Devices for JK Police Constable exam Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam In Input Devices, Data flows from Device to the Computer. Which of the following is an example of an input device? (Asked in JKSSB Accounts Assistant Exam, 2020) Input devices require active user involvement; without user input, they do not generally send data to the computer. (a) Monitor (b) Printer In output Devices, Data flows from Computer to the Device. (c) Mouse (d) Speaker Some output devices can operate without continuous user involvement; for example, a printer can complete a print job while the user does other tasks. Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which output device is used for producing vector graphics? Which of the following is not an output device? (Asked in JKSSB Village Level Worker (VLW) Exam, 2018) (Asked in JKSSB Accounts Assistant Exam, 2021) (a) Laser printer (a) Plotter (b) Dot-matrix printer (b) Monitor (c) Plotter (c) Microphone (d) CRT monitor (d) Printer Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which among the following is the input device used Specially for Which of the following is an Input device of the computer? checking the answer sheets of an examination having multiple choice question? A) Projector B) Plotter A) Bar Code Readers C) Printer B) Optical Character Reader D) Barcode C) Magnetic Ink Card Reader D) Optical Mark Reader Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which input device is used to enter drawings or sketches into a Which device is used to input graphical images into a computer? computer? (Asked in JKSSB Junior Assistant Exam, 2018) (a) Digitizer (b) Joystick (a) Scanner (c) Light pen (b) Plotter (d) Touchpad (c) Printer Answer: (a) Digitizer (d) Projector Exam: JKSSB Village Level Worker 2023 Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam A light pen is an input device that: Which is a type of input device that is used in banks for cheques (Asked in JKSSB Junior Statistical Assistant Exam, 2019) processing? (a) Is used to scan documents a. Joystick (b) Detects touch input on screens b. MICR (c) Is used to draw directly on the screen c. Scanner (d) Prints images on paper d. Bar Code Reader Answer: (c) Is used to draw directly on the screen Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam When a computer prints a report, this output is called ? The _____________ pen is an input device which is used to select and display objects on a computer screen. a. Program b. Soft Copy Ink c. Hard Copy Light d. Printing Magnetic Character Reader Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Identify the device that act as both input and output devices? a. Lightpen b. Touch Screen c. Mouse d. VDU Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam The small element at the base of a mouse is called _________. Biometric devices like fingerprint scanners serve as which type of device? Roller Ball Pin a) Input b) Output TrackBall c) Processing RollerBall d) Storage Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which of these is an example of an input device used in gaming? What is the primary function of an input device? a) Monitor b) Joystick a) To process data c) Plotter b) To display data d) Speaker c) To send data to the computer d) To store data Answer: b) Joystick Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which of the following is an example of an input device? How does a mouse function as an input device? a) Monitor a) By scanning documents b) Printer b) By sending motion and click data to the computer c) Keyboard c) By printing documents d) Speaker d) By displaying output Answer: c) Keyboard Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which input device is primarily used for drawing or creating digital What is a Microphone used for in a computer system? illustrations? a) Trackball a) To input sound data b) Joystick b) To display visual data c) Graphics Tablet c) To input typed data d) Scanner d) To output sound Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which device is used to convert physical documents into digital Which of the following is NOT an input device? form? a) Barcode Reader b) Keyboard a) Mouse c) Plotter b) Printer d) Microphone c) Scanner d) Monitor Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam What does an RFID reader do? Which device would be used to capture real-world video for input into a computer? a) Reads printed barcodes b) Reads radio-frequency identification tags a) Printer c) Records sound b) Webcam d) Displays images c) Monitor d) Joystick Answer: b) Reads radio-frequency identification tags Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam What is the function of a barcode reader? Which input device can recognize patterns of light to allow interaction with a display? a) To scan and interpret barcodes b) To input sound a) Light Pen c) To display images b) Plotter d) To print text c) Touchscreen d) Scanner Answer: a) To scan and interpret barcodes Answer: a) Light Pen Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam The term used to define all input and output devices in a computer What is the primary function of an output device? system is ____ a) To input data into the computer a) Monitor b) To process data b) Software c) To display or produce the results of computer processing d) To store data c) Shared Resources d) Hardware Answer: c) To display or produce the results of computer processing Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which of the following is an output device? What is the purpose of a plotter? a) Keyboard b) Mouse a) To produce large-scale graphical output c) Monitor b) To scan images d) Scanner c) To store data d) To display visual data Answer: a) To produce large-scale graphical output Input and Output Devices for JK Input and Output Devices for JK Police Constable exam Police Constable exam Which output device is used for projecting digital content onto large How does a Braille display help users? screens? a) By converting text into sound a) Printer b) By displaying text as raised Braille characters for visually impaired b) Monitor users c) Projector c) By projecting images d) Plotter d) By printing documents in Braille Answer: c) Projector Answer: b) By displaying text as raised Braille characters for visually impaired users Input and Output Devices for JK Police Constable exam What does a sound card do in a computer system? a) It converts digital sound data into analog signals for speakers Thanks for Watching b) It stores audio files c) It enhances visual display quality d) It inputs sound into the computer Answer: a) It converts digital sound data into analog signals for speakers CRACK JK POLICE CONSTABLE EXAM 2500+ QUESTIONS EVERTHING COVERED IN SINGLE CLASS J&K POLICE FOR JK CONSTABLE POLICE CONSTABLE EXAM 2024 Who is the founder of Microsoft, the company that developed MS Office? a) Steve Jobs GEOGRAPHY 100% FULL FREE COURSE EXAMOF INDIA b) Bill Gates c) Larry Page LECTURE : 04 d) Mark Zuckerberg 500 + QUESTIONS Explanation: Bill Gates co-founded Microsoft Corporation in 1975 with Paul Allen. Microsoft is the company that developed the MS Office suite of EVERY TOPIC IS MS WORD ANDCOVERED IN THIS MS EXCEL applications. DON’T MISS THIS MOCK TEST SERIES Some Important Terms Charles Simonyl and Richard Brodie are the two creators of MS WORD. Clipboard : When We copy and it hold it on Clipboard, then we Paste it. It was initially known as ‘ Multi- Tool word Introduced in 1983. Green line – Grammatical Mistake Minimum Font 8 and 72 is Maximum. Blue line – Contextual Mistake Maximum Zoom – 100% Gutters : Space Before Paragrahs is Called Gutters. Minimum – 10% MS Excel Ms Excel is known as Spread Sheet Software. Excel Marcos- It is an Action or Set of Actions that you can Record. Charles Simonyi is considered the founder of Microsoft Excel: Control + W is the Shortcut to Close the Active Windows. Workbook is Collection of Sheets. Ms Access Columns – Alphabets It is Data Base Management system which was launched by Microsoft. In 2007 Excel Rows – Numbers Maximum Rows – 1048576 SQL – Structural Query Language Maximum Zoom -400% Max Columns - 16384 Minimum – 10% Extension -.accdb Powerpoint Functional Keys PPT was created by Robert Gaskins and Dennis Austin. It was released in April 20, 1987. Extension :.pptx In MS Word, what is the default font size? Which key combination is used to insert a hyperlink in MS Word? a) Ctrl + L a) 12 b) Ctrl + K b) 10 c) Ctrl + H c) 14 d) Ctrl + T d) 11 Answer: d) 11 Answer: b) Ctrl + K Explanation: The default font size in recent versions of MS Word (2010 Explanation: Ctrl + K opens the Insert Hyperlink dialog box, allowing and later) is 11. you to insert a link in your document. What is the shortcut for opening the font dialog box in MS Word? What is the shortcut to undo the last action in MS Word? a) Ctrl + F1 a) Ctrl + Y b) Ctrl + D b) Ctrl + U c) Ctrl + G c) Ctrl + Z d) Ctrl + P d) Ctrl + V Answer: c) Ctrl + Z Answer: b) Ctrl + D Explanation: Ctrl + Z undoes the last action performed in the Explanation: Ctrl + D opens the Font dialog box, where you can change document. font size, style, and other text properties. In MS Word, Ctrl + X is the shortcut for: What is the maximum zoom level you can set in MS Word? a) Copy a) 200% b) Paste b) 400% c) Cut c) 500% d) Undo d) 300% Answer: c) Cut Answer: c) 500% Explanation: Ctrl + X cuts the selected content and moves it to the Explanation: The maximum zoom level in MS Word is 500%, allowing clipboard. you to enlarge the document for detailed editing. Which of the following is not a valid zoom percentage option in MS Which of the following is used to make a selected text bold in MS PowerPoint's Zoom dialog box? Word? a) 33% a) Ctrl + I b) 66% b) Ctrl + U c) 400% c) Ctrl + B d) 1000% d) Ctrl + O Answer: d) 1000% Answer: c) Ctrl + B Explanation: The maximum zoom percentage in MS PowerPoint is Explanation: Ctrl + B is the keyboard shortcut for making the selected 400%. There is no 1000% zoom option available. text bold in MS Word. In Excel, which function is used to calculate the total sum of a range of To apply superscript formatting in MS Word, which shortcut is used? cells? a) Ctrl + Shift + = b) Ctrl + Shift + - a) AVERAGE() c) Ctrl + = b) SUM() c) COUNT() d) Ctrl + Shift + + d) MAX() Answer: a) Ctrl + Shift + = Explanation: Ctrl + Shift + = applies superscript formatting to the Answer: b) SUM() Explanation: The SUM() function is used to add all the numbers in a selected text. selected range of cells. Which of the following features in MS Word allows you to combine text from Which of the following allows you to lock rows or columns to keep multiple documents? them visible while scrolling? a) Mail Merge a) Freeze Panes b) Merge Cells b) Split c) Merge Formatting c) Protect Sheet d) Text Merge d) Filter Answer: a) Mail Merge Answer: a) Freeze Panes Explanation: Mail Merge allows you to create documents like letters and Explanation: Freeze Panes locks the selected rows or columns so they labels by combining text from a main document with a data source (e.g., remain visible while scrolling through the worksheet. names and addresses). In Excel, which of the following is used to apply the same formatting to In MS Word, what is the shortcut key to open a new document? multiple cells? a) Format Painter a) Ctrl + N b) Conditional Formatting b) Ctrl + O c) Merge Cells d) Data Validation c) Ctrl + D d) Ctrl + M Answer: a) Format Painter Answer: a) Ctrl + N Explanation: Format Painter is used to copy and apply the same Explanation: Ctrl + N creates a new blank document in MS Word. formatting from one cell to other cells. What is the shortcut key to insert a new worksheet in Excel? Which of the following keyboard shortcuts is used to create a new workbook in Excel? a) Ctrl + F11 b) Shift + F11 a) Ctrl + N c) Ctrl + Shift + N b) Ctrl + Shift + N d) Ctrl + Alt + N c) Ctrl + O Answer: b) Shift + F11 d) Ctrl + F Explanation: Shift + F11 inserts a new worksheet in the current Excel Answer: a) Ctrl + N workbook. Explanation: Ctrl + N creates a new blank workbook in Excel. In Excel, what is the shortcut key to edit the contents of a cell? In Excel, what is the default file extension for Excel 2010 and later versions? a) F1 a).xls b) F2 b).xlsx c) F3 c).txt d) F4 d).csv Answer: b) F2 Answer: b).xlsx Explanation: Pressing F2 allows you to edit the content of the currently Explanation: The default file format for Excel 2007 and later versions is selected cell..xlsx, while earlier versions used.xls. Which of the following is not a chart type in Excel? What does Ctrl + ; do in MS Excel? a) Line Chart a) It applies a date format b) Bar Chart b) It inserts the current date c) Pie Chart c) It inserts the current time d) Web Chart d) It creates a new worksheet Answer: d) Web Chart Answer: b) It inserts the current date Explanation: Web Chart is not a standard chart type in Excel. Explanation: Ctrl + ; inserts the current date into the selected cell in Excel. When was the first version of MS Office released? Which of the following is not a part of the MS Office suite? a) Microsoft Word a) 1985 b) Microsoft Excel b) 1990 c) Microsoft PowerPoint c) 1995 d) Microsoft Photoshop d) 2000 Explanation: The first version of Microsoft Office was released in 1990, Explanation: Photoshop is an image editing software developed by Adobe, consisting of Word, Excel, and PowerPoint for the Macintosh. not part of the Microsoft Office suite. The main applications in MS Office include Word, Excel, PowerPoint, and Outlook MS Office was initially designed to run on which platform? Which of the following MS Office versions was the first to use the Ribbon Interface? a) Linux b) Mac OS a) Office 2003 c) Windows b) Office 2007 d) Android c) Office 2010 Answer: b) Mac OS d) Office XP Explanation: The first version of MS Office was released for the Answer: b) Office 2007 Macintosh in 1990. It was later released for Windows in subsequent Explanation: The Ribbon Interface was introduced in MS Office 2007, years. replacing the traditional menus and toolbars to improve usability and access to commands. What is the default file extension for MS Word 2010 and later? In MS Word, which shortcut key is used to save a document? a).txt b).docx a) Ctrl + S c).pdf b) Ctrl + C d).xls c) Ctrl + V Answer: b).docx d) Ctrl + P Explanation: From MS Word 2007 onward, the default file format Answer: a) Ctrl + S changed from.doc to.docx. Explanation: Ctrl + S is the keyboard shortcut to save a document. Which of the following is not a type of page orientation in MS Word? In MS Word, Ctrl + E is used for: a) Center alignment a) Portrait b) Right alignment b) Landscape c) Left alignment c) A4 d) Justify alignment d) None of the above Answer: a) Center alignment Explanation: Ctrl + E centers the selected text or paragraph What is the function of Ctrl + H in MS Word? Which function in Excel is used to calculate the average of a range of a) Open the find and replace dialog box numbers? b) Open the spelling and grammar check a) MAX() c) Open a new document b) MIN() d) Open the print dialog c) AVERAGE() d) SUM() Answer: a) Open the find and replace dialog box Answer: c) AVERAGE() Explanation: Ctrl + H opens the Find and Replace dialog, allowing you Explanation: The AVERAGE() function returns the average (arithmetic to search for text and replace mean) of the numbers in a range of cells. In Excel, how do you start a formula? Which function is used to count the number of cells that contain numbers in Excel? a) = a) COUNTIF() b) + b) COUNT() c) @ c) COUNTA() d) # d) SUMIF() Answer: a) = Answer: b) COUNT() Explanation: All formulas in Excel start with an equal sign (=). Explanation: The COUNT() function counts the number of cells that contain numbers in a range. What is the keyboard shortcut to insert a new worksheet in Excel? In MS PowerPoint, which key is used to start the slideshow from the beginning? a) Ctrl + N a) F1 b) Shift + F11 b) F5 c) Ctrl + F10 c) F12 d) Ctrl + W d) Shift + F5 Answer: b) Shift + F11 Answer: b) F5 Explanation: Shift + F11 inserts a new worksheet in the current Explanation: F5 starts the slideshow from the first slide. workbook. What is the default slide layout when you create a new slide in Which of the following is not a valid view in PowerPoint? PowerPoint? a) Title Slide a) Slide Sorter b) Blank Slide b) Outline View c) Title and Content d) Comparison c) Print Preview Answer: c) Title and Content d) Reading View Explanation: The default layout for a new slide is the Title and Explanation: Print Preview is not considered a "view" mode in Content layout, which provides space for a slide title and other PowerPoint. Instead, it's an option used when preparing to print slides. content like text or images. Which PowerPoint feature will you use to apply motion effects In PowerPoint, what does Ctrl + M do? between slides during a presentation? a) Animations a) Inserts a new slide b) Slide Transitions b) Duplicates the current slide c) Slide Sorter c) Starts the slideshow d) Design d) Opens the master slide view Answer: b) Slide Transitions Answer: a) Inserts a new slide Explanation: Slide Transitions are used to apply motion effects Explanation: Ctrl + M inserts a new slide in PowerPoint. between slides. Which object in MS Access is used to retrieve data from one or more What is the maximum number of characters a field name can contain in tables? MS Access? a) Form a) 64 b) Report b) 128 c) Query c) 255 d) Macro d) 32 Answer: c) Query Answer: a) 64 Explanation: A Query is used to retrieve and filter data from one or Explanation: A field name in MS Access can contain a maximum of 64 more tables in MS Access. characters. Thanks for Watching In MS Word, which feature allows you to automatically check the spelling of a document? a) Grammar Check b) Spell Check c) AutoText d) AutoCorrect Answer: b) Spell Check Explanation: Spell Check checks the spelling in a document and suggests corrections for any misspelled words. CRACK JK POLICE CONSTABLE EXAM 2500+ QUESTIONS EVERTHING COVERED IN SINGLE CLASS STORAGE DEVICES FOR JK POLICE CONSTABLE EXAM J&K POLICE FOR JK CONSTABLE POLICE CONSTABLE EXAM 2024 Two Types of Memories GEOGRAPHY 100% FULL FREE COURSE EXAMOF INDIA Primary Memory LECTURE : 5 500 + QUESTIONS Secondary Memory EVERY TOPIC STORAGE IS COVERED DEVICES IN THIS AND OPERATING SYSTEM DON’T MISS THIS MOCK TEST SERIES RAMDON ACCESS MEMORY ( VOLATILE Primary Memory MEMORY) RAM ( RANDOM ACCESS MEMORY) – VOLATILE MEMORY It is System Short term Data Storage. ROM ( READ ONLY MEMORY ) – NON VOLATILE MEMORY Stores your Data , When your Computer is Actively Working. Primary Memory is also known as Main or Internal Memory. 08 GB of RAM is the Sweet Spot for Majority of Users. Located in the Motherboard which is also known as PRINTED CIRCUIT BOARD Directly Connected to CPU Divided into RAM AND ROM From Professional Point of View, 16 GB is must. RAM AND ROM INVENTED BY ROBERT Heath Dennard TYPES OF RAM Mock Test Available Now SRAM ( Static RAM) Download our App Next Exam IQ DRAM ( DYNAMIC RAM) Topic Wise mocks + Full length Mocks SD RAM ( SYNCHRONOMOUS RAM ) S RAM ( Static RAM) D RAM (Dynamic Ram) Static RAM is mostly Used as a Cache Memory. Data is Stored in Capacitors. Data is Stored using the State of 6 Transistors Memory Cell. It is Used in Today’s Computer. Capable of Retaining the Stored Information as long as the power is It need to Refreshed Where S RAM ( NO Need ) applied. SRAM is Faster than D RAM This type of Memory requires Constant Power. SD RAM ROM (Non-Volatile) Synchronous Dynamic RAM ROM is used by our Computer when it turns on for Botting Process. It is Used in Modern Processors. It is the Advanced form of DRAM. BIOS is present in ROM. It synchronizes itself with the Computer System. It is permanent Memory. The Next Generation of SD RAM is DDR Which is Double Data Rate DATA Stored Cannot be Modified. RAM DATA Instructions written in ROM is called Firmware. TYPES OF ROM STORAGE DEVICES ( SECONDARY MEMORY) PROM – Programmable ROM – NO Change. It is called Secondary Memory where the Personal DATA is stored. EPROM – Erasable Programmable ROM – Change Can be done by Manufacturers by using UV Rays. It is Non Volatile. EEPROM – Electrical Erasable Programmable ROM- Changed Can be done Method of DATA Accessing with Electrical Rays. 1. Sequential ( Magnetic Tape) EEPROM is generally used in Today’s Storage Devices. They are called as Flash ROM or Flash Memory. 2. Random ( Magnetic Disk ) TYPES OF STORAGE DEVICES MAGNETIC DISK Magnetic Tape These are Coated with Magnetic Material Such as Iron Oxide. Types It is used for Large Computers like Mainframe Computers. Mainframe Computers are generally Used in Banks. These Computers are Floppy disk developed by IBM. Hard disk Optical Disk Flash Memory Floppy Disk Floppy Disk is also known as Diskette launched by IBM in 1971. HARD Disk Floppy Disk is Invented by Alan Shugart. Non Volatile Sizes Connected to Motherboard 8 inches, 5.25 inches, and 3.5 inches were the three significant sizes. 8- inch floppy disks were the first to be commercially available, and they PATA, SATA AND SCSI is used to connect Hard disk for Connections. held approximately 1MB of data. Later versions of the 5.25-inch floppy Speed is Measured in Revolutions per minutes ( RPM) disk had a storage capacity of 160 KB, which was later increased to 360 KB and then to 1.22 MB. Speed – 5400 RPM to 7200 RPM HARD DISK FIRST Hard disk in 1956 Developed by IBM Speed of Cables is Measured By DATA Transfer Rate Founder : Reynold B. Johnson In hard Disk, DATA is Stored in Sectors. PATA FULL FORM – Parallel Advanced Technology Attachment Smallest Physical Store Unit is Sector. SATA – Serial Advanced Technology Attachment ( More Fastest) One Sector is 512 Bytes/0.5 KB SCSI – Small Computer System Interface. Maximum Size of Hard disk – 20 TB SSD Other Terms Solid State Drive Seek Time – Time Taken to Read and Write the Hard disk is the Seek Can hold DATA Upto 16 TB DATA. time. Latency Time – Time delay between a request for DATA and Return of SSHD ( Solid State Hybrid Drive) the DATA For Games and Professionals. Optical Disks FLASH Memory CD/DVD/BRD Founder – Fujio Masuoka CD Size – 700 MB Flash Memory is also known as EEPROMS. Eg. Pendrives, SD Cards, SSD Card ( Solid State Drives) DVD Size 4.7 GB SD Card – Secure Digital Blue Ray Disk – 25 GB Which type of memory is non-volatile and used to store firmware? A) RAM B) ROM C) Cache D) Register Answer: B) ROM Explanation: ROM (Read-Only Memory) is non-volatile, meaning it retains its contents even when the computer is turned off. It is used to store firmware, which is essential for booting up the computer. Which of the following is a secondary storage device? Which of the following storage devices can hold the most data? A) RAM A) Floppy Disk B) ROM B) CD-ROM C) Hard Disk C) Hard Disk D) Cache D) USB Flash Drive Answer: C) Hard Disk Answer: C) Hard Disk Explanation: Secondary storage devices are non-volatile, meaning they Explanation: Floppy disks and CDs hold a small amount of data (MBs), store data permanently. RAM and Cache are volatile memory (temporary while hard disks can store data in terabytes (TBs). USB flash drives, though storage), while ROM is used for firmware. Hard disks store data even when portable, generally have less storage capacity than modern hard drives. the power is off, making them secondary storage. Which of the following is a flash memory storage device? What is the storage capacity of a standard DVD? A) Hard Disk B) Floppy Disk A) 700 MB C) SSD B) 4.7 GB D) CD-ROM C) 9.4 GB Answer: C) SSD D) 25 GB Explanation: SSDs (Solid-State Drives) use flash memory for storage. Answer: B) 4.7 GB They are faster than traditional hard drives and do not have moving Explanation: Standard single-layer DVDs have a capacity of 4.7 GB. parts, which also makes them more durable. Dual-layer DVDs can hold up to 8.5 GB. What is the full form of SSD? Which of the following is not an example of secondary storage? A) Optical Disc A) Solid State Device B) Magnetic Tape B) Solid Storage Device C) RAM C) Solid State Drive D) USB Drive D) Static Storage Drive Answer: C) RAM Answer: C) Solid State Drive Explanation: RAM (Random Access Memory) is primary memory and Explanation: SSD stands for Solid State Drive. Unlike traditional hard drives (HDDs) that use spinning disks, SSDs have no moving parts and volatile, meaning it loses data when the computer is turned off. The store data using flash memory. others are secondary storage devices, which store data long-term. What is the maximum storage capacity of a CD-ROM? Which of the following is a storage device? A) 4.7 GB A) Monitor B) 700 MB B) Printer C) 1.4 MB C) Hard Disk D) 8.5 GB D) Keyboard Answer: B) 700 MB Answer: C) Hard Disk Explanation: A standard CD-ROM can store up to 700 MB of data, Explanation: A hard disk is a storage device used to store data long- which is sufficient for audio or simple software applications. term, while the other options are input or output devices. What is the main storage device used to permanently store data in Floppy disk contains which of the following? computers? A) Tracks A) RAM B) Sectors B) Hard Disk C) Both Tracks and Sectors C) Cache D) CPU D) Bits Answer: B) Hard Disk Answer: C) Both Tracks and Sectors Explanation: The hard disk stores data permanently, even when the Explanation: A floppy disk is divided into circular tracks, which are computer is turned off. RAM and cache are volatile memory that only further divided into sectors, used to store data. store data temporarily. What is the primary function of a hard disk drive (HDD)? Which of the following is true about cloud storage? A) It is a physical device kept onsite A) To process information B) It only allows for read access B) To store digital data C) It is typically more secure than local storage C) To manage input devices D) Data cannot be accessed without internet connectivity D) To power the computer Correct Answer: B) To store digital data Correct Answer: D) Data cannot be accessed without internet connectivity OPERATING SYSTEM FOR JK POLICE CONSTABLE Thanks for Watching EXAM JOIN TELEGRAM GROUP FOR PDF’S LECTURE : 08 Operating System An Operating system forms the core of any computer device. The An Operating System is the interface between the computer hardware functioning and processing of a computer system can come to hold and the end-user. Processing of data, running applications, file without an operating system. management and handling the memory is all managed by the computer OS. Windows, Mac, Android etc. Are examples of Operating systems which are generally used nowadays. All modern computing devices including Laptops, Tablet, mobile phones, etc. comprise an Operating System which helps in the smooth working of the device Gary Kildal is known as ‘Father of Operating System’ Initially, the computers made did not have an Operating system and to Mock Test Available Now run each program a different code was used. This had made the processing of data more complex and time taking. Download our App Next Exam IQ In 1956, the first operating systems were developed by General Topic Wise mocks + Full length Mocks Motors to run a single IBM computer. It was in the 1960s that IBM had started installing OS in the devices they launched The first version of the UNIX operating system was launched in the Name of Different Operating System 1960s and was written in the programming language C Some Important Terms Related to Operating Systems. FCFS – First Come First Served SJF- Shortest Job First RRS- Round Robin Scheduling PBS – Priority Based Scheduling GIGO- Garbage in Garbage Out Types of Operating System 1. Batch Operating System ( Oldest and slowest also) Allows us to Create Batches with Similar Job and each batch works simultaneously. Suitable for Application with Large Computation and no user Interaction. It works by making groups of jobs or by making Batches. Eg. Forecasting System, Stastical Programs, Payrolls, Banks Statements. 2. Multitasking Operating System It allows the operating system to execute multiple tasks or process concurrently. Example : Mobile phone. 03. Multiprocessing Operating System Multiprocessing refers to the execution of multiple processors at the same time. Two cpu are working with Simple RAM system Generally seen in Server network systems. 03. Real-Time Operating System It has a data processing system The processing time is very small between the user’s command and the output Used in fields where the response needs to be quick and rapid Examples : Flight Control Systems, Medical Imaging Systems and Industrial Control Systems. Ticket booking Systems. 04. Distributed Operating System When two or more systems are connected to each other and one can open files which are not present in their system but in other devices connected in the network Its usage has now increased over the years They use multiple central processors to serve real-time applications Example : Online shopping is the Best example Using Amazon, Banking and delivery Partner. 05. Time-Sharing Operating System 05. Embedded Operating System Multiple people at various terminals can use a program at the same These special Operating systems are built into larger systems time The main motive is to minimize the response time. They generally are limited to single specific functions like an ATM Example : Banking login , IRCTC Sites are good examples. Functions of Operating System It helps with memory management. It keeps a track of the files being saved in the Main memory 06. Mobile Operating System and the primary memory of the computer device Whenever a computer is turned on, the Operating system automatically starts to work. Thus, the booting and rebooting process of a computer device is also an important function of the OS With the advancement in the field of technology, smartphones now are It provides a user interface released with an Operating system. Managing of basic peripheral devices is done by the operating system Using the password protection option of an operating system, the data in the device can be kept They are designed in a manner that they can help a small device work secure efficiently It coordinates with the software and the user Easy navigation and organisation of files and programs are managed by the OS Any kind of program which needs to be run through the system is done by the operating system If any kind of error or bug is found during the program is detected using the operating system NAME OF OPERATING SYSTEM RELEASE DATE ANDRIOD 2008 IOS 2007 Which of the following is NOT an operating system? WINDOWS 1985 Mac OS 2001 MS DOS 1981 A) Windows Chrome OS 2011 B) Linux C) Oracle FIRE FOX 2023 D) Android UNIX 1969 BLACKBERRY OS 1999 Explanation: Oracle is a database management system (DBMS), not an Which of the following is NOT a type of operating system? operating system. Windows, Linux, and Android are all examples of operating systems. A) Batch Operating System B) Time-Sharing Operating System C) Real-Time Operating System D) Sequence Operating System Which of the following is used to manage memory in an operating C) Memory Manager system? Explanation: The Memory Manager is responsible for managing the computer’s primary memory. It keeps track of each byte in a computer's memory and is involved in allocating memory to processes A) File System when needed and deallocating when processes are no longer using the B) Disk Scheduler memory. C) Memory Manager D) Network Interface What is a 'process' in the context of an operating system? An instance of a running program Explanation: A process is an active instance of a program in execution. It includes the program code and its activity, and may have multiple A) A system call threads running inside it. B) An instance of a running program C) A thread D) A command in the command-line interface In which scheduling algorithm does the process that arrives first get Which of the following is a mechanism used by an OS to ensure that executed first? multiple processes do not access the same resource simultaneously? A) First Come First Serve (FCFS) A) Deadlock B) Shortest Job First (SJF) B) Virtualization C) Round Robin (RR) C) Concurrency control D) Priority Scheduling D) Mutual exclusion Answer: D) Mutual exclusion Mutual exclusion is a concept in which only one process can access a A deadlock in an operating system occurs when: critical resource at any one time. This is essential in concurrent programming to avoid race conditions. A) All processes are waiting for I/O to complete B) A set of processes are all blocked and waiting for each other Mutual exclusion in an operating system (OS) is a fundamental technique that ensures that only one process or thread can access a C) The CPU is overloaded with multiple processes shared resource at a time. D) The operating system crashes due to an illegal operation Answer: B) A set of processes are all blocked and waiting for each other A light weight process form the base utilization of CPU. Explanation: A deadlock occurs when a group of processes are all waiting for resources held by each other, forming a cycle of Light weight process is called Thread. dependencies and none of the processes can proceed. Which type of memory is managed directly by the operating Main memory (RAM) is directly managed by the operating system to system? load and execute processes. Virtual memory is an abstraction layer, while cache memory is managed by the CPU and secondary memory refers to storage like hard drives. A) Cache memory B) Secondary memory C) Main memory D) Virtual memory What is the main function of the 'kernel' in an operating system? Which of the following operating systems is open-source? A) Manage files on the disk B) Manage hardware resources A) Windows C) Manage user inputs B) macOS D) Display user interfaces C) Linux KERNEL is known as ‘Heart of Operating System’. It is the bridge between User and D) iOS Hardware’ SHELL – It is known as Command Interpreter. It is the set of programms used to interact with Application Programms and responsible for execution of instructions given to OS. Open and Closed type Operating Systems Open systems Allow multiple users to access and modify data on a single platform. Open Parameters Open Source Software Closed Source Software source software is a type of software that is open to the public, meaning that anyone can access and modify the source code. Open source software is often free and can be a good choice for individual users. Closed systems Linux, Apache, Windows OS, Adobe Photoshop, iTunes, Examples WordPress, Drupal, Restrict access to the platform or control who can modify the data. Closed Audacity, LibreOffice, etc. Microsoft Office Suite, source software, also known as proprietary software, is software where AutoCAD, etc. the public does not have access to the source code. Closed source software can be more expensive than open source software, but it often comes with dedicated support teams. Thanks for Watching SAFETY AND SECURITY FOR JK POLICE CONSTABLE EXAM Computer Last video Different types of Malware Malware Virus Worms (Self Replicate) Trojon Horse It stands for Malicious Software. Phishing Ransomware It is harmful to Spyware Computer Adware Rouge Sofware Server Wiper Client Scare Ware Network VIRUS Mock Test Available Now Founder – Fred Cohen Download our App Next Exam IQ Vital information Resource under seize. First Virus – Creeper (1971) – Bom Thomas Topic Wise mocks + Full length Mocks First Boot Sector Virus – Brain (1986) It Interepts the Booting Time of the System Both Virus and Worms replicate Types of Virus Resident Virus : Virus that stay in RAM and Deploys in First book sector virus by Amjad Farooj Alvi – person RAM from Pakistan, it was the first virus in india. Non Resident : Virus deploy in Ram but not stay in It Executes on Human Action. RAM is Non Resident Virus. Application software virus; WORMS Write once ready Many This virus which enters in our Application effects ms ooffice is Founder : Robert Morris called micro virus. First worm – Morris Worm Polymorhpic virus : Nature : Self Replicate That virus that changes itself, its nature and its signature is It is standalone virus, runs independent polymorhpic virus. Trojon horse Phishing It pretend to be useful but it is not. General seems in banking frauds generally related to Can take the control of your computer. financial terms Cloning of websites Can send , receive and even can delete your files Hacking of passwords from the system and reboot your computer. Fake webpage and website Wanna Cry Most Dangerours Ransomware First Ransomware : AIDS/PC , Then renamed to PC cyborg Some examples Wanny cry (2017), Bad rabbit Other Examples : It asks for Money. Locky (2016) It Encrypts files Bad Rabbit (2017) Happens in big organizations Ryuk ( 2018) Spoofing Sniffing It can hack IP addresses. Capturing all the packets (sniffers) Email from false sender. Tapping phone wires Spyware If Admins Rights of your computer hacked by the hacker, it is Rootkit. It is the type of malware, it monitor your online behavior. Web beacons – It is more or less like cookies It is a type of adware, tracking of cookies It is a transparent graphic image placed on website to track the Eg. Keyloggers, Rootkits, web beacons. client activities. A rootkit is a type of malware that allows cybercriminals to gain access to a computer system without being detected: It is also known as WEB BUG Rouge Malware DDOS Attack It is type of Internet Fraud. It misleads user that there is virus on computer. Distributed denial of Service Attack It convince to pay to remove the virus. Botnets are used here. Unlimited requests to the server, it is DDOS. Wiper Malware It is more destructive in nature. It aims at wiping the entire hard disk Some other terms Scare ware Time bomb-