X Interview Questions (8+ Questions)

We have multiple applications that write their logs under var slash log. An issue with this approach is that since multiple logs file are constantly being written to this folder, checking them one by one would be slow and inefficient. We want to use this file to consolidate all the lines that contain errors and write them here. We can use grep and we'll use recursive flag to get error lines in var slash log folder, and it will include only files that are in dot log extension. What we left to do is send this into the consolidated error logs file.

We have a web scraper service that runs in systemd and we get an error indicating that connections cannot be established even though everything is fine with our server, services accessible and network is fine. Connection three zeros means that we cannot allocate the port and this could happen because of port exhaustion. Port exhaustion happens when we have a certain range of ports on our machine and every time we make an outbound connection, we need that port. And that port usually becomes blocked for 60 seconds and cannot be reused. When we have more connections within 60 seconds than we have allocated port pool, we will get this kind of error. To confirm this, we can run SS, so it's TCP all numbers state time wait, and we can count lines with WC line. In order to fix this problem, we'll use kernel time wait reuse flag. We'll use sysctl net IPV four ip local port range. This gives us the range of ports that we currently have available on our machine. The reuse status is zero. In order to fix this, we need to use reuse one.

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.

We have one table that is called assignments. Each row represents one employee assigned to one project with start date and end date. We need to find those employees who are assigned to multiple projects at the same time, or in other words, who face an overlap. The final result must contain all the columns from the input and sort it out by project ID primarily, and then by employee ID in ascending order. Two date ranges overlap when they share at least one day in common. We need to compare each assignment to another one for the same employee, which basically means that we reference the same table twice. This means that we'll use self join here. We take assignments table and give it alias a1. Then we join it with a2 copy that will search for overlapping assignments. The first condition is that assignment a1 must start before or on the same day that assignment a2 ends, because if a1 starts after a2 already ended, no overlap is possible. The role of distinct function here is removing those duplicates and making sure that each assignment appears only once in the final result.

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 →