Internshala Backend Developer Interview Questions and Answers

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

All the logical Qustions

Q1. They will ask you about dsa qustions
Add your answer

Around sql/python and other da tools

Stats and probability with focus on puzzles

Q1. It is related to SQL, Python, and Excel
Add your answer
Q2. Not Remember the interview questions exactly
Add your answer
Q3. What is grouped by in SQL
Ans. 
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
• Data is grouped based on the values in the specified column or expression

• Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group

• GROUP BY is often used in conjunction with the SELECT statement

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department
Answered by AI
Add your answer
Q4. List and dictionary differences
Ans. 
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
• Lists are accessed by index, dictionaries are accessed by key

• Lists maintain the order of elements, dictionaries do not guarantee order

• Lists use square brackets [], dictionaries use curly braces {}

• Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
Answered by AI
Add your answer
Q5. Lambda functions in python
Ans. 
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
• Lambda functions are defined using the lambda keyword.

• They are commonly used for small, one-time tasks.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: add = lambda x, y: x + y
Answered by AI
Add your answer

Coding test of your skills and how well can you cope up with a problem given.

Q1. LAC of 3 nodes
Ans. 
LAC stands for Location Area Code, a unique identifier for a group of cells in a mobile network.
• LAC helps in identifying the location of a mobile device within a cellular network.

• It is used for handover procedures when a device moves between different cells.

• In a network with 3 nodes, each node would have a unique LAC assigned to it.
Answered by AI
Add your answer
Q2. Reverse of the array
Ans. 
Reverse the order of strings in an array
• Use the reverse() method to reverse the array

• Example: ['apple', 'banana', 'cherry'] -> ['cherry', 'banana', 'apple']
Answered by AI
Add your answer
Q3. Sum or product asked
Add your answer

Q1. What are my skills? The clubs I am in? And the tasks I can perform?
Add your answer

Q1. About LinkedIn network
Ans. Must have a decent LinkedIn network
Answered Anonymously
Add your answer
Q2. Testing communication skills
Ans. Should have above average communication skills
Answered Anonymously
Add your answer