Mphasis Software Testing Engineer Interview Questions and Answers

Reasoning and Coding.




Gj

Q1. What Is Schema And Which schema you used in your project ?
Ans. 
Schema is a blueprint that defines the structure of a database. I used the relational schema in my project.
• Schema is a logical representation of the entire database.

• It defines the tables, fields, relationships, and constraints.

• Relational schema is the most commonly used schema in databases.

• It organizes data into tables with rows and columns.

• Example: Employee table with columns like ID, Name, Age, Salary.
Answered by AI
Add your answer
Q2. What Is The Difference Between SQL & ETL ?
Ans. 
SQL is a language used to manage relational databases, while ETL is a process used to extract, transform, and load data from various sources into a target database.
• SQL is used to manage data within a database, while ETL is used to move data between databases

• SQL is used to query and manipulate data, while ETL is used to transform and load data into a target database

• SQL is a language, while ETL is a process

• Examples of SQ...read more
Answered by AI
Add your answer
Q3. What is agile methodology ?
Ans. 
Agile methodology is an iterative approach to software development that emphasizes flexibility and customer satisfaction.
• Agile focuses on delivering working software in short iterations

• It values collaboration between team members and with customers

• It emphasizes adapting to change rather than following a rigid plan

• Examples of agile methodologies include Scrum, Kanban, and Extreme Programming (XP)
Answered by AI
Add your answer
Q4. What The Statement Of writing A Queries ?
Ans. 
Writing queries involves creating statements to retrieve data from a database.
• Identify the data you want to retrieve

• Choose the appropriate table(s) to query

• Use SQL syntax to construct the query

• Test the query to ensure it returns the desired results
Answered by AI
Add your answer
Q5. How You Upload A Data From Source To Target ?
Ans. 
Data can be uploaded from source to target using ETL tools or manual data entry.
• Extract data from source system

• Transform data to match target system requirements

• Load data into target system

• Use ETL tools like Informatica, Talend, or SSIS

• Manual data entry can be done through UI or APIs
Answered by AI
Add your answer
Q6. What Is Buffer, Where We Use ?
Ans. 
Buffer is a temporary storage area in memory used to hold data while it is being processed or transferred.
• Buffers are used in various applications such as network communication, file I/O, and image processing.

• They help to improve performance by reducing the number of read/write operations to the main memory.

• Examples of buffer include input/output buffer, circular buffer, and double buffer.

• Buffer overflow is a common vu...read more
Answered by AI
Add your answer
Q7. What are The Joins And Constraints ?
Ans. 
Joins and constraints are used in databases to link tables and enforce rules for data integrity.
• Joins are used to combine data from two or more tables based on a related column

• Constraints are rules that are applied to columns to ensure data integrity

• Types of constraints include primary key, foreign key, unique, and check constraints

• Joins can be inner, outer, left, or right depending on the data needed

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

Q1. Share details of your previous job.
Add your answer
Q2. What are your salary expectations?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. Why should we hire you?
Add your answer
Q5. Tell me about yourself.
Add your answer

Average

Q1. 1.Tell me about ur self
Add your answer

Q1. About software testing lifecycle
Add your answer
Q2. What is functional testing & how many types of functional testing
Ans. 
Functional testing is a type of testing that verifies if the software meets the functional requirements.
• It is a black-box testing technique

• It focuses on the external behavior of the software

• It ensures that the software functions as expected

• Types of functional testing include unit testing, integration testing, system testing, acceptance testing, and regression testing
Answered by AI
Add your answer