ROOTS LIFE SCIENCES Interview Questions and Answers

Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.

• Inner join only includes rows with matching values in both tables

• Outer join includes all rows from both tables, even if there are no matching values

• Types of outer joins include left outer join, right outer join, and full outer join

Testing process life cycle involves planning, designing, executing, and reporting. Challenges include lack of resources, time constraints, and changing requirements.

• Testing process life cycle includes planning, designing, executing, and reporting

• Challenges faced include lack of resources, time constraints, and changing requirements

• Planning involves identifying test objectives, test scenarios, and test cases

• Designing involves creating test data and test environment

• Executing in...read more

To test an ATM machine, I would perform functional, security, and usability testing to ensure it operates correctly and securely.

• Test the functionality of withdrawing cash, depositing cash, checking balance, transferring funds, etc.

• Perform security testing to check for vulnerabilities such as card skimming, unauthorized access, etc.

• Conduct usability testing to ensure the interface is user-friendly and intuitive for customers.

• Test error handling scenarios such as entering inco...read more

I have previously used MySQL and MongoDB databases.

• MySQL was used for relational database management system.

• MongoDB was used for NoSQL database management system.

Sanity testing is a quick and shallow testing to ensure the basic functionality of the application is working.

• Identify the critical functionalities of the application

• Execute a set of predefined test cases to ensure the basic functionality is working

• Verify the application is stable and can handle normal inputs

• Ensure the application is ready for further testing

• Examples: login functionality, basic navigation, data display