SELLinALL Interview Questions and Answers

Q1. SQL Questions - Constraints- how to optimize long SQL query without changing the output
Add your answer

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

General aptitude logical reasoning questions

All categories question asking

Simple program asking javascript and data structures

3 DSA questions on array and strings 1 easy, 2 medium level

Create django backend project for book store

Q1. Behaviour and Situations questions
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