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.

In our Git repository home interview repo, we have file called script sh. This file gets consistently shown as modified when we run git status. The reason for this consistent change is when we run git diff, it shows every line has changed with this symbol, which indicates line ending difference betw...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

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

We will be calculating overtime pay. Spark is a big data framework that processes large amounts of data across multiple machines. We are given two files: employees.csv and payroll.csv. First data frame contains the names of employees, their IDs, ages, and job positions. The second one stores hourly rate, amount of hours worked, and reference to an employee by ID. Our job is to calculate total pay for each employee, which consists of two rules. If an employee worked less or equal to 40 hours, then the total pay is the product of hours worked and hourly rate. But if an employee worked more than 40 hours, then all the extra hours need to be multiplied not by the regular rate, but by the one that is 1.5 times bigger. We join the two data frames on employee ID using inner join. To the result data frame, we add a new column that is called Pay using the withColumn method. When is Spark's version of if/else statement. Else statement in Spark is replaced with 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)