TraviYo Interview Questions and Answers

Manual testing is the process of manually checking software for defects without automation tools.

• Involves human testers executing test cases without automation tools.

• Testers validate functionality, usability, and performance of the application.

• Example: A tester manually checks if a login page accepts valid credentials.

• Focuses on exploratory testing, where testers use their intuition and experience.

• Example: Testing a ne...read more

Jira is a project management tool used for issue tracking and agile project management, primarily in software development.

• Developed by Atlassian, Jira helps teams plan, track, and manage software development projects.

• It allows users to create and manage issues, such as bugs, tasks, and user stories.

• Jira supports agile methodologies like Scrum and Kanban, enabling teams to visualize their workflow.

• Users can customize wo...read more

CRM stands for Customer Relationship Management, a strategy for managing a company's interactions with customers and prospects.

• CRM systems help businesses manage customer data and interactions.

• Examples of CRM software include Salesforce, HubSpot, and Zoho CRM.

• CRM can improve customer service by providing a centralized database of customer information.

• It enables personalized marketing by tracking customer preferences an...read more

Filters in .NET Core are used to intercept HTTP requests and responses.

• Filters are used to add cross-cutting concerns to MVC applications.

• They can be used for authentication, authorization, logging, exception handling, etc.

• Filters can be applied globally, at the controller level, or at the action level.

• Examples of filters include AuthorizeFilter, ExceptionFilter, and ActionFilter.

Dependency injection is a design pattern that allows objects to be loosely coupled and dependencies to be injected at runtime.

• Dependency injection is a way to achieve inversion of control.

• It helps in creating modular and testable code.

• Dependencies are provided to a class through constructor injection, property injection, or method injection.

• It promotes code reusability and maintainability.

• Example: In a .NET Core applic...read more

Transient creates a new instance every time it is requested, Scoped creates a new instance per scope, Singleton creates a single instance for the entire application.

• Transient: Creates a new instance every time it is requested.

• AddScoped: Creates a new instance per scope, such as per HTTP request.

• AddSingleton: Creates a single instance for the entire application.

• Example: Transient can be used for lightweight services tha...read more

Dataset is an in-memory representation of a relational database, while DataReader is a forward-only, read-only stream of data.

• Dataset is a disconnected architecture, while DataReader is a connected architecture.

• Dataset can hold multiple tables and relationships, while DataReader can only hold a single table.

• Dataset can be used for data manipulation and updates, while DataReader is read-only.

• Dataset requires more memory...read more

SQL Join is used to combine rows from two or more tables based on a related column between them.

• Join is used to retrieve data from multiple tables in a single query.

• It helps in avoiding data redundancy and improving query performance.

• Different types of joins include inner join, left join, right join, and full outer join.

• Join conditions are specified using the ON keyword.

• Example: SELECT * FROM table1 JOIN table2 ON tabl...read more

To create a table using MYSQL, use the CREATE TABLE statement followed by the table name and column definitions.

• Use the CREATE TABLE statement to create a new table

• Specify the table name after the CREATE TABLE statement

• Define the columns and their data types within parentheses

• Add any additional constraints or attributes to the columns

• Example: CREATE TABLE employees (id INT, name VARCHAR(50), age INT)