Jeeva Organic Associate Software Engineer Interview Questions and Answers

2/3 coding questions+technical questions on dbms,os,cn

Q1. Its much about managerial related to project kept in resume and some basic tech questions on skills kept in resume
Add your answer

Q1. Behavioural questions and few questions on project
Add your answer

Q1. Microservices question based on current project
Add your answer
Q2. DSA questions were not asked
Add your answer

Q1. Find distinct without distinct keyword in SQL
Ans. 
Use GROUP BY to find distinct values in SQL without using the DISTINCT keyword.
• Use GROUP BY clause with all columns in the SELECT statement

• This will group the rows with the same values together, effectively giving distinct values
Answered by AI
Add your answer
Q2. Concat 3 columns and handle when null: select concat(a, b, c) from table
Ans. 
Concatenate 3 columns and handle null values in SQL query
• Use CONCAT_WS function to concatenate columns and handle null values

• Provide a separator as the first argument in CONCAT_WS function

• Use IFNULL function to replace null values with a specified value
Answered by AI
Add your answer