Tesco Intern Interview Questions and Answers

Q1. Based on resume skills
Add your answer
Q2. Based on project done
Add your answer

Basic Gk Questions or current affairs

Q1. Tell me about yourself
Add your answer
Q2. Why do you want to join us?
Add your answer

Two coding questions and aptitude questions

Q1. 1.Normalization and types of normalization?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and dependency.
• Normalization helps in improving data consistency and accuracy.

• Types of normalization include 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF.

• 1NF ensures that each column in a table contains atomic values.

• 2NF eliminates partial dependencies by creating separate tables for related data.

• 3NF eliminates transitive dependencies by creating s...read more
Answered by AI
Add your answer
Q2. 2.SQL queries on grouping and sub queries
Add your answer
Q3. 3.Coding question was asked:Move all positives to one side of list and negative to other side.
Add your answer
Q4. 4.Difference between tuple and list What should we use instead of dictionary when the key have multiple values?
Ans. 
Tuples are immutable and ordered while lists are mutable and unordered. Use a defaultdict instead of a dictionary when the key has multiple values.
• Tuples are defined with parentheses while lists are defined with square brackets.

• Tuples cannot be modified once created while lists can be modified.

• A defaultdict is a subclass of dictionary that provides a default value for a nonexistent key.

• Example: defaultdict(list) can be...read more
Answered by AI
Add your answer

Assignment consisted of verbal non verbal reasoning,DI and coding based questions on topics like SQL,R,python.

Coding test for python and SQL

Q1. Tell about your self
Add your answer
Q2. What about Salary
Add your answer