Learn how to detect and resolve overlapping IPv4 subnets across multiple network interfaces on Linux using Bash commands. This guide covers listing all interface configurations, identifying subnet conflicts, and removing duplicate addresses from lower-priority interfaces while preserving network stability and preventing asymmetric routing issues.

Eliminate false file modifications caused by line-ending differences between Windows (CRLF) and Unix (LF) systems. Configure .gitattributes, renormalize existing files, and prevent constant git status noise. Essential for cross-platform teams, Windows-Unix collaboration, preventing unnecessary commits, and maintaining clean repositories in heterogeneous development environments.

Send a GET request to a cryptocurrency API endpoint, retrieve JSON response containing market data, and save the complete response to a file using Python.

Read an INI configuration file using Python's configparser module, extract key-value pairs from a specific section, and save the data as JSON format.

Objective

This SQL interview question focuses on writing a query to fetch specific employee details from an employees table while ensuring those employees are not listed as managers in a managers table. The query should accurately retrieve the names, titles, and salaries of these non-manage...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Practice a hard Snowflake SQL interview question tagged Cisco that tests window functions, aggregation, and conditional logic. Working with an SEO analytics dataset, you must find the highest scoring page per domain and identify the overall best page across all domains using CASE expressions and window functions. This question evaluates your ability to combine per-group and global rankings in a single query.

Assign sequential row numbers to authors within each research paper group using a window function.

WITH aggregated AS (
SELECT
m.location,
e.mineral,
SUM(e.quantity) AS total_quantity
FROM {{ ref("mines") }} m
INNER JOIN {{ ref("extractions") }} e
ON m.id = e.mine_id
GROUP BY m.location, e.mineral
)
SELECT *
FROM aggregated
ORDER BY location ASC, mineral ASC

Practice joining DataFrames and using conditional logic in PySpark. Learn how to calculate regular and overtime employee pay using F.when().otherwise().

Definition for a binary tree node.

class TreeNode:

def init(self, val=0, left=None, right=None):

self.val = val

self.left = left

self.right = right

def good_nodes(root: TreeNode) -> int:
def dfs(node, max_so_far):
if not node:
return 0

    res = 1 if node.val >= max_so_far else 0
    max_so_far = max(max_so_far, node.val)
    
    res += dfs(node.left, max_so_far)
    res += dfs(node.right, max_so_far)
    
    return res
    
if not root:
    return 0
return dfs(root, root.val)