Genpact SQL Developer Interview Questions and Answers

Q1. How to insert multiple values in one go
Ans. 
Use the INSERT INTO statement with multiple value sets separated by commas
• Use the INSERT INTO statement followed by the table name

• List the column names in parentheses after the table name

• Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas

• Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
Answered by AI
Add your answer
Q2. Update query using joins
Ans. 
Update query using joins in SQL
• Use UPDATE statement with JOIN clause to update data in multiple tables

• Specify the tables to be updated and joined using ON clause

• Set the columns to be updated in SET clause
Answered by AI
Add your answer

Q1. What is correlated subquery?
Ans. 
Correlated subquery is a subquery that references a column from the outer query.
• Correlated subqueries are executed for each row processed by the outer query.

• They can be used to filter results based on values from the outer query.

• Example: SELECT * FROM table1 t1 WHERE t1.column1 = (SELECT MAX(column2) FROM table2 t2 WHERE t2.column3 = t1.column3)
Answered by AI
Add your answer

Any way ask for questions

Java platform coding test

Q1. Interview was quite easy, they asked everything which was mentioned in my resume but it was mainly focused on sql basic questions like joins, union,dml, ddl commands . They hire me as a sql developer but...read more
Add your answer
Q2. Joins, dml commands
Add your answer