Shanno Corporate Solutions Lead Consultant Interview Questions and Answers

Q1. What are SQL joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them

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

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right ...read more
Answered by AI
Add your answer
Q2. What are the different window functions?
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions include ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and more

• They allow for calculations to be performed on a specific subset of rows within a query result set

• Window functions are commonly used in analytical queries to calculate running totals, moving averages, and more
Answered by AI
Add your answer

Q1. How will you identify the given two strings as anagram?
Ans. 
Anagrams are two strings that have the same characters in a different order.
• Check if the two strings have the same length.

• Sort the characters in both strings and compare if they are equal.

• Alternatively, count the frequency of characters in both strings and compare the counts.
Answered by AI
Add your answer
Q2. From a table with employee details and another table with order details, count the employees who ordered all the category items.
Add your answer

Q1. 1.) Introduce yourself
Add your answer
Q2. 2.) Three projects in current organization
Add your answer
Q3. 4.) Way to improve productivity.
Ans. 
Improving productivity can be achieved through effective time management, prioritization, delegation, and automation.
• Create a to-do list and prioritize tasks based on importance and urgency

• Delegate tasks to team members who are capable and available

• Automate repetitive tasks using technology

• Take breaks and avoid multitasking to maintain focus and energy

• Set realistic goals and deadlines

• Eliminate distractions and interrup...read more
Answered by AI
Add your answer
Q4. 3.) Different types of time like cycle time Takt time etc
Ans. 
Cycle time and Takt time are two types of time used in manufacturing processes.
• Cycle time is the time it takes to complete one cycle of a process or operation.

• Takt time is the rate at which a product must be produced in order to meet customer demand.

• Cycle time can be used to identify bottlenecks and inefficiencies in a process.

• Takt time can be used to set production goals and improve efficiency.

• Other types of time used...read more
Answered by AI
Add your answer
Q5. 5.) Detail explanation of Inventory management.
Ans. 
Inventory management is the process of overseeing and controlling the flow of goods from manufacturers to warehouses and from these facilities to point of sale.
• Inventory management involves tracking inventory levels, ordering and receiving goods, and managing stock levels to ensure optimal levels of inventory.

• Effective inventory management can help reduce costs, prevent stockouts, and improve customer satisfaction.

• Inve...read more
Answered by AI
Add your answer

Q1. Core Java OOPS Multithreading..
Add your answer
Q2. Codding question for collection like Array list and LinkedList
Add your answer

Q1. Spring related question like annotation POM file, ....
Add your answer
Q2. Cloud related experience/question
Add your answer

Q1. Previous experience question like project experience...
Add your answer

Q1. Write a program to print a pattern.
Add your answer
Q2. Wite a program to check fibonaaci.
Add your answer
Q3. Write a program to find a subarray
Add your answer

Mostly puzzles with some aptitude question

Pharma case study with multiple sql questions

Q1. Tell me something about you
Add your answer
Q2. Guesstimate
Add your answer

Q1. Total years of experience
Add your answer
Q2. Major work exposure
Add your answer

Q1. Explain the assignment done in the last year
Add your answer
Q2. Give some of the major observations of p2p along with financial impact
Add your answer
Q3. 5 points to consider while drafting standard of operating procedures
Add your answer

Q1. What are SQL joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them

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

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right ...read more
Answered by AI
Add your answer
Q2. What are the different window functions?
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions include ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and more

• They allow for calculations to be performed on a specific subset of rows within a query result set

• Window functions are commonly used in analytical queries to calculate running totals, moving averages, and more
Answered by AI
Add your answer

Q1. How will you identify the given two strings as anagram?
Ans. 
Anagrams are two strings that have the same characters in a different order.
• Check if the two strings have the same length.

• Sort the characters in both strings and compare if they are equal.

• Alternatively, count the frequency of characters in both strings and compare the counts.
Answered by AI
Add your answer
Q2. From a table with employee details and another table with order details, count the employees who ordered all the category items.
Add your answer