Intelliswift - An LTTS Company Interview Questions, Process, and Tips

Q1. How to select event rows from the table using sql query?
Ans. 
To select event rows from a table using SQL query, use the SELECT statement with appropriate conditions.
• Use the SELECT statement to specify the columns you want to retrieve from the table.

• Use the FROM clause to specify the table from which you want to retrieve the rows.

• Use the WHERE clause to specify the conditions that the rows must meet to be selected.

• Example: SELECT * FROM events WHERE event_type = 'concert';
Answered by AI
Add your answer
Q2. What is the SOLID and explain in detail with examples?
Ans. 
SOLID is a set of principles for designing software that is easy to maintain, understand, and extend.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes must be substitutable for their base types.

• I - Interface Segregation Principle: Clients shou...read more
Answered by AI
Add your answer

Python,web development,html,css,js, django

Oriented programming

Q1. Python web development
Add your answer

Python, web development, html, css, js

Q1. Python, web development html css js
Add your answer

Q1. SQL coding questions
Add your answer
Q2. Looker, GCP based questions
Add your answer

Q1. It was a techno-managerial round, where questions were mostly behavioural and some technical questions on GCP, Bigquery.
Add your answer

2 DSA Questions and 40 MCQ including Front end and Backend Technologies

Q1. Basic Java related questions and Oops Concept
Add your answer

Q1. Core Java related questions
Add your answer

Q1. Explain roles and responsibilities of your current project.
Ans. 
The roles and responsibilities of my current project involve developing and maintaining Java applications.
• Developing and implementing Java applications

• Writing clean and efficient code

• Collaborating with cross-functional teams to gather requirements and design solutions

• Troubleshooting and debugging issues

• Performing code reviews and providing feedback

• Participating in agile development processes

• Keeping up-to-date with indu
Answered by AI
Add your answer
Q2. Basic core java questions on list and set.
Add your answer
Q3. Method over loading and overriding.
Ans. 
Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a method in a subclass with the same name and parameters as a method in its superclass.
• Method overloading is used to provide different ways of calling the same method with different parameters.

• Method overriding is used to provide a specific implementation of a method in a subclass that is already defin...read more
Answered by AI
Add your answer
Q4. Internal working of array list, linked list and hash map.
Ans. 
Array list, linked list and hash map are data structures used to store and manipulate data.
• Array list stores data in contiguous memory locations and allows random access to elements.

• Linked list stores data in nodes that are linked to each other and allows efficient insertion and deletion of elements.

• Hash map stores data in key-value pairs and allows fast retrieval of values based on keys.

• Array list and linked list are ...read more
Answered by AI
Add your answer
Q5. Working of REST API. and questions on mapping methods like Post, get etc.
Add your answer

Q1. Basic Angular and javascript question
Add your answer
Q2. Rxjs question and rxjs operators
Add your answer
Q3. NGRX and how you will manage states
Ans. 
NGRX is a state management library for Angular applications that helps manage application state in a reactive way.
• NGRX is based on the Redux pattern, which involves storing the entire application state in a single immutable state tree.

• Actions are dispatched to describe state changes, and reducers specify how the state should change in response to actions.

• Selectors are used to efficiently retrieve specific pieces of sta...read more
Answered by AI
Add your answer
Q4. Core Javascript like promise,callback,hoisting,currying
Add your answer

Q1. Project Discussion
Add your answer