Categories: Code Problem / Data Structures and Algorithms / Recursion (32) Code Problem / Data Structures and Algorithms / Binary Search (30) Code Problem / Data Structures and Algorithms / Linked Lists (26) Code Problem / Data Structures and Algorithms / Backtracking (26) Code Problem / Data Structures and Algorithms / Stacks and Queues (25) Code Problem / Data Structures and Algorithms / Hashing (24) Databases / SQL / Backup and Recovery (19) Code Problem / Data Structures and Algorithms / Arrays and Strings (19) Databases / SQL / Database Normalization (18) Code Problem / Data Structures and Algorithms / Time Complexity (17) Databases / SQL / Locking (16) Databases / SQL / Replication (15) Databases / SQL / SQL Queries (13) Code Problem / Data Structures and Algorithms / Graphs (13) Databases / SQL / Database Security (13)  More...

Recent solutions:

Check these solutions from our community:
Python / Web Development DifficultyMedium Python
This problem deals with finding the sum of all integers in a list that are greater than or equal to 10. An example input and output are provided.
About this solution: The candidate's solution correctly solves the problem. They iterate through the list, checking if each integer is greater than or equal to 10. If it is, they add it to the sum. This is a solid approach.
Jan 27
Databases / SQL DifficultyHard SQL
To replicate a database across multiple servers, you would need to set up a master server with the database, and then set up replication on the other servers. This would allow the other servers to have copies of the database, which would be updated whenever the master server's database is updated.
About this solution: The candidate's solution is incomplete. It does not address how to keep the databases in sync or how to handle write conflicts. Additionally, the candidate does not mention any performance implications of this solution.
Jan 27
Python / Exception handling DifficultyMedium Python
This Python code snippet returns the sum of integers that are greater than or equal to 10 in a list.
About this solution: The candidate's solution correctly solves the problem. They iterate through the list, checking if each integer is greater than or equal to 10. If it is, they add it to the sum. This is a solid approach that would work well for this problem.
Jan 27
Python / REST APIs DifficultyMedium Python
Given a list of integers, this Python function will find the sum of the even numbers in the list.
About this solution: This solution correctly finds the sum of all even numbers in the given list. It uses a simple for loop to iterate through the list, checking if each number is divisible by 2 (i.e. is even), and if so, adding it to the running total. This is a straightforward and effective solution.
Jan 27
Databases / SQL DifficultyHard SQL
Update customer credit score on address update: - Given a table of customer data with name, address, credit score, and date of last address update columns, - write a trigger that will automatically update the customer's credit score whenever their address is updated. - Output will be the customer table with updated credit scores.
About this solution: The trigger above will update the credit score of the customer whenever their address is updated. This is a good solution that solves the problem. The trigger is optimal because it will only update the credit score of the customer whose address was updated.
Jan 27
Databases / SQL SQL
Write a SQL query to find the names of the two highest scoring individuals in a table of data.
About this solution: The candidate's solution is correct and demonstrates a good understanding of SQL.
Jan 27
Databases / SQL SQL
Write a SQL query that returns the top 10 customers by total spent.
About this solution: This solution is correct and demonstrates a level of completeness. The approach is straightforward and easy to follow.
Jan 21
Databases / SQL SQL
This technical problem involves writing a SQL query that returns the total revenue for each customer. The table schema is provided, and an example input and output are also given.
About this solution: This solution is complete and solves the problem. The approach is straightforward and easy to follow.
Jan 21