Competitive Exams : Computer Awareness - Computer and IT Software (Set 3)

Question 1

Which of the following scenarios best describes the primary benefit of 'time-sharing' in an operating system environment with multiple users?

Accepted Answer

C) It rapidly switches the CPU's attention among different users' programs, creating an illusion of simultaneous execution.

Answer

A) It allows multiple users to access the same printer simultaneously without conflicts.

Answer

B) It ensures that all user data is encrypted and secure from unauthorized access.

Answer

D) It dedicates a separate physical processor to each active user for optimal performance.

Answer

E) It prioritizes background processes over interactive user applications.

Question 2

In Microsoft Excel, if cell A1 contains the date '2026-09-14' and you apply the formula `=TEXT(A1,"DDDD")` in cell B1, what will be the output?

Accepted Answer

B) Monday

Answer

A) 14

Answer

C) Sep

Answer

D) 2026

Answer

E) 14-Sep

Question 3

Which of the following database concepts is primarily concerned with reducing data redundancy and improving data integrity by organizing data into multiple related tables?

Accepted Answer

D) Normalization

Answer

A) Atomicity

Answer

B) Concurrency

Answer

C) Transaction

Answer

E) Indexing

Question 4

A network administrator notices that a significant amount of network traffic is generated by devices broadcasting ARP requests to resolve IP addresses to MAC addresses. Which layer of the OSI model is primarily responsible for handling these ARP communications?

Accepted Answer

A) Data Link Layer

Answer

B) Network Layer

Answer

C) Transport Layer

Answer

D) Session Layer

Answer

E) Application Layer

Question 5

Consider a scenario where a software application needs to model real-world entities as objects with attributes and behaviors. Which programming paradigm is best suited for this approach and why?

Accepted Answer

C) Object-Oriented Programming, because it uses classes and objects to represent entities and their interactions.

Answer

A) Procedural Programming, because it focuses on sequences of instructions.

Answer

B) Functional Programming, because it treats computation as the evaluation of mathematical functions.

Answer

D) Logical Programming, because it uses formal logic to represent facts and rules.

Answer

E) Scripting Programming, because it allows for rapid development and execution.

Question 6

A user frequently notices their computer running slowly and taking a long time to open files, even though they have sufficient RAM and CPU. Upon inspection, they find that files are scattered across many non-contiguous blocks on the hard drive. Which utility software would be most effective in improving this situation?

Accepted Answer

B) Disk Defragmenter

Answer

A) Antivirus Software

Answer

C) Disk Compression Utility

Answer

D) Backup Utility

Answer

E) Task Manager

Question 7

An attacker sends an email that appears to be from a legitimate bank, asking the recipient to update their personal information by clicking a link. The link, however, leads to a fake website designed to steal credentials. What is this type of cyberattack primarily known as?

Accepted Answer

D) Phishing

Answer

A) DDoS attack

Answer

B) Malware

Answer

C) SQL Injection

Answer

E) Brute-force attack

Question 8

A company needs to send personalized letters to 500 customers, each containing their specific address and account details, while keeping the main body of the letter consistent. Which feature in Microsoft Word would be most efficient for this task?

Accepted Answer

A) Mail Merge

Answer

B) Track Changes

Answer

C) Document Themes

Answer

D) Macros

Answer

E) SmartArt Graphics

Question 9

A software development team requires a cloud service that provides a complete development and deployment environment, including operating systems, programming language execution environments, databases, and web servers, but they want to avoid managing the underlying infrastructure. Which cloud service model best fits their requirements?

Accepted Answer

B) PaaS (Platform as a Service)

Answer

A) IaaS (Infrastructure as a Service)

Answer

C) SaaS (Software as a Service)

Answer

D) FaaS (Function as a Service)

Answer

E) DaaS (Desktop as a Service)

Question 10

When you visit a website, your web browser often stores small pieces of data on your computer, such as login sessions, shopping cart contents, or user preferences. What are these small data files commonly called?

Accepted Answer

A) Cookies

Answer

B) Cache

Answer

C) Bookmarks

Answer

D) History

Answer

E) Plugins

Question 11

Unlike Android, which is largely open-source and allows for extensive customization by manufacturers, iOS is known for its highly integrated hardware-software ecosystem and stricter control over the user experience. This difference primarily reflects a contrasting approach to which aspect of mobile operating systems?

Accepted Answer

C) Openness and Ecosystem Control

Answer

A) File System Architecture

Answer

B) Network Connectivity

Answer

D) Multitasking Capabilities

Answer

E) Power Management Protocols

Question 12

In computing, negative numbers are often represented using Two's Complement notation. If a system uses 8-bit Two's Complement, what decimal value does the binary `10000000` represent?

Accepted Answer

D) -128

Answer

A) 0

Answer

B) -1

Answer

C) -127

Answer

E) 128

Question 13

A developer needs to quickly test small code snippets and receive immediate feedback without going through a separate compilation phase. Which type of language processor would be most suitable for this interactive development approach?

Accepted Answer

A) Interpreter

Answer

B) Compiler

Answer

C) Assembler

Answer

D) Linker

Answer

E) Loader

Question 14

Modern file systems often employ a technique to record changes before they are actually committed to the main file structure, ensuring data integrity even in the event of system crashes. What is this technique commonly known as?

Accepted Answer

C) Journaling

Answer

A) Defragmentation

Answer

B) Compression

Answer

D) Encryption

Answer

E) Partitioning

Question 15

While OMR (Optical Mark Recognition) is efficient for processing multiple-choice answer sheets, which input device would be more suitable for digitizing handwritten notes from a tablet or converting printed text into editable digital documents?

Accepted Answer

B) OCR (Optical Character Recognition)

Answer

A) Barcode Reader

Answer

C) MICR (Magnetic Ink Character Recognition)

Answer

D) Light Pen

Answer

E) Plotter

Question 16

A software company releases a program under a license that allows users to freely use, modify, and distribute the software, provided that any derivative works are also distributed under the same free license. This licensing model is characteristic of what type of software?

Accepted Answer

D) Open-Source Software (with copyleft)

Answer

A) Shareware

Answer

B) Freeware

Answer

C) Proprietary Software

Answer

E) Commercial Software

Question 17

A large organization has several departments, each with its own specific network requirements, but they all need to communicate and share resources efficiently. To achieve this, each department maintains its own star topology, and these departmental networks are then connected to a central backbone. This setup represents which type of network topology?

Accepted Answer

E) Tree Topology (specifically as a star-bus hybrid)

Answer

A) Hybrid Topology

Answer

B) Ring Topology

Answer

C) Mesh Topology

Answer

D) Bus Topology

Question 18

A software development team frequently works on the same codebase, making changes, reviewing each other's work, and occasionally needing to revert to previous versions. Which type of software system is essential for managing these changes and collaboration effectively?

Accepted Answer

A) Version Control System (VCS)

Answer

B) Project Management Software

Answer

C) Integrated Development Environment (IDE)

Answer

D) Database Management System (DBMS)

Answer

E) Network Monitoring Tool

Question 19

When an operating system needs to run a program that requires more physical memory than is currently available, it can temporarily move data from RAM to a designated area on the hard disk. What is this technique called, and what is its primary purpose?

Accepted Answer

C) Virtual Memory, to extend apparent RAM capacity.

Answer

A) Paging, to speed up data access.

Answer

B) Segmentation, to protect memory regions.

Answer

D) Caching, to store frequently accessed data.

Answer

E) Swapping, to permanently store program data.

Question 20

A large retail chain collects vast amounts of transactional data from its sales, inventory, and customer interactions daily. To identify trends, patterns, and insights that can inform business strategies, they need a system to extract valuable knowledge from this data. What term describes this process of discovering patterns in large datasets?

Accepted Answer

B) Data Mining

Answer

A) Data Entry

Answer

C) Data Archiving

Answer

D) Data Encryption

Answer

E) Data Normalization