TraviYo Interview Questions, Process, and Tips

Q1. Sql question and all join
Add your answer
Q2. C# and ado.net or mvc
Add your answer

Q1. Regressin, sanity, functional, unit
Add your answer
Q2. Same as firste one
Add your answer

Q1. What is filter in dot net core
Ans. 
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.
Answered by AI
Add your answer
Q2. What is dependency injection
Ans. 
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
Answered by AI
Add your answer
Q3. Different between Transient,Add Scope and AddSingleton
Ans. 
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
Answered by AI
Add your answer
Q4. Difference between dataset and datareader
Ans. 
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
Answered by AI
Add your answer
Q5. Whai is Sql Join and why do we need it
Ans. 
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
Answered by AI
Add your answer
Q6. How to create a table using MYSQL
Ans. 
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)
Answered by AI
Add your answer

.net core api with .net MVC application and jQuery

Q1. About api and mvc
Add your answer