Mphasis Technical Dotnet Lead Interview Questions, Process, and Tips

Q1. What is REST Framework
Add your answer
Q2. What are the SQL Queries
Add your answer

This is related to SQL

Q1. Fake Interview, Didn't expect this from virtusa
Add your answer
Q2. FakeInterviews conducted, Didn;t expect this from virtusa
Add your answer
Q3. Virtusa Scammers
Add your answer

Hacker Rank test, problem solving. Java 8

Q1. Java 8 feature related questions.
Add your answer
Q2. Jvm architecture and memory management
Add your answer
Q3. Sql self join query and query tuning
Add your answer
Q4. Spring boot microservices design pattern discussion
Add your answer

Q1. Problem solving based on java and case study
Add your answer
Q2. Team handling and management skills
Add your answer
Q3. Docker and Orchetratetion framework
Add your answer
Q4. Aws cloud and cicd and related technologies
Add your answer

Q1. Design an weather app using android architecture components?
Ans. 
Design a weather app using Android architecture components.
• Use MVVM architecture pattern for separation of concerns

• Implement LiveData for real-time data updates

• Utilize Room database for offline data storage

• Integrate Retrofit for network calls to fetch weather data

• Use ViewModel to manage UI-related data in a lifecycle-conscious way
Answered by AI
Add your answer

Q1. Discussion on projects done
Add your answer

Q1. Tell me about your framework
Ans. 
My framework is a comprehensive set of tools, libraries, and best practices that I use to streamline the development process and ensure high-quality deliverables.
• Utilizes design patterns such as MVC for structuring code

• Includes libraries for common tasks like data manipulation and networking

• Emphasizes unit testing and continuous integration for code quality

• Integrates with popular tools like Git for version control

• Suppo...read more
Answered by AI
Add your answer
Q2. Type of selenium waits
Ans. 
Types of Selenium waits include implicit, explicit, and fluent waits.
• Implicit wait: Waits for a certain amount of time before throwing a NoSuchElementException.

• Explicit wait: Waits for a certain condition to occur before proceeding further.

• Fluent wait: Waits for a condition to be true with a defined polling frequency.

• Example: driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);
Answered by AI
Add your answer
Q3. Xpath and CSS difference
Ans. 
XPath is used to navigate through XML documents, while CSS is used to style HTML elements.
• XPath is more powerful and flexible for navigating XML documents

• CSS is more commonly used for styling HTML elements

• XPath uses path expressions to select nodes in an XML document

• CSS uses selectors to target specific HTML elements
Answered by AI
Add your answer
Q4. Coding to check list
Add your answer

Q1. Questions about Interfaces,, Abstract Classes, Multi-Threading, Parallel Programming concepts, SQL Server
Add your answer

Q1. Questions about Design Patterns, SOLID Principles, Extension Methods, LINQ, Entity Framework
Add your answer

Q1. Questions about current project and my roles and responsibilities, my salary structure, my aspirations whether I want to be Architect or just Team Lead.
Add your answer

Q1. My CTC and ECTC, and asked for negotiation, to which I said yes and accepted the compensation they can offer to me. But still offer letter not released without giving any reason.
Add your answer

Q1. Explaining oops
Ans. 
OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
• OOPs focuses on creating objects that interact with each other to solve complex problems

• Key principles of OOPs include encapsulation, inheritance, and polymorphism

• Encapsulation allows objects to hide their internal state and require all interaction to be performed through an object's methods

• Inhe...read more
Answered by AI
Add your answer
Q2. What design pattern you used
Ans. 
I have used the Singleton design pattern in my previous projects.
• Used to ensure a class has only one instance and provides a global point of access to it

• Helps in managing global resources efficiently

• Example: Database connection manager in a web application
Answered by AI
Add your answer
Q3. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL

• Example: 'ID' column in a 'Users' table
Answered by AI
Add your answer
Q4. What is foreign key
Ans. 
Foreign key is a field in a database table that links to a primary key in another table.
• Foreign key ensures referential integrity between related tables

• It helps maintain relationships between tables

• Foreign key constraints can be used to enforce data integrity
Answered by AI
Add your answer
Q5. What is unique key
Ans. 
A unique key is a field or combination of fields in a database table that uniquely identifies each record in the table.
• A unique key ensures that no two records in a table have the same values for the specified key fields.

• It can be a single field or a combination of multiple fields.

• Unique keys are used to enforce data integrity and prevent duplicate records.

• Examples: Primary key, Unique constraint
Answered by AI
Add your answer
Q6. Different types of dbs
Ans. 
Different types of databases include relational, NoSQL, graph, and document databases.
• Relational databases store data in tables with rows and columns (e.g. MySQL, PostgreSQL)

• NoSQL databases are non-relational and can handle unstructured data (e.g. MongoDB, Cassandra)

• Graph databases use graph structures for semantic queries (e.g. Neo4j, Amazon Neptune)

• Document databases store data in documents (e.g. Couchbase, Firebase)
Answered by AI
Add your answer

Q1. Linux based and scripting SQL query
Add your answer