Indianic Senior Software Engineer Interview Questions and Answers

Q1. Basic java and rest full API, multithreading and stream
Add your answer

Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
Ans. 
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
• Indexes are used to speed up data retrieval operations in a database.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are generally ...read more
Answered by AI
Add your answer
Q2. Write a query to delete duplicate rows from a table.
Ans. 
Query to delete duplicate rows from a table
• Use GROUP BY clause to group the rows by their unique values

• Use HAVING clause to filter out the groups with count greater than 1

• Use DELETE statement to delete the duplicate rows
Answered by AI
Add your answer
Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
Add your answer
Q4. What is a singleton pattern and how to implement it?
Ans. 
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
• Create a private constructor to restrict instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety if necessary

• Examples: Database connection, Logger, Configuration settings
Answered by AI
Add your answer
Q5. How do you handle exceptions in stored procedures?
Ans. 
Handle exceptions in stored procedures by using TRY-CATCH blocks.
• Use TRY-CATCH blocks to catch and handle exceptions

• Log the error message and severity level

• Rollback the transaction if necessary

• Rethrow the error if it cannot be handled

• Use RAISERROR to raise custom error messages
Answered by AI
Add your answer
Q6. Explain SOLID principles.
Ans. 
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
• 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 should be substitutable for their base types.

• I - Interface Segregation Principle: C...read more
Answered by AI
Add your answer
Q7. Difference between throw and throw exception?
Ans. 
throw is used to throw an exception while throw exception is used to throw a specific exception.
• throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

• throw exception is followed by the type of exception that needs to be thrown.

• throw can be used to throw any object while throw exception can only be used to throw an exception object.

• Example: throw new Exception("
Answered by AI
Add your answer

Q1. What is Difference between let var const,
Ans. 
let, var, and const are all used to declare variables in JavaScript, but they have different scoping rules and behaviors.
• let and const were introduced in ES6, while var has been around since the beginning of JavaScript.

• let and const are block-scoped, while var is function-scoped.

• Variables declared with const cannot be reassigned, while let and var can be.

• const variables must be initialized when they are declared, while...read more
Answered by AI
Add your answer
Q2. Sql and Mongo related questions such as fetch 3rd highest salary from employee table?
Add your answer
Q3. What are the scope in javascript, describe each one.
Ans. 
Scopes in JavaScript determine the accessibility of variables and functions.
• Global scope: variables and functions declared outside any function are accessible globally

• Local scope: variables and functions declared inside a function are only accessible within that function

• Block scope: variables declared with let and const are only accessible within the block they are declared in

• Function scope: variables declared with var...read more
Answered by AI
Add your answer
Q4. What is callback hell, what is Promises?
Ans. 
Callback hell is a situation where nested callbacks make code unreadable. Promises are a solution to this problem.
• Callback hell occurs when there are too many nested callbacks in asynchronous code

• It makes the code difficult to read and maintain

• Promises are a way to handle asynchronous operations without nested callbacks

• Promises can be used to chain multiple asynchronous operations together

• Promises have a resolve and re...read more
Answered by AI
Add your answer
Q5. What is express js and why it is used in web apps and what is body parser
Ans. 
Express.js is a popular Node.js web framework used for building web applications. Body-parser is a middleware used to parse incoming request bodies.
• Express.js is a minimal and flexible Node.js web application framework that provides a robust set of features for web and mobile applications.

• It provides a way to handle HTTP requests and responses, routing, middleware, and more.

• Body-parser is a middleware used to parse inc...read more
Answered by AI
Add your answer
Q6. What are arrow functions
Ans. 
Arrow functions are a concise way to write functions in JavaScript.
• They have a shorter syntax than traditional function expressions.

• They do not have their own 'this' keyword.

• They are not suitable for methods, constructors, or prototype methods.

• Example: const add = (a, b) => a + b;

• Example: const square = x => x * x;
Answered by AI
Add your answer
Q7. What is nodejs and difference between nodejs and javascript
Ans. 
Node.js is a server-side JavaScript runtime environment.
• Node.js is built on top of the V8 JavaScript engine from Google Chrome.

• It allows developers to write server-side code in JavaScript.

• Node.js has a non-blocking I/O model, making it efficient for handling large amounts of data.

• Node.js has a vast library of modules available through npm (Node Package Manager).
Answered by AI
View 1 more answer
Q8. What is passport.js why it is used
Ans. 
Passport.js is an authentication middleware for Node.js.
• Passport.js provides a simple way to authenticate users with various authentication strategies such as local, OAuth, OpenID, etc.

• It is highly customizable and can be integrated with any Node.js web application framework.

• Passport.js maintains user sessions and provides a consistent API for authentication across different strategies.

• Example: Using Passport.js with E...read more
Answered by AI
Add your answer
Q9. Difference between node and expressjs
Ans. 
Node is a runtime environment for executing JavaScript code, while Express is a web application framework built on top of Node.
• Node provides the platform for running JavaScript code outside of a web browser

• Express is a lightweight framework that simplifies building web applications on top of Node

• Express provides features like routing, middleware, and templating that make it easier to build web applications

• Node and Expr...read more
Answered by AI
Add your answer
Q10. Why nodejs is single Threaded
Ans. 
Node.js is single-threaded to optimize performance and simplify programming.
• Node.js uses an event-driven, non-blocking I/O model.

• This allows for efficient handling of multiple requests without creating new threads.

• Node.js also uses a single event loop to manage all I/O operations.

• This simplifies programming by eliminating the need for complex thread synchronization.

• However, Node.js can still take advantage of multi-cor
Answered by AI
Add your answer

Q1. A small data structures problem was given to solve
Add your answer
Q2. A small web api asked to build which includes crud operations
Add your answer
Q3. Question related to system design
Add your answer
Q4. What is Function hoisting
Ans. 
Function hoisting is a JavaScript behavior where function declarations are moved to the top of their scope.
• Function declarations are moved to the top of their scope during the compilation phase.

• Function expressions are not hoisted.

• Hoisting can lead to unexpected behavior and bugs if not understood properly.
Answered by AI
Add your answer
Q5. What is event loops and phases
Ans. 
Event loop is a mechanism that allows JavaScript to perform non-blocking I/O operations.
• Event loop is a loop that constantly checks the message queue and executes the next message if there is any.

• Phases are the different stages of the event loop, such as timers, I/O callbacks, idle, and poll.

• Event loop is crucial for Node.js to handle multiple requests simultaneously without blocking the main thread.

• Example: setTimeout...read more
Answered by AI
Add your answer

Q1. Few questions on Basic of react JS, Hooks, basic JS like temporal dead zone, scope
Add your answer
Q2. Questions on GIT and GIT HUB, Merges, Commits, Squash
Add your answer
Q3. Scrum related questions
Add your answer

Aptitude + Coding Test

Q1. What are Services in Angular? How to Provide Services in Angular? Scenario Based Questions
Add your answer

Q1. Mainly Scenario based questions. How to get element in Typescript in Angular. How to pass data between two web components? How Web workers work?
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. What are your salary expectations?
Add your answer

Q1. 1st round-Hacker rank test, there will be MCQ type questions and 2 programs
Add your answer
Q2. 2nd round- Technical round
Add your answer
Q3. PDM round-managerial discussion
Add your answer
Q4. Hr round-Salary discussion
Add your answer

Q1. What are your strengths and weakness in the Testing domain?
Ans. It is a subjective question where the expectation is to showcase the experience the candidate has in different domains and with different technologies they have worked on. The answer should clearly reflect the accomplishments and challenges faced during the entire career path.
Answered by nimesh gupta
Add your answer
Q2. Explain the complex test scenario automated by you in your career
Ans. 
Automated testing of a complex financial transaction system with multiple user roles and permissions
• Created automated test scripts using Selenium to simulate different user roles accessing the system

• Tested various scenarios such as fund transfers, account creation, and transaction history

• Implemented data-driven testing to validate different input combinations and edge cases

• Used API testing tools like Postman to verify ...read more
Answered by AI
Add your answer