Deutschebank Interview Questions (5+ Questions)

We have a server that cannot create new files. When we execute commands like touch command to create an empty file, we get an error saying no space left on device. But when we use DF hyphen H or just DF command, we see that there's a lot of space left on the disc, but we still cannot create new files. The file system has exhausted available iNodes, which means that there are too many small files each containing the metadata. The task asks us to save iNode usage, find which directory contains excessive files and save the problematic directory to this file. First we need to check inode usage. For that we use DF hyphen I, and we can see that inode usage is a hundred percent used by var spool. We use the du command for the disc usage and the inodes flag. We type max depth how many folder levels this command will dig into. We can use find, the name of this directory, and we write type F. We will count how many files we have. The final task will be clean up this directory. Do pseudo RM rf.

We are given a sales table with two columns, amount and sale date. Each row indicates the amount of sales per day within one week. Our main goal is to calculate a seven-day moving average for each date. Moving average means that we calculate that number for each day using the current amount plus the amount of previous days. The challenge here is that for each row, we need to look at other rows, which is not something that where or group by clause can do. A CTE is a temporary result set in SQL that you can reference within a single query. Window function calculates across multiple rows, but it keeps every single row in the result. From sales table, we select sale date and amount columns, and also moving average as a new column. This statement, range between interval six days preceding and current row, simply helps us to define the frame. Using round function for this column, we write double colon that will help us to convert raw data to numeric that we need, and two here will round everything to two decimal places.

How to Calculate the Engagement Rate of Social Media Posts Using SQL

Objective

In this article, we will guide you through creating an SQL query to determine the engagement rate of social media posts. The engagement rate is a crucial metric for understanding how well content performs on soc...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Certainly! Here is a detailed, SEO-friendly explanation for the given interview question.

Retrieve Comprehensive Customer Information with SQL: An Essential Guide

Objective

Develop an SQL query aimed at extracting extensive customer information from the combined_customers table. T...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Detailed Explanation of Interview Question: Calculating Monthly Application-to-Interview and Interview-to-Hire Rates Using SQL

Objective

To tackle this SQL query interview question, you'll be required to compute two key metrics from a job applications table: the application-to-interview ra...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →