InFynd Data Engineer Intern 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