EbixCash Limited Software Engineer Interview Questions, Process, and Tips

The coding test consists of multiple-choice questions and one medium-hard level coding question.

Q1. Given three jugs with different capacities and no measuring tools, how can you measure out a specific amount of water using the jugs you have?
Add your answer
Q2. What is the angle between the minute and hour hand of a clock at 3:45?
Ans. 
The angle between the minute and hour hand of a clock at 3:45 is 157.5 degrees.
• Calculate the angle formed by the hour hand from 12 o'clock position to 3:45 position (135 degrees)

• Calculate the angle formed by the minute hand from 12 o'clock position to 3:45 position (22.5 degrees)

• Subtract the smaller angle from the larger angle to get the angle between the two hands (157.5 degrees)
Answered by AI
Add your answer
Q3. What is indexing in Database Management Systems (DBMS)?
Ans. 
Indexing in DBMS is a technique used to improve the performance of queries by allowing faster retrieval of data.
• Indexes are data structures that store a small portion of the data set in an easily searchable format.

• They help in speeding up the data retrieval process by reducing the number of disk accesses needed.

• Indexes can be created on one or more columns of a table to improve the performance of SELECT queries.

• Example...read more
Answered by AI
Add your answer
Q4. What is the lifecycle of a React component?
Ans. 
The lifecycle of a React component includes mounting, updating, and unmounting phases.
• Mounting phase: constructor, render, componentDidMount

• Updating phase: shouldComponentUpdate, render, componentDidUpdate

• Unmounting phase: componentWillUnmount
Answered by AI
Add your answer
Q5. How you delete entry in mongodb database
Ans. 
To delete an entry in MongoDB database, you can use the deleteOne() or deleteMany() methods.
• Use deleteOne() method to delete a single document based on a specific condition

• Use deleteMany() method to delete multiple documents based on a specific condition

• Make sure to specify the filter criteria to accurately delete the desired entry
Answered by AI
Add your answer

Q1. Asked java coding and system design
Add your answer
Q2. Facebook and parking lot
Add your answer
Q3. Java 8 stream and lambda
Add your answer

Q1. LRU Cache question and couple on array
Add your answer

Q1. System Design question related to Lift
Add your answer

Q1. Managerial, project related and SQL
Add your answer

Q1. Will you be able to work in Rotational Shifts?
Add your answer
Q2. How much experience do you have in SQL and Node JS.
Ans. 
I have 5 years of experience in SQL and Node JS.
• I have worked extensively with SQL databases, writing complex queries and optimizing performance.

• I am proficient in using Node JS for server-side development, building RESTful APIs and handling database operations.

• I have experience in integrating SQL databases with Node JS applications using libraries like Sequelize or Knex.

• I have successfully delivered projects that invo...read more
Answered by AI
Add your answer

Q1. What is Index in SQL?
Ans. 
Indexes in SQL are data structures that improve the speed of data retrieval operations on database tables.
• Indexes are created on one or more columns of a table to allow faster searching and sorting of data.

• They work similar to the index of a book, allowing the database engine to quickly locate the data.

• Indexes can be created on primary keys, foreign keys, or any other frequently searched columns.

• They reduce the amount ...read more
Answered by AI
Add your answer
Q2. What are the different types of Normalization in DBMS?
Ans. 
Normalization is a process in DBMS that eliminates data redundancy and ensures data integrity.
• Normalization is used to organize data in a database efficiently.

• There are different normal forms, such as 1NF, 2NF, 3NF, BCNF, and 4NF.

• Each normal form has specific rules and dependencies to achieve data normalization.

• Normalization helps in reducing data duplication, improving data consistency, and simplifying database mainte...read more
Answered by AI
Add your answer
Q3. What do you know about Views in mySQL?
Ans. 
Views in mySQL are virtual tables that are based on the result of a query. They can be used to simplify complex queries and provide a layer of abstraction.
• Views are created using the CREATE VIEW statement.

• They are stored in the database and can be accessed like regular tables.

• Views can be used to hide complexity by encapsulating complex queries into a single view.

• They can also be used to restrict access to certain colu...read more
Answered by AI
Add your answer
Q4. What are Stored Procedures?
Ans. 
Stored Procedures are precompiled database objects that contain a set of SQL statements and can be executed with a single call.
• Stored Procedures are used to encapsulate and execute frequently used SQL statements.

• They improve performance by reducing network traffic and optimizing query execution.

• They can accept input parameters and return output values.

• Stored Procedures can be used for data manipulation, data retrieval,...read more
Answered by AI
Add your answer
Q5. Tell me something about Internet of Things.
Ans. 
Internet of Things (IoT) refers to the network of physical devices, vehicles, appliances, and other objects embedded with sensors, software, and connectivity.
• IoT enables devices to collect and exchange data over the internet.

• It allows for remote monitoring and control of devices and systems.

• IoT has applications in various industries such as healthcare, transportation, agriculture, and smart homes.

• Examples of IoT device...read more
Answered by AI
Add your answer

Q1. Questions about Past Experience, the projects I have worked on.
Add your answer
Q2. What does JWT stand for? How do we use them?
Ans. 
JWT stands for JSON Web Token. It is a compact, URL-safe means of representing claims between two parties.
• JWT is used for authentication and authorization purposes in web applications.

• It consists of three parts: header, payload, and signature.

• The header contains the algorithm used to sign the token.

• The payload contains the claims or information about the user.

• The signature is used to verify the integrity of the token.

• J...read more
Answered by AI
Add your answer
Q3. What is the difference between Webtokens and APIs?
Ans. 
Webtokens and APIs are both used in web development, but they serve different purposes.
• Webtokens are used for authentication and authorization, providing a secure way to transmit user information between client and server.

• APIs (Application Programming Interfaces) are sets of rules and protocols that allow different software applications to communicate and interact with each other.

• Webtokens are often used within APIs to...read more
Answered by AI
Add your answer
Q4. What is oAuth, what method did you use for Authentication/ Authorisation is your project?
Ans. 
oAuth is an open standard for authorization. In my project, I used the oAuth 2.0 protocol for authentication and authorization.
• oAuth is a protocol that allows users to grant limited access to their resources on one website to another website without sharing their credentials.

• It provides a secure way for users to authenticate and authorize third-party applications to access their data.

• oAuth 2.0 is the most widely used v...read more
Answered by AI
Add your answer
Q5. If the data in a table is already normalized, what can we do to further optimize is?
Ans. 
Further optimization of normalized data can be achieved through indexing, denormalization, and caching.
• Create appropriate indexes on frequently queried columns to improve query performance.

• Consider denormalizing the data by combining related tables to reduce the number of joins required.

• Implement caching mechanisms to store frequently accessed data in memory for faster retrieval.

• Use materialized views or summary tables...read more
Answered by AI
Add your answer
Q6. How do you perform indexing in a database, which column you use for indexing?
Ans. 
Indexing in a database improves query performance by creating a data structure that allows for faster data retrieval.
• Indexing involves creating an index on one or more columns of a database table.

• The column used for indexing should be chosen based on the frequency of data retrieval and the cardinality of the column.

• Columns with high selectivity and frequent data retrieval are good candidates for indexing.

• Examples of co...read more
Answered by AI
Add your answer