Strugence Capital Advisors LLP Interview Questions and Answers

Data is information used by software. Constraints limit data values. Having clause filters data. Subquery is a query within a query.

• Data is information used by software to perform operations

• Constraints limit the values that can be entered into a field

• Types of constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK

• Having clause is used with GROUP BY to filter data based on conditions

• Subquery is a query within a query used to retrieve data for further processing

Types of software testing include functional, non-functional, manual, automated, regression, and performance testing.

• Functional testing checks if the software meets the specified requirements.

• Non-functional testing checks the software's performance, usability, and security.

• Manual testing is done by humans, while automated testing is done by software.

• Regression testing checks if changes to the software have introduced new bugs.

• Performance testing checks the software's speed, s...read more

Oops concepts include inheritance, polymorphism, encapsulation, and abstraction. Locators in testing include ID, class name, xpath, etc. Waits in testing include implicit, explicit, and fluent waits. String manipulation programs involve operations like concatenation, substring, etc.

• Oops concepts: inheritance, polymorphism, encapsulation, abstraction

• Locators: ID, class name, xpath, etc.

• Waits: implicit, explicit, fluent waits

• String manipulation programs: concatenation, substrin...read more

Xpath of elements can be found using browser developer tools or automated testing tools.

• Use browser developer tools like Chrome DevTools to inspect elements and generate Xpath

• Automated testing tools like Selenium WebDriver can also generate Xpath for elements

• Xpath can be based on element attributes like id, class, name, etc.

• Xpath can also use element hierarchy to locate elements

The waterfall model is a sequential software development process where progress flows in one direction, like a waterfall.

• The waterfall model follows a linear and sequential approach to software development.

• Each phase in the waterfall model must be completed before moving on to the next phase.

• Requirements are gathered and documented at the beginning of the project.

• Design, coding, testing, and maintenance are subsequent phases in the waterfall model.

• Changes in requirements are ...read more

Hive structure in Spark is a data warehouse system for querying and analyzing large datasets stored in Hadoop files.

• Hive organizes data into tables, partitions, and buckets.

• Tables in Hive are similar to tables in a relational database.

• Partitions in Hive allow for faster query performance by dividing data into smaller parts based on a specific column.

• Buckets in Hive further optimize query performance by dividing data into more manageable chunks.

• HiveQL is used to query data in ...read more

Testing is the process of evaluating a software application to identify defects and ensure it meets requirements.

• Testing involves executing the software with the intent of finding bugs or verifying that it works as expected

• Types of testing include functional testing, performance testing, security testing, etc.

• Testing can be manual or automated, depending on the needs of the project

• Testers create test cases, execute them, and report any issues found

• Regression testing is done t...read more