X Interview Questions (8+ Questions)

Learn how to recursively search all log files for error messages using Linux Bash commands. This guide covers finding .log files across directory trees, extracting lines containing specific keywords, and displaying results with filenames, essential for rapid incident investigation, log analysis, and identifying system problems across multiple services.

Diagnose and fix 'Cannot assign requested address' connection failures caused by ephemeral port exhaustion in Linux. Learn how to identify TIME_WAIT socket accumulation, check available ephemeral port ranges, and enable the tcp_tw_reuse kernel parameter to safely reuse TIME_WAIT ports for outbound connections. This guide covers using ss and netstat to monitor socket states, modifying kernel parameters with sysctl, and testing high-volume connection scenarios. Essential for troubleshooting web scrapers, API gateways, and microservices experiencing connection failures during peak traffic.

Handle merge conflicts by manually combining changes from both branches. Resolve conflicts in app.js by keeping both processData and validateInput functions, complete the merge with a commit, and maintain all work from both team members. Essential for team collaboration, preventing code loss during merges, combining parallel development efforts, and maintaining code quality during integration.

Objective

To write a SQL query that identifies all project assignments where an employee is allocated to multiple projects with overlapping timeframes. The result should include the project ID, employee ID, start date, and end date of each such assignment. Ensure that the output is ordered by project ID and employee ID.

Additional Information

• You are provided with a table named assignments with the following columns:

  • project_id (INTEGER): The unique identifier for each project.
  • employee_id (INTEGER): The unique identifier for each employee.
  • start_date (DATE): The start date of the employee's assignment to the project.
  • end_date (DATE): The end date of the employee's assignment to the project.

• An employee has overlapping assignments if they are assigned to different projects where the date ranges intersect. Specifically, two assignments overlap if:

  • The projects are different (project_id differs).
  • The start date of one assignment is on or before the end date of the other assignment.
  • The end date of one assignment is on or after the start date of the other assignment.

• The query should return distinct records without duplicates.

• Order the final result set first by project_id in ascending order and then by employee_id in ascending order.

• Assume that all dates are valid and start_date is always on or before end_date for each assignment.

SQL Query

SELECT DISTINCT a1.project_id, a1.employee_id, a1.start_date, a1.end_date
FROM assignments a1
JOIN assignments a2 
ON a1.employee_id = a2.employee_id
AND a1.project_id <> a2.project_id
AND a1.start_date <= a2.end_date
AND a1.end_date >= a2.start_date
ORDER BY a1.project_id, a1.employee_id;

This SQL query is designed to find all instances where an employee is involved in overlapping project assignments and returns the necessary fields in an ordered format.

Interview Question: Generate a Summary of Orders by Category

Objective:
You are provided with a table named orders that contains the following columns:

• id: an integer representing the unique identifier for each order.
• category: a string indicating the category of the order.
• amount...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Crafting the Perfect SQL Query to Categorize and Sort Orders

Objective

Your task is to write a powerful SQL query that categorizes orders based on their total amount and sorts them in descending order. We'll label orders with a total amount greater than 1000 as 'Large' and those with a tot...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Objective

Write an SQL query to determine the number of customers residing in each city. The result should list each city alongside the corresponding count of customers, sorted in descending order based on the customer count.

Additional Information

• The customers table includes the fol...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Master JavaScript alert handling with Selenium. Learn to automate alert, confirm, and prompt dialogs with proper wait strategies....

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →