Internshala Interview Questions, Process, and Tips

Q1. SQL question difference between having and where
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY to filter groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

• Example: SELECT * FROM employees WHERE department = 'S
Answered by AI
Add your answer

Print odd numbers and even numbers.

Q1. What is ur name
Ans. 
My name is John Smith.
• Full name is John Smith

• Common name in English-speaking countries

• Easy to remember and pronounce
Answered by AI
Add your answer
Q2. Basapuram Thanuja
Add your answer

Q1. Basic interview questions only
Add your answer
Q2. Basic coding questions only
Add your answer
Q3. Besic Oops interview questions
Add your answer
Q4. Basic data type questions
Add your answer
Q5. Basic string coding question
Add your answer

Q1. Introduce Yourself,Write a code to find repeative characters in a String
Ans. 
I am a software engineering student with a passion for coding. Here is a code to find repetitive characters in a string.
• Iterate through the characters in the string and store their occurrences in a HashMap.

• Check the HashMap for characters with occurrences greater than 1 to find repetitive characters.

• Return the repetitive characters as an array of strings.
Answered by AI
Add your answer
Q2. Hi this is my name and qualification and experience
Add your answer

Basic aptitude test, 2 coding questions based on arrays. One was easy other was hard

Q1. Tell me about arrays
Ans. 
Arrays are a data structure that stores a collection of elements of the same data type in contiguous memory locations.
• Arrays have a fixed size determined at the time of declaration.

• Elements in an array are accessed using an index starting from 0.

• Arrays can store primitive data types or objects.

• Example: String[] names = {"Alice", "Bob", "Charlie"};
Answered by AI
Add your answer
Q2. How does a linked list function
Ans. 
A linked list is a data structure where each element points to the next element in the sequence.
• Each element in a linked list, called a node, contains data and a reference to the next node in the sequence.

• Linked lists can be singly linked (each node points to the next node) or doubly linked (each node points to both the next and previous nodes).

• To traverse a linked list, you start at the head node and follow the refere...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a creative and detail-oriented UI/UX designer with a passion for creating user-friendly and visually appealing designs.
• Experienced in creating wireframes, prototypes, and mockups

• Strong understanding of user-centered design principles

• Proficient in Adobe Creative Suite and Sketch

• Excellent communication and collaboration skills

• Passionate about staying updated on industry trends and best practices
Answered by AI
Add your answer
Q2. What is the last experience and what did you learnt?
Ans. 
I recently redesigned a mobile app interface for a local restaurant.
• Conducted user research to understand customer preferences

• Implemented feedback from usability testing to improve design

• Collaborated with developers to ensure smooth implementation
Answered by AI
Add your answer

2 assignments - 1 blog, 1 youtube script

Q1. Past experience, familiarity with content writing, research process, technicality of content writing - seo
Add your answer