TEKsystems Data Engineer Interview Questions and Answers

Q1. Questions on Pyspark
Add your answer
Q2. Questions on SQL
Add your answer
Q3. Transformations
Add your answer
Q4. Questions on Sql optimizations
Add your answer
Q5. Questions About my current Project
Add your answer

Easy questions related to DSA and Python and SQL

Q1. Query to join two table using different joins
Ans. 
Query to join two tables using different joins
• Use INNER JOIN to return rows that have matching values in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer
Q2. Delete and truncate difference
Ans. 
Delete removes rows from a table while truncate removes all rows from a table.
• Delete is a DML command while truncate is a DDL command.

• Delete operation can be rolled back while truncate operation cannot be rolled back.

• Delete operation is slower than truncate operation.

• Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;
Answered by AI
Add your answer

Q1. Easy HR questions related to your previous experience
Add your answer