Blue Yonder Interview Questions and Answers for Experienced

Identify duplicate strings in an array using various methods.

• Use a HashSet to track seen strings. Example: ['apple', 'banana', 'apple'] results in 'apple' as duplicate.

• Sort the array and check adjacent elements. Example: ['apple', 'banana', 'apple'] becomes ['apple', 'apple', 'banana'].

• Use a frequency map (dictionary) to count occurrences. Example: {'apple': 2, 'banana': 1} indicates 'apple' is a duplicate.

Joins in SQL are used to combine rows from two or more tables based on a related column between them.

• Joins are used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

A For loop is used to iterate over a collection of items and perform a set of actions for each item.

• Initialize a counter variable before the loop

• Set the condition for the loop to continue based on the counter variable and the length of the array

• Increment the counter variable after each iteration

• Access each element in the array using the counter variable

Function to calculate factorial of a number

• Create a function that takes an integer as input

• Use a loop to multiply the number by all integers from 1 to the input number

• Return the final result

Test attribute is used to define a test method, while TestCase attribute is used to define a test case class.

• Test attribute is used to mark a method as a test method in a test class.

• TestCase attribute is used to mark a class as a test case class containing multiple test methods.

• Test attribute is used in frameworks like NUnit, JUnit, etc.

• TestCase attribute is used in frameworks like NUnit, JUnit, etc.

NoSQL databases are non-relational databases that do not require a fixed schema, while SQL databases are relational databases that use structured query language.

• NoSQL databases are schema-less, allowing for flexible data models.

• SQL databases use a fixed schema with tables and rows.

• NoSQL databases are horizontally scalable, making them suitable for big data applications.

• SQL databases are vertically scalable, meanin...read more