10+ Guild Games Interview Questions and Answers

The angle between the hour hand and minute hand at 3:15 is 7.5 degrees.

• At 3:00, the hour hand is at the 3 o'clock position, which is 90 degrees.

• In 15 minutes, the minute hand moves 90 degrees (360 degrees divided by 4).

• The hour hand also moves slightly in 15 minutes, covering 7.5 degrees (30 degrees divided by 4).

• Therefore, the angle between the hour hand and minute hand at 3:15 is 7.5 degrees.

Factorial code using recursion

• Recursion is a technique where a function calls itself

• Factorial of a number is the product of all positive integers less than or equal to that number

• To calculate factorial using recursion, the base case is when the number is 0 or 1

• The recursive step is to call the factorial function with the number decremented by 1 and multiply it with the number itself

Supply Chain is the process of managing the flow of goods and services from the point of origin to the point of consumption.

• Involves planning, sourcing, producing, delivering, and returning goods and services

• Focuses on efficiency, cost-effectiveness, and customer satisfaction

• Examples include inventory management, transportation logistics, and supplier relationships

The task is to reverse a given string that may contain lowercase letters, uppercase letters, digits, and special characters.

• Iterate through the string from the last character to the first character and append each character to a new string.

• Alternatively, you can use built-in string reversal functions or methods available in your programming language.

• To solve the follow-up question with O(1) space complexity, you can use a two-pointer approach. Swap the characters at the start...read more

Trim is used in SQL to remove leading and trailing spaces from a string.

• Trim function is used to remove leading and trailing spaces from a string

• It is commonly used to clean up data before performing comparisons or concatenations

• Syntax: TRIM([LEADING | TRAILING | BOTH] [characters] FROM [string])

• Example: SELECT TRIM(' hello ') as trimmed_string

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down data into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured manner.

• Normalization ensures data integrity by avoiding update anomalies.

• There are different normal forms such as 1NF, 2NF, 3NF, and BCNF.

• Example: In a database, instead of storing customer details in multiple tables, norm...read more

SQL commands are used to interact with databases and perform various operations.

• SELECT: retrieves data from a database

• INSERT: inserts new data into a database

• UPDATE: modifies existing data in a database

• DELETE: deletes data from a database

• CREATE: creates a new database, table, or view

• ALTER: modifies the structure of a database object

• DROP: deletes a database object

• JOIN: combines rows from two or more tables based on a related column

• GROUP BY: groups rows based on a specified col...read more

OOPS concepts and applications

• OOPS stands for Object-Oriented Programming System

• It is a programming paradigm that uses objects to represent and manipulate data

• Key concepts include encapsulation, inheritance, and polymorphism

• OOPS allows for modular and reusable code

• Examples of OOPS languages include Java, C++, and Python

Fetch data from two tables with a common column without using WHERE keyword.

• Use JOIN keyword to combine the two tables based on the common column.

• Specify the common column in the ON clause of the JOIN statement.

• This will retrieve all the rows where the common column values match in both tables.

SQL query to find and sort students with scores above a threshold

• Use the SELECT statement to retrieve the required data

• Use the WHERE clause to filter students with scores above the threshold

• Use the ORDER BY clause to sort the results by score and then by name

Deep learning in supply chain can optimize operations, improve forecasting accuracy, and enhance decision-making.

• Deep learning can be used in supply chain for demand forecasting, inventory optimization, and route optimization.

• It can help in identifying patterns and trends in data to make more accurate predictions.

• Deep learning models can analyze large volumes of data quickly and efficiently, leading to better decision-making.

• Examples of deep learning applications in supply ch...read more

Machine learning algorithms commonly used in sales prediction include linear regression, decision trees, random forests, and neural networks.

• Linear regression: used to establish a relationship between independent and dependent variables

• Decision trees: used to make decisions based on a series of questions and answers

• Random forests: ensemble method combining multiple decision trees for improved accuracy

• Neural networks: deep learning models that can capture complex patterns in d...read more

o9 solutions offers cutting-edge technology and expertise in supply chain planning and digital transformation.

• o9 solutions provides advanced AI and machine learning capabilities for optimized decision-making.

• Their platform enables real-time visibility and collaboration across the supply chain.

• o9 solutions has a proven track record of successful implementations with global companies like Walmart and Nestle.

Use a hashmap to track duplicates in a list of values

• Iterate through the list and store each value in a hashmap with its count

• Identify values with count greater than 1 as duplicates

• Return the list of values that have duplicates

Cannibalization is the negative impact on sales of a company's own products due to the introduction of a new product.

• Occurs when a new product reduces sales of an existing product within the same company

• Can lead to decreased overall revenue and market share

• Companies must carefully manage product launches to minimize cannibalization

• Example: Apple releasing a new iPhone model that causes a decrease in sales of older iPhone models