LG Soft India 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 is sanity testing
Ans. 
Sanity testing is a subset of regression testing that quickly checks if the major functionalities of the software are working as expected.
• Sanity testing is performed after a software build to ensure its basic functionality is intact.

• It focuses on testing the critical features and functionalities of the software.

• It is a quick and shallow form of testing to determine if further testing is required.

• Sanity testing is not e...read more
Answered by AI
View 1 more answer
Q2. What is automation testing
Ans. 
Automation testing is the use of software tools to execute test cases and compare actual outcomes with expected outcomes.
• Automation testing involves writing scripts or using tools to automate repetitive tasks.

• It helps in reducing human errors and increases efficiency.

• It is used to test software applications, websites, and systems.

• Examples of automation testing tools include Selenium, Appium, and JUnit.
Answered by AI
View 1 more answer
Q3. What is oops concepts
Ans. 
OOPs concepts are the fundamental principles of Object-Oriented Programming that help in designing and implementing software systems.
• Encapsulation: Wrapping data and methods into a single unit

• Inheritance: Acquiring properties and behavior of a parent class

• Polymorphism: Ability of objects to take on multiple forms

• Abstraction: Hiding implementation details and showing only functionality

• Examples: Java, C++, Python, Ruby
Answered by AI
Add your answer
Q4. What is regression testing
Ans. 
Regression testing is the process of testing changes made to a software application to ensure that existing functionality still works.
• It is performed after making changes to the software application

• It ensures that existing functionality is not affected by the changes

• It helps to identify any new defects introduced by the changes

• It can be automated to save time and effort

• Examples include testing after bug fixes, new feat
Answered by AI
Add your answer
Q5. What is access specifier
Ans. 
Access specifier defines the scope of a class member.
• Access specifiers are public, private, and protected.

• Public members can be accessed from anywhere.

• Private members can only be accessed within the class.

• Protected members can be accessed within the class and its subclasses.

• Access specifiers help in encapsulation and data hiding.
Answered by AI
Add your answer
Q6. What is agile methodology
Ans. 
Agile methodology is an iterative approach to software development that emphasizes flexibility and customer satisfaction.
• Agile methodology values individuals and interactions over processes and tools

• It emphasizes working software over comprehensive documentation

• It involves frequent collaboration with customers and stakeholders

• It allows for changes and adjustments to be made throughout the development process

• Examples of...read more
Answered by AI
Add your answer
Q7. What is manual testing
Ans. 
Manual testing is a process of verifying software manually without the use of automation tools.
• It involves executing test cases manually to identify defects

• It requires human intervention to simulate real-world scenarios

• It is time-consuming and requires a lot of effort

• It is useful for testing user interface, usability, and exploratory testing

• Examples include ad-hoc testing, exploratory testing, and regression testing
Answered by AI
Add your answer