Turing Data Analyst Intern Interview Questions and Answers

Q1. What is difference between delete,drop and truncate. ?
Ans. 
Delete removes specific rows from a table, drop removes entire table structure, and truncate removes all rows from a table.
• Delete is a DML command, drop is a DDL command, and truncate is a DDL command.

• Delete can be rolled back, drop cannot be rolled back, and truncate cannot be rolled back.

• Delete triggers delete triggers, drop triggers drop triggers, and truncate does not trigger any triggers.

• Example: DELETE FROM table...read more
Answered by AI
Add your answer

Q1. What are iterrators .?
Ans. 
Iterators are objects that allow sequential access to elements in a collection.
• Iterators are used to loop through elements in a collection one at a time.

• They provide a way to access elements without exposing the underlying data structure.

• Iterators have methods like next() to retrieve the next element in the collection.

• Examples of iterators include Python's iter() and Java's Iterator interface.
Answered by AI
Add your answer

SQL and Python basics are the must checkups. My go-to website for preparation was Edureka and Simplilearn.

Q1. Write a python code to check if the given sentence is palindrome or not
Ans. 
Python code to check if a sentence is palindrome or not
• Remove all spaces and convert to lowercase

• Reverse the string and compare with original

• If both are same, then it is a palindrome
Answered by AI
Add your answer
Q2. Write 3 queries for the given circumstances (I can't exactly remember the questions)
Add your answer

Q1. What is Vlookup and Hlookup
Add your answer

Q1. What is difference between delete,drop and truncate. ?
Ans. 
Delete removes specific rows from a table, drop removes entire table structure, and truncate removes all rows from a table.
• Delete is a DML command, drop is a DDL command, and truncate is a DDL command.

• Delete can be rolled back, drop cannot be rolled back, and truncate cannot be rolled back.

• Delete triggers delete triggers, drop triggers drop triggers, and truncate does not trigger any triggers.

• Example: DELETE FROM table...read more
Answered by AI
Add your answer

Q1. What are iterrators .?
Ans. 
Iterators are objects that allow sequential access to elements in a collection.
• Iterators are used to loop through elements in a collection one at a time.

• They provide a way to access elements without exposing the underlying data structure.

• Iterators have methods like next() to retrieve the next element in the collection.

• Examples of iterators include Python's iter() and Java's Iterator interface.
Answered by AI
Add your answer

SQL and Python basics are the must checkups. My go-to website for preparation was Edureka and Simplilearn.

Q1. Write a python code to check if the given sentence is palindrome or not
Ans. 
Python code to check if a sentence is palindrome or not
• Remove all spaces and convert to lowercase

• Reverse the string and compare with original

• If both are same, then it is a palindrome
Answered by AI
Add your answer
Q2. Write 3 queries for the given circumstances (I can't exactly remember the questions)
Add your answer

Haker rank test it was

Q1. Coding questions again
Add your answer

Q1. Ds project related questions
Add your answer