Ugam Solution Interview Questions, Process, and Tips

Basic aptitude questions

Basic program just printing the stars

Gave a certain topic to discuss

Q1. React based questions
Add your answer

Q1. React based questions
Add your answer

Q1. React based questions
Add your answer

Q1. Basic tech questions are asked
Add your answer
Q2. SQL functions, logic question
Add your answer

Group discussion was on a topic not related to computer science. It was a topic that anyone could speak.

Q1. Explain where clause in sql
Ans. 
WHERE clause is used to filter data in SQL queries.
• WHERE clause is used after the FROM clause in a SQL query.

• It is used to specify a condition that must be met for the query to return data.

• Multiple conditions can be combined using logical operators such as AND and OR.

• Examples: SELECT * FROM customers WHERE age > 18;

• Examples: SELECT * FROM orders WHERE status = 'shipped' AND total_amount > 1000;
Answered by AI
Add your answer
Q2. Explain joins in sql
Ans. 
Joins in SQL are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query

• There are different types of joins such as inner join, left join, right join, and full outer join

• Inner join returns only the matching rows from both tables

• Left join returns all the rows from the left table and matching rows from the right table

• Right join returns a...read more
Answered by AI
Add your answer

Need to 5 SQL questions and need to get atleast 3 questions right

Q1. 2nd highest salary using SQL.
Ans. 
Use SQL query with ORDER BY and LIMIT to find 2nd highest salary.
• Use ORDER BY clause to sort salaries in descending order.

• Use LIMIT 1,1 to skip the highest salary and fetch the second highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1;
Answered by AI
Add your answer
Q2. Case study for a given market
Add your answer

Q1. Difference between HAVING AND WHERE
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows before grouping.
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows before grouping

• HAVING is applied after the GROUP BY clause, WHERE is applied before
Answered by AI
Add your answer