SELLinALL Interview Questions and Answers

Sql mcq questions with medium difficulty

Q1. What is inheritance? What are advantages of oops? What's indexing in sql?
Ans. 
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
• Advantages of OOPs include reusability, modularity, and flexibility in code design.

• Indexing in SQL is a way to optimize database queries by creating indexes on columns to improve search performance.
Answered by AI
Add your answer

Q1. What was your previous job role? What methodologies did you follow while working?
Ans. 
I was a Software Developer at XYZ Company. I followed Agile and Scrum methodologies.
• Worked as a Software Developer at XYZ Company

• Followed Agile and Scrum methodologies for project management

• Participated in daily stand-up meetings, sprint planning, and retrospectives
Answered by AI
Add your answer

Q1. What are you leaving your current organization?
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for new challenges and opportunities for professional growth

• Interested in working on different technologies or projects

• Seeking a more collaborative or innovative work environment
Answered by AI
Add your answer

Q1. DSA based Questions- Strings, Stack and Linked List
Add your answer

Q1. DSA and Conceptual Based Question
Add your answer

Basic Js concepts like debouncing,event loop, and other output-based questions.

Q1. Js concepts in depth
Add your answer

Q1. Hiring manager round, questions around my project
Add your answer
Q2. Optimization techniques
Ans. 
Optimization techniques are methods used to improve the efficiency and performance of software applications.
• Use algorithms like greedy, dynamic programming, or divide and conquer to optimize code

• Minimize time complexity by avoiding nested loops and unnecessary iterations

• Utilize data structures like hash tables, arrays, and trees for efficient storage and retrieval

• Profile code to identify bottlenecks and optimize critic...read more
Answered by AI
Add your answer

Q1. Design a paginated list of items, then improve efficiency
Ans. 
Design a paginated list of items and improve efficiency
• Implement lazy loading to fetch data only when needed

• Use caching to store previously fetched data for faster retrieval

• Optimize database queries to reduce load times
Answered by AI
Add your answer

Q1. Basics on Javascript, ReactJS
Add your answer

Q1. It was mostly on scenario based questions and I was asked to code online.
Add your answer

Q1. Discussion were there past projects, how different objectives were done.
Add your answer

Q1. Round 1 was hackerrank test. MCQs and coding questions.
Add your answer
Q2. Kafka related questions.
Add your answer
Q3. Java 8 related questions. Java streams.
Add your answer

Q1. Based on Data Structures- Basic question like strings, stacks and Linked List
Add your answer

Q1. This interview included DSA, Conceptual and Database Questions- It was one level harder than 1st round
Add your answer

Q1. This round was with architect and it was also related to DSA and databse
Add your answer