InFynd Interview Questions and Answers

Intermediate questions

Basic sql queries- written

Q1. Difference between delete, truncate, drop
Ans. 
Delete removes specific rows, truncate removes all rows, drop removes entire table.
• Delete is used to remove specific rows from a table based on a condition.

• Truncate removes all rows from a table but keeps the table structure.

• Drop removes the entire table along with its structure and data.

• Delete is slower than truncate and drop as it maintains logs for rollback.

• Truncate is faster than delete as it does not maintain logs...read more
Answered by AI
Add your answer
Q2. 10 keywords in sql
Ans. 
Keywords in SQL are essential for querying databases efficiently.
• SELECT

• FROM

• WHERE

• JOIN

• GROUP BY

• ORDER BY

• HAVING

• INSERT INTO

• UPDATE

• DELETE
Answered by AI
Add your answer

They ask easy aptitude questions

They ask SQL basic questions

Q1. Self intro and they ask about projects
Add your answer
Q2. Technical questions based on thier projects
Add your answer

Time,work and the other aptitude area

10 questions you have to submit the code

Q1. Basic of the topics based on the role
Add your answer
Q2. If you perform well then they will move to intermediate level
Add your answer

Its related to trains problem ,and boat problems etc.. I can' t crack the round

I didn't attend the round