IKM Skills Assessment — Questions and Answers

Question 1: What is a materialized view?

Physically stored query result that must be refreshed (Correct answer)
Session-only temporary table
Directly updatable view
Virtual table reflecting current data

Correct answer: Physically stored query result that must be refreshed

A materialized view stores the query result physically, requiring periodic refresh.

Question 2: What does "HTTP" stand for?

Hyperlink Textual Protocol
High Transfer Text Protocol
High-Tech Transfer Process
HyperText Transfer Protocol (Correct answer)

Correct answer: HyperText Transfer Protocol

HTTP stands for HyperText Transfer Protocol, which is the foundational protocol for data communication on the World Wide Web. It defines how messages are formatted and transmitted, and what actions web servers and browsers should take in response to various commands.

Question 3: Which of the following best describes the primary goal of regression testing in a software quality assurance process?

To ensure that recent code changes or bug fixes have not adversely affected existing features. (Correct answer)
To test the performance and response time of the application under heavy user traffic.
To validate the graphical user interface and overall user experience against design specifications.
To verify that newly implemented features meet the specified user requirements.

Correct answer: To ensure that recent code changes or bug fixes have not adversely affected existing features.

Regression testing is specifically designed to uncover new bugs in existing functionality after a change, such as a bug fix or feature addition. Its purpose is to ensure that the existing, previously tested software still performs correctly.

Question 4: What is the primary difference between a hub and a switch?

Switches forward frames by MAC address while hubs broadcast to all ports (Correct answer)
Hubs are faster
Switches operate at Layer 3
Hubs support VLANs

Correct answer: Switches forward frames by MAC address while hubs broadcast to all ports

Switches maintain a MAC address table and forward frames only to the correct port, while hubs broadcast to every port.

Question 5: What is the difference between horizontal and vertical scaling?

No meaningful difference
Horizontal adds columns; vertical adds rows
Horizontal is SQL only; vertical is NoSQL
Horizontal adds more servers; vertical adds resources to existing servers (Correct answer)

Correct answer: Horizontal adds more servers; vertical adds resources to existing servers

Vertical scaling adds more CPU/RAM; horizontal scaling adds more servers.

Question 6: What is log rotation?

Managing log size by archiving, compressing, and removing old logs (Correct answer)
Log encryption
Sending logs to central server
Filtering by severity

Correct answer: Managing log size by archiving, compressing, and removing old logs

Log rotation prevents log files from consuming all disk space.

Question 7: What is the purpose of an interface in OOP?

Store global variables
Define a contract of methods implementing classes must provide (Correct answer)
Manage memory
Handle logging

Correct answer: Define a contract of methods implementing classes must provide

An interface defines method signatures that implementing classes must provide.

Question 8: A system administrator needs to set the permissions on a critical configuration file, `config.conf`, so that the file's owner can read and write to it, members of the group can only read it, and all other users have no permissions at all. Which of the following `chmod` commands will accomplish this?

chmod 764 config.conf
chmod 666 config.conf
chmod 755 config.conf
chmod 640 config.conf (Correct answer)

Correct answer: chmod 640 config.conf

The `chmod` command uses octal notation where Read=4, Write=2, and Execute=1. For the owner to have read and write permissions, the value is 4+2=6. For the group to have only read permissions, the value is 4. For others to have no permissions, the value is 0. Combining these gives the command `chmod 640`.

Question 9: What is the purpose of a load balancer in web application architecture?

To cache static content locally
To compress HTTP responses
To distribute incoming traffic across multiple servers (Correct answer)
To encrypt all data transmissions

Correct answer: To distribute incoming traffic across multiple servers

A load balancer distributes incoming network traffic across multiple servers to ensure no single server is overwhelmed.

Question 10: What is the primary function of Active Directory in a Windows environment?

Network packet routing
File compression
Real-time malware scanning
Centralized identity and access management (Correct answer)

Correct answer: Centralized identity and access management

Active Directory provides centralized authentication and authorization services, managing users, computers, groups, and policies across a Windows domain.

Question 11: What is intrinsic vs extrinsic motivation?

Intrinsic comes from internal satisfaction; extrinsic from external rewards (Correct answer)
No measurable difference
Intrinsic is weaker
Intrinsic is financial

Correct answer: Intrinsic comes from internal satisfaction; extrinsic from external rewards

Intrinsic arises from internal satisfaction; extrinsic from external rewards.

Question 12: What is the triple constraint?

Plan, Execute, Monitor
People, Process, Technology
Quality, Risk, Resources
Scope, Time, Cost (Correct answer)

Correct answer: Scope, Time, Cost

The triple constraint shows the interdependent relationship between Scope, Time, and Cost.

Question 13: What is the difference between a risk and an issue?

Risks are more severe
No difference
Issues affect budget; risks affect schedule
A risk is potential; an issue is a current problem (Correct answer)

Correct answer: A risk is potential; an issue is a current problem

A risk is an uncertain future event; an issue is a problem that has materialized.

Question 14: A database administrator is tasked with creating a backup strategy for a critical financial database. The business has specified a Recovery Point Objective (RPO) of 15 minutes and a Recovery Time Objective (RTO) of 2 hours. To meet the RPO, which of the following backup methods is MOST crucial to implement frequently?

Full weekly backups
Differential daily backups
Transaction log backups (Correct answer)
Offline cold backups

Correct answer: Transaction log backups

The Recovery Point Objective (RPO) of 15 minutes dictates the maximum acceptable amount of data loss. Transaction log backups capture all transactions and can be taken very frequently (e.g., every 15 minutes), allowing for point-in-time recovery and thus meeting the stringent RPO. Full and differential backups are performed less frequently and would not meet this requirement on their own.

Question 15: In the double-entry accounting system, which of the following accounts is increased with a debit?

Owner's Equity
Assets (Correct answer)
Liabilities
Revenue

Correct answer: Assets

In double-entry bookkeeping, Debits increase Assets, Expenses, and Dividends (or Drawings). Credits increase Liabilities, Equity, and Revenue. Therefore, Assets are the account type among the choices that is increased with a debit.

Question 16: A business analyst creates a report showing that ice cream sales and drowning incidents both rise in summer. What analytical error does this illustrate?

Sampling bias
Confusing correlation with causation (Correct answer)
Confirmation bias
Survivorship bias

Correct answer: Confusing correlation with causation

This illustrates confusing correlation with causation — both variables are driven by a common third factor (hot weather), but ice cream sales do not cause drownings; they are merely correlated.

Question 17: A program uses a `Shape` class with a method called `draw()`. Several other classes, such as `Circle`, `Square`, and `Triangle`, inherit from `Shape` and provide their own specific implementation of the `draw()` method. When the program calls the `draw()` method on a list of `Shape` objects, the correct `draw()` implementation is executed for each specific shape. This is an example of:

Composition
Data Hiding
Instantiation
Polymorphism (Correct answer)

Correct answer: Polymorphism

Polymorphism, which means 'many forms', allows objects of different classes to be treated as objects of a common superclass. It enables a single interface (like the `draw()` method) to be used for a general class of actions, with each specific subclass providing its own implementation.

Question 18: During the execution phase of an IT infrastructure upgrade, a key stakeholder submits a formal request to add a new server that was not in the original plan. What is the immediate next step the project manager should take according to standard change control procedures?

Reject the request because it constitutes scope creep.
Log the change request and assess its impact on the project's scope, schedule, and budget. (Correct answer)
Approve the request immediately to avoid delaying the stakeholder.
Implement the change and adjust the schedule accordingly.

Correct answer: Log the change request and assess its impact on the project's scope, schedule, and budget.

A formal change control process requires that all change requests are documented and evaluated before being approved or rejected. The first step is to log the request and then conduct a thorough impact assessment on key project constraints like scope, time, and cost. This ensures that decisions are made with a full understanding of the consequences, rather than reacting without analysis.

Question 19: What is the purpose of database normalization?

Increase query speed
Eliminate data redundancy and improve integrity (Correct answer)
Create backups
Compress storage

Correct answer: Eliminate data redundancy and improve integrity

Normalization organizes data to reduce redundancy and prevent update anomalies.

Question 20: A software development team is working on a project where the requirements are expected to change frequently based on stakeholder feedback after each new feature is demonstrated. Which project management methodology is most suitable for this scenario?

PRINCE2
Waterfall
Critical Chain Project Management (CCPM)
Agile (Correct answer)

Correct answer: Agile

Agile methodologies are designed for projects with evolving requirements. They use an iterative approach, breaking the project into small, manageable units (sprints or iterations) that allow for frequent feedback and adaptation. The Waterfall model, in contrast, is a linear, sequential approach best suited for projects with clearly defined and stable requirements from the outset.

Question 21: Which version control workflow creates a branch for each feature?

Trunk-based development
Forking workflow
Feature branch workflow (Correct answer)
Centralized workflow

Correct answer: Feature branch workflow

Feature branch workflow creates a dedicated branch for each feature, keeping main stable.

Question 22: Which SQL aggregate function would you use to count the number of non-NULL values in a column?

AVG()
MAX()
COUNT() (Correct answer)
SUM()

Correct answer: COUNT()

COUNT(column_name) returns the number of rows where the specified column is not NULL, making it the correct function for counting non-null values.

Question 23: Which data visualization principle does the concept of 'data-ink ratio' (Edward Tufte) promote?

Using 3D effects to make charts more visually engaging for executives
Ensuring every chart includes a legend and title for accessibility
Maximizing the proportion of ink used to convey actual data versus decorative elements (Correct answer)
Using bright colors to highlight the most important data points

Correct answer: Maximizing the proportion of ink used to convey actual data versus decorative elements

Tufte's data-ink ratio principle states that every element of a visualization should serve a purpose in conveying data — excess gridlines, borders, and decorative elements ('chartjunk') should be removed.

Question 24: In the context of workplace communication, what is the primary goal of active listening?

To fully concentrate on, understand, respond to, and remember what is being said. (Correct answer)
To wait for the other person to finish speaking so you can state your own opinion.
To identify flaws in the speaker's argument to win the discussion.
To formulate a counter-argument while the other person is speaking.

Correct answer: To fully concentrate on, understand, respond to, and remember what is being said.

Active listening is a communication technique that requires the listener to fully concentrate, understand, respond, and then remember what is being said. The goal is complete comprehension of the speaker's message, not just waiting for a turn to talk or preparing a rebuttal.

Question 25: What does "VPN" stand for?

Virtual Programming Network
Verified Public Network
Virtual Private Network (Correct answer)
Variable Packet Node

Correct answer: Virtual Private Network

VPN stands for Virtual Private Network, which creates a secure, encrypted connection over a less secure network, like the internet. It allows users to send and receive data as if their computing devices were directly connected to the private network, enhancing privacy and security.

Question 26: Which of the following actions is the clearest example of maintaining professional integrity?

Agreeing with your manager's opinion in a meeting to avoid potential conflict.
Taking ownership of a mistake you made in a report before anyone else discovers it. (Correct answer)
Sharing details about a challenging client with a colleague from another department.
Using a company laptop for minor personal tasks during your lunch break.

Correct answer: Taking ownership of a mistake you made in a report before anyone else discovers it.

Professional integrity is centered on honesty, responsibility, and ethical behavior. Taking ownership of a mistake demonstrates accountability, which is a core component of integrity.

Question 27: Which protocol is used to transfer files between a client and a server over a network?

SSH
SMTP
HTTP
FTP (Correct answer)

Correct answer: FTP

FTP (File Transfer Protocol) is a standard network protocol specifically designed for transferring computer files between a client and a server over a network. It is commonly used for uploading and downloading files to and from web servers and other remote systems.

Question 28: What is the primary function of DNS in networking?

To store MAC addresses
To encrypt network traffic
To convert domain names into IP addresses (Correct answer)
To route data packets

Correct answer: To convert domain names into IP addresses

The primary function of DNS (Domain Name System) in networking is to translate human-readable domain names (like example.com) into machine-readable IP addresses. This allows users to access websites and other network resources using memorable names instead of numerical IP addresses.

Question 29: What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability (Correct answer)
Automated, Consistent, Independent, Durable
Availability, Concurrency, Isolation, Delivery
Access, Control, Integrity, Distribution

Correct answer: Atomicity, Consistency, Isolation, Durability

ACID ensures reliable transactions: Atomicity, Consistency, Isolation, Durability.

Question 30: Which of the following is a type of malware?

Firewall
Encryption
Trojan Horse (Correct answer)
Cloud storage

Correct answer: Trojan Horse

A Trojan Horse is a type of malicious software that disguises itself as legitimate software to trick users into installing it. Once installed, it can create backdoors, steal data, or cause other damage, making it a significant cybersecurity threat.

Question 31: Which conflict resolution style involves mutual concessions?

Accommodating
Avoiding
Compromising (Correct answer)
Competing

Correct answer: Compromising

Compromising involves both parties making concessions to reach middle ground.

Question 32: Which IEEE standard defines Wi-Fi specifications?

802.11 (Correct answer)
802.1Q
802.15
802.3

Correct answer: 802.11

IEEE 802.11 is the family of standards defining wireless LAN communications.

Question 33: In a data warehouse, what is a 'fact table'?

A table that stores descriptive attributes about dimensions
A table that stores user access permissions
A table that records data transformations applied during ETL
A table that stores the measurable, quantitative data for analysis (Correct answer)

Correct answer: A table that stores the measurable, quantitative data for analysis

A fact table contains the numeric, measurable metrics (facts) of a business process, such as sales amounts or quantities, and is the central table in a star schema.

Question 34: What is the purpose of a subnet mask in IP addressing?

To divide an IP address into network and host portions (Correct answer)
To encrypt data
To define the physical location of a server
To assign an IP address to a device

Correct answer: To divide an IP address into network and host portions

A subnet mask is used in IP addressing to differentiate the network portion of an IP address from the host portion. This division allows for the creation of smaller, more manageable subnetworks within a larger network, improving efficiency, security, and organization of network resources.

Question 35: What is a CMDB used for in IT service management?

Storing source code
Tracking IT assets and their relationships (Correct answer)
Scheduling deployments
Monitoring bandwidth

Correct answer: Tracking IT assets and their relationships

A CMDB stores information about configuration items and their relationships, supporting change and incident management.

Question 36: What is the function of ICMP?

Provide error reporting and diagnostic messaging (Correct answer)
Transfer files
Manage email routing
Establish secure tunnels

Correct answer: Provide error reporting and diagnostic messaging

ICMP is used for error reporting and diagnostics like ping and traceroute.

Question 37: What is a deadlock in operating systems?

Disk read error
CPU overheating
Two or more processes waiting for resources held by each other (Correct answer)
Infinite loop

Correct answer: Two or more processes waiting for resources held by each other

A deadlock occurs when processes are permanently blocked, each waiting for a resource held by another.

Question 38: In object-oriented design, what is the primary purpose of defining a class with `private` attributes and `public` methods (getters and setters)?

To implement polymorphism through method overriding.
To enforce encapsulation by controlling access to the object's internal state. (Correct answer)
To ensure that all child classes can directly modify the attributes.
To allow any part of the program to access the attributes directly for efficiency.

Correct answer: To enforce encapsulation by controlling access to the object's internal state.

Making attributes `private` hides them from outside access. Providing `public` methods (getters and setters) creates a controlled interface for interacting with that data. This is the fundamental mechanism for enforcing encapsulation and data hiding, preventing direct, uncontrolled modification of an object's state.

Question 39: What is the difference between clustered and non-clustered indexes?

Non-clustered cannot be on primary keys
Clustered use hash storage
Clustered are faster for all queries
Clustered determines physical row order; non-clustered creates a separate structure (Correct answer)

Correct answer: Clustered determines physical row order; non-clustered creates a separate structure

A clustered index sorts actual data rows; a non-clustered index creates a separate lookup structure.

Question 40: Which of the following is a type of multitasking used by modern operating systems?

Preemptive multitasking (Correct answer)
Hierarchical multitasking
Linear multitasking
Cooperative multitasking

Correct answer: Preemptive multitasking

Preemptive multitasking is a method where the operating system controls when a process can use the CPU and can interrupt it at any time to allow another process to run. This ensures that all running applications get a fair share of CPU time, preventing any single application from monopolizing system resources. Modern operating systems like Windows, macOS, and Linux utilize preemptive multitasking to provide a responsive user experience.

IKM Skills Assessment

The IKM assessment is an adaptive knowledge measurement test used by employers to evaluate technical proficiency across IT, finance, and workforce skills.

Questions

60 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds