Mphasis Tech 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

Q1. What difference between testing and automation
Ans. 
Testing is a process of finding defects manually or with tools, while automation is using tools to execute tests automatically.
• Testing involves human intervention, while automation is performed by tools

• Testing is time-consuming and requires human effort, while automation saves time and effort

• Testing can be subjective, while automation is objective and consistent

• Testing can be exploratory, while automation follows prede...read more
Answered by AI
Add your answer
Q2. What uses of selenium with java
Ans. 
Selenium with Java is used for automating web applications for testing purposes.
• Automating repetitive tasks

• Cross-browser testing

• Integration with testing frameworks like TestNG and JUnit

• Headless browser testing

• Parallel testing

• Data-driven testing

• Page Object Model design pattern

• Selenium Grid for distributed testing

• Handling pop-ups and alerts

• Taking screenshots and videos

• Performance testing with Selenium and JMeter
Answered by AI
Add your answer
Q3. What is frameworks and Page object model
Ans. 
Frameworks are pre-defined structures that provide a set of rules and guidelines for software development. Page Object Model is a design pattern used in test automation.
• Frameworks provide a structure for software development, making it easier to organize and maintain code.

• Page Object Model separates the test code from the page-specific code, making it easier to maintain and update tests.

• Examples of frameworks include S...read more
Answered by AI
Add your answer
Q4. Which is based on the manual testing
Add your answer

Online Assessment only i have both aptitude and coding in that part

Q1. Why are you looking for a change?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. How many years of experience?
Add your answer
Q2. What are your hobbies?
Add your answer