Question 1

Given a sorted array, which search algorithm generally offers better performance for larger datasets compared to linear search?

Accepted Answer

Binary Search

Answer

Bubble Sort

Answer

Insertion Sort

Answer

Selection Sort

Question 2

Which of the following SQL commands is used to modify existing data in a table?

Accepted Answer

UPDATE

Answer

SELECT

Answer

INSERT INTO

Answer

DELETE FROM

Question 3

In object-oriented analysis, what does the concept of "inheritance" allow a subclass to do?

Accepted Answer

Inherit properties and behaviors from its superclass

Answer

Hide its internal data from other classes.

Answer

Define completely new properties and behaviors unrelated to its superclass.

Answer

Directly access and modify the private members of its superclass.

Question 4

What is the primary function of the Transport Layer in the TCP/IP model?

Accepted Answer

Providing end-to-end communication and data segmentation.

Answer

Defining the physical characteristics of the network medium.

Answer

Controlling access to the network medium.

Answer

Handling routing of packets across multiple networks.

Question 5

What is the purpose of a DNS (Domain Name System) server?

Accepted Answer

To translate human-readable domain names into IP addresses.

Answer

To encrypt web traffic for secure communication.

Answer

To manage user authentication and authorization for web applications.

Answer

To cache frequently accessed web pages for faster loading.

Question 6

What is the primary benefit of using functions (or methods) in programming?

Accepted Answer

To promote code reusability and modularity.

Answer

To automatically optimize the program's execution speed.

Answer

To reduce the overall size of the compiled code.

Answer

To directly manipulate the computer's hardware.

Question 7

A user reports that they cannot access a specific website. You can successfully ping the website's IP address. What is the most likely cause of the problem?

Accepted Answer

The website's web server is down or not responding to HTTP requests.

Answer

The website's DNS server is unavailable.

Answer

There is a routing issue between the user's network and the website's server

Answer

The user's network cable is disconnected.

Question 8

Which of the following best describes the role of the operating system (OS)?

Accepted Answer

To provide a platform for running application software and manage system resources.

Answer

To perform complex mathematical calculations and data analysis.

Answer

To connect the computer to the internet and manage network communication.

Answer

To directly interact with the computer's hardware components.

Question 9

What is a key characteristic of cloud computing?

Accepted Answer

On-demand access to shared computing resources over a network.

Answer

Resources are physically located on the user's premises.

Answer

Software and hardware are purchased with a one-time perpetual license.

Answer

Users have direct control over the underlying infrastructure.

Question 10

What is the purpose of database normalization?

Accepted Answer

To reduce data redundancy and improve data integrity.

Answer

To enhance the visual presentation of data.

Answer

To encrypt sensitive data stored in the database.

Answer

To increase the speed of data retrieval.

Question 11

Which SQL clause is used to filter rows based on a specified condition after the rows have been grouped?

Accepted Answer

HAVING

Answer

GROUP BY

Answer

ORDER BY

Answer

WHERE

Question 12

What is the primary purpose of a Use Case Diagram in UML (Unified Modeling Language)?

Accepted Answer

To depict the interactions between actors and the system's functionalities.

Answer

To represent the physical deployment of software components.

Answer

To model the static structure of a system.

Answer

To show the sequence of messages exchanged between objects.

Question 13

What is the subnet mask used for in IP addressing?

Accepted Answer

To determine the network address and the host address within a network.

Answer

To prevent unauthorized access to a network.

Answer

To encrypt data packets for secure transmission

Answer

To translate MAC addresses to IP addresses.

Question 14

What is the role of CSS (Cascading Style Sheets) in web development?

Accepted Answer

To control the visual presentation and styling of a web page.

Answer

To manage server-side logic and database interactions.

Answer

To add dynamic behavior and interactivity to a web page

Answer

To define the structure and content of a web page.

Question 15

What is the concept of "polymorphism" in object-oriented programming?

Accepted Answer

The ability of an object to take on many forms.

Answer

The creation of new classes based on existing classes.

Answer

The process of hiding the internal implementation details of an object.

Answer

The mechanism of bundling data and methods that operate on the data.

Question 16

A computer can connect to the local network but cannot access websites on the internet. What is a likely issue to investigate first?

Accepted Answer

The default gateway configuration on the computer or the router's internet connection.

Answer

The computer's antivirus software is blocking all network traffic.

Answer

The computer's hard drive is full.

Answer

The network interface card (NIC) is malfunctioning.

Question 17

What is the purpose of the BIOS (Basic Input/Output System) in a computer?

Accepted Answer

To load the operating system into memory during the boot process and perform initial hardware initialization.

Answer

To provide a graphical user interface for interacting with the computer.

Answer

To manage the file system and organize data on storage devices

Answer

To handle network communication and manage internet connectivity

Question 18

What is a significant security concern associated with the increasing adoption of mobile devices in enterprise environments?

Accepted Answer

Difficulty in managing and securing a diverse range of devices.

Answer

Decreased network bandwidth availability.

Answer

Reduced processing power compared to desktop computers.

Answer

Limited availability of mobile applications for business tasks.

Question 19

In the context of system design, what does "coupling" refer to?

Accepted Answer

The degree to which different modules within a system depend on each other.

Answer

The visual representation of the relationships between entities in a database.

Answer

The ability of a system to adapt to changes in its environment.

Answer

The process of grouping data and methods that operate on the data within an object.

Question 20

A user can access internal network resources but cannot browse any external websites. Assuming their physical connection is fine, what is a likely cause?

Accepted Answer

There is an issue with the DNS server configuration on their computer or the network.

Answer

Their computer's clock is set incorrectly.

Answer

The monitor resolution is set too low.

Answer

The web browser is not the default browser.