Xavient Technologies Module Lead Interview Questions and Answers

Q1. What is .net framework
Ans. 
The .NET Framework is a software framework developed by Microsoft that provides a large library of pre-coded solutions to common programming problems.
• Developed by Microsoft

• Provides a large library of pre-coded solutions

• Supports multiple programming languages

• Used for building applications for Windows, web, mobile, and cloud

• Consists of Common Language Runtime (CLR) and class library
Answered by AI
Add your answer
Q2. What is linq stands for
Ans. 
LINQ stands for Language Integrated Query.
• LINQ is a set of features introduced in .NET Framework that allows for querying data from different data sources using a uniform syntax.

• LINQ can be used to query objects, databases, XML, and more.

• LINQ provides a consistent model for working with data regardless of the data source.

• Example: var query = from c in customers where c.City == 'London' select c;
Answered by AI
Add your answer

Q1. What is clusterindex and nonclusterindex
Ans. 
Clustered index determines the physical order of data in a table, while non-clustered index does not.
• Clustered index physically reorders the table data based on the indexed column

• Non-clustered index creates a separate structure to store the index data

• Clustered index is faster for retrieval but slower for insert and update operations

• Non-clustered index is slower for retrieval but faster for insert and update operations
Answered by AI
Add your answer
Q2. What is difference between union and unionall
Ans. 
UNION combines the result sets of two or more SELECT statements, while UNION ALL does the same but includes duplicate rows.
• UNION removes duplicate rows from the result set, while UNION ALL includes all rows

• UNION is slower than UNION ALL because it performs a distinct operation

• UNION requires that all SELECT statements have the same number of columns with compatible data types

• Example: SELECT column1 FROM table1 UNION SEL...read more
Answered by AI
Add your answer

Q1. What is expected salary
Ans. 
Expected salary should be based on industry standards, experience, skills, and responsibilities of the role.
• Research industry standards for the specific role and location

• Consider your level of experience and skills

• Factor in the responsibilities and expectations of the position

• Be prepared to negotiate based on the company's budget and benefits package
Answered by AI
Add your answer
Q2. Why would you join our company
Ans. 
I would join your company because of its reputation for innovation and growth opportunities.
• Reputation for innovation in the industry

• Opportunities for growth and advancement

• Positive company culture and values

• Exciting projects and challenges to work on
Answered by AI
Add your answer

Q1. Sheetmetal design guide lines
Add your answer

Q1. Salary compensation
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Technical interview round that lasted for about 60 minutes. Questions based on Java and Java Design patterns were asked.

Q1. Java Question
How can you create a Singleton class in Java?
Ans. 
It is two step process,
1. Make the constructor private so that new operator cannot be used to instantiate the class
2. Return an object of the object if not null otherwise create the object and return the same via a method.
Answered by CodingNinjas
View 1 more answer
Q2. Technical Question
When can a Factory Pattern be used ?
Ans. 
1. When a class does not know the class of objects it needs to create, the factory pattern can be utilized.
2. When a class identifies its sub-classes in order to determine which objects should be created, the factory pattern can be utilized. 
3. You can use the factory pattern in programming to construct an object of any of the sub-classes based on the data provided.
Answered by CodingNinjas
Add your answer
Q3. OOPS Question
What is static and Dynamic Binding?
Ans. 
Static or early binding is resolved at compile time. Method overloading is an example of static binding.
Dynamic or late or virtual binding is resolved at run time. Method overriding is an example of dynamic binding.
Answered by CodingNinjas
Add your answer
Q4. Java Question
Difference between Abstract class and Interface
Ans. 
The differences between Abstract Class and Interface are as follows:

Abstract Class:
1) Abstract classes have a default constructor and it is called whenever the concrete subclass is instantiated.
2) It contains Abstract methods as well as Non-Abstract methods.
3) The class which extends the Abstract class shouldn’t require the implementation of all the methods, only Abstract methods need to be implemented in the concrete ...read more
Answered by CodingNinjas
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

Technical interview round that lasted for about 45 minutes. Questions based on SQL, DBMS and Entity Framework were asked.

Q1. Technical Question
What do you mean by SQL injection attack?
Ans. 
SQL injection is a method that hackers use to access sensitive information from an organization's database. This application-layer attack is the result of inappropriate coding in our applications, allowing hackers to inject SQL statements into your SQL code. 
The most common cause of SQL Injection is that user input fields allow SQL statements to pass through and directly query the database. ADO.NET Data Services q...read more
Answered by CodingNinjas
Add your answer
Q2. DBMS Question
What is a weak entity set?
Ans. 
An entity set that doesn't have sufficient attributes to form a primary key is referred to as a weak entity set. The member of a weak entity set is known as a subordinate entity. Weak entity set does not have a primary key, but we need a mean to differentiate among all those entries in the entity set that depend on one particular strong entity set.
Answered by CodingNinjas
Add your answer
Q3. SQL Question
SQL Query to fetch first 5 characters of a string
Add your answer
Q4. DBMS Question
Difference between Clustered and Non-Clustered Index
Ans. 
Clustered index is used for easy retrieval of data from the database by altering the way that the records are stored. Database sorts out rows by the column which is set to be clustered index.

A non-clustered index does not alter the way it was stored but creates a complete separate object within the table. It point back to the original table rows after searching.
Answered by CodingNinjas
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

Technical interview round that lasted for about 45 minutes. Questions based on React js and Web APIs were asked.

Q1. React Question
What are synthetic events in React?
Ans. 
Synthetic events integrate the responses of many native browser events into a single API, ensuring that the events are consistent across browsers. Regardless matter which browser is used to run the program, it remains consistent. preventDefault is a made-up event in this case.
Answered by CodingNinjas
Add your answer
Q2. React Question
Explain the lifecycle methods of components.
Ans. 
1. getInitialState(): This is executed before the creation of the component.
2. componentDidMount(): Is executed when the component gets rendered and placed on the DOM.
3. shouldComponentUpdate(): Is invoked when a component determines changes to the DOM and returns a “true” or “false” value based on certain conditions.
4. componentDidUpdate(): Is invoked immediately after rendering takes place.
5. componentWillUnmount(): ...read more
Answered by CodingNinjas
Add your answer
Q3. Technical Question
What are the main return types supported in Web API?
Ans. 
There is no defined data type for it. Depending on the business requirement, it can return data of any type. Many HTTP methods, such as GET, POST, and PUT, can return data in a variety of forms, depending on the use case.
Answered by CodingNinjas
Add your answer
Q4. Technical Question
What is different between REST API and RESTful API?
Ans. 
1.REST is an architectural pattern used for creating web services. RESTful API is used to implement that pattern.
2. The data format of REST is based on HTTP. The data format of RESTful is based on JSON, HTTP, and Text.
3. Working of URL is based on request and response. Working of RESTful is based on REST applications.
4. REST is more user-friendly and highly adaptable to all business enterprises and IT. RESTful API is t
Answered by CodingNinjas
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round where behavioral questions were asked.

Q1. Basic HR Question
Why do you want to join Mphasis?
Ans. 
Tip 1 : The cross questioning can go intense some time, think before you speak.
Tip 2 : Be open minded and answer whatever you are thinking, in these rounds I feel it is important to have opinion.
Tip 3 : Context of questions can be switched, pay attention to the details. It is okay to ask questions in these round, like what are the projects currently the company is investing, which team you are mentoring. How all is the
Answered by CodingNinjas
Add your answer

Q1. Data structures
Add your answer
Q2. Troubleshooting
Add your answer