Shiv Singla & Associates Interview Questions and Answers

To find the average of the salaries of 3 students with unknown salaries, add x, y, and z and divide by 3.

• Add the salaries of x, y, and z together

• Divide the total sum by 3 to find the average salary

Sorting and finding max of two numbers in an array using SQL

• Use ORDER BY to sort the array of integers

• Use LIMIT 2 to get the top two numbers

• Use MAX function to find the maximum of the two numbers

Finding the missing element in an array of strings

• Iterate through the array and check for any missing elements

• Use a hash set to keep track of elements that have been seen

• Compare the elements in the array to a reference list of all possible elements

• Example: ['apple', 'banana', 'orange', 'grape'] - missing 'kiwi'

• Example: ['red', 'blue', 'green', 'yellow'] - missing 'purple'

The question is about pronouncing words in a passage.

• Break down the passage into smaller words and syllables to pronounce them correctly.

• Use pronunciation guides or dictionaries to help with difficult words.

• Practice speaking the words out loud to improve pronunciation.

• Ask for feedback from others to ensure correct pronunciation.

• Focus on stress and intonation patterns in sentences for natural sounding speech.

HAVING clause is used in SQL to filter records based on aggregate functions.

• HAVING is used with GROUP BY to filter groups based on a specified condition

• It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

• It is similar to WHERE clause but operates on groups rather than individual rows

Data engineering involves designing, building, and maintaining data pipelines to collect, clean, and transform data for analysis.

• Data engineering focuses on the architecture and infrastructure needed to handle large volumes of data.

• It involves designing and implementing data pipelines to extract, transform, and load data into storage systems.

• Data engineers work with tools like Apache Spark, Hadoop, and SQL databases to process and analyze data efficiently.

• They also collaborat...read more