Arcesium Technical Lead Interview Questions and Answers

Q1. Tell us about yourself
Add your answer
Q2. Lot of questions on SQL and Linux commands
Add your answer

Q1. Tell us about yourself
Add your answer
Q2. It was a manager round combined with some technical questions
Add your answer

Q1. Mix of coding, theory and design questions
Add your answer

Q1. Builder design pattern in java
Ans. 
Builder design pattern is a creational design pattern used to construct complex objects step by step.
• Builder pattern separates the construction of a complex object from its representation.

• It allows the same construction process to create different representations of the object.

• Useful when there are multiple ways to construct an object or when the object creation process is complex.

• Example: StringBuilder in Java allows ...read more
Answered by AI
Add your answer
Q2. Docker, MQ series involved
Add your answer
Q3. JOIN Query with country , emp name
Ans. 
JOIN query to retrieve country and employee name
• Use JOIN keyword to combine data from multiple tables

• Specify the columns to select from each table

• Use ON keyword to specify the relationship between the tables
Answered by AI
Add your answer

Q1. Ask about project and related skills
Add your answer
Q2. Case scenario and problems
Add your answer

Q1. About the tools and queries
Add your answer
Q2. About the experience
Add your answer

Q1. About the experience
Add your answer
Q2. And the package relocation and shift
Add your answer

Q1. One to one about the experience
Add your answer

Q1. What do you know about Prime?
Ans. 
Prime is a subscription service offered by Amazon that provides access to a variety of benefits, including free two-day shipping, streaming of music and video content, and more.
• Prime offers free two-day shipping on eligible items

• Prime Video provides access to a wide range of movies and TV shows

• Prime Music allows users to stream music ad-free

• Prime Reading offers a selection of ebooks and magazines for free

• Prime members
Answered by AI
Add your answer

Hacker rank test with medium to easy level.

Q1. React architecture, component debugging, api best practices and pseudo implementation
Add your answer

Q1. Stress situation, design question
Add your answer

Q1. Why do you want to join, expectation
Ans. 
I want to join to contribute my technical expertise and leadership skills, and I expect to work on challenging projects and grow professionally.
• I am excited about the opportunity to lead technical teams and drive innovation.

• I am looking forward to working on complex projects that will allow me to utilize my skills and knowledge.

• I expect to collaborate with talented individuals and learn from them to further develop my ...read more
Answered by AI
Add your answer

Q1. Explain MVC pipe-line.
Ans. 
MVC pipeline is a design pattern that separates an application into three interconnected components: Model, View, and Controller.
• Model represents the data and business logic

• View displays the data to the user

• Controller handles user input and updates the model and view accordingly

• The pipeline ensures separation of concerns and promotes modularity

• Example: A user enters data in a form (input), the controller receives the i...read more
Answered by AI
Add your answer
Q2. Howrouting works in Asp.Net MVC?
Ans. 
Routing in Asp.Net MVC maps incoming requests to appropriate controller actions.
• Routing is configured in RouteConfig.cs file.

• Routes are defined using MapRoute method.

• Routes can have placeholders for dynamic values.

• Routes can have constraints to restrict the values of placeholders.

• Routes can be named for easy reference.

• Default route is defined as {controller}/{action}/{id}.

• Attribute routing can also be used to define ro
Answered by AI
Add your answer
Q3. How to move from one entity framework version to another in a project?
Ans. 
To move from one Entity Framework version to another, update the NuGet package and make necessary code changes.
• Update the NuGet package to the desired version

• Make necessary code changes to accommodate any breaking changes

• Test thoroughly to ensure the application still works as expected
Answered by AI
Add your answer
Q4. How WCF is different from Asp.Net Web Api?
Ans. 
WCF is a framework for building distributed systems while Asp.Net Web Api is for building HTTP services.
• WCF supports multiple protocols like TCP, HTTP, Named Pipes, etc. while Web Api only supports HTTP.

• WCF has more configuration options and is more flexible than Web Api.

• Web Api is more lightweight and easier to use for building RESTful services.

• WCF is more suitable for building enterprise-level applications with compl...read more
Answered by AI
Add your answer
Q5. How to create a restful service without using Asp.Net Web Api template?
Ans. 
Creating a RESTful service without using Asp.Net Web Api template.
• Use a lightweight framework like Flask or Express

• Define routes and HTTP methods for each endpoint

• Serialize data to JSON format

• Handle errors and exceptions

• Test the service using tools like Postman or curl
Answered by AI
Add your answer
Q6. Difference between drop, truncate and delete.
Ans. 
Difference between drop, truncate and delete.
• DROP command removes a table from the database

• TRUNCATE command removes all rows from a table

• DELETE command removes specific rows from a table
Answered by AI
Add your answer
Q7. How many types of routings are there in Asp.Net MVC?
Ans. 
There are two types of routings in Asp.Net MVC: convention-based routing and attribute routing.
• Convention-based routing uses default routing rules to map URLs to controller actions.

• Attribute routing allows developers to define custom routes using attributes on controller actions or at the controller level.

• Both types of routing can be used together in the same application.

• Convention-based routing is the default routing ...read more
Answered by AI
Add your answer
Q8. How to go about performancetuning in SQL?
Ans. 
Performance tuning in SQL involves optimizing queries, indexes, and server settings to improve database performance.
• Identify slow queries using profiling tools

• Optimize queries by rewriting or adding indexes

• Adjust server settings such as memory allocation and disk usage

• Consider partitioning large tables

• Regularly monitor and analyze performance metrics
Answered by AI
Add your answer
Q9. Given a project requirement, how to choose between .Net framework and .Net Core?
Ans. 
Choose .Net Core for cross-platform and cloud-based applications, .Net Framework for Windows-only applications.
• Consider the target platform and deployment environment

• Choose .Net Core for cross-platform and cloud-based applications

• Choose .Net Framework for Windows-only applications

• Check for compatibility with existing libraries and frameworks

• Consider performance and scalability requirements
Answered by AI
Add your answer

Q1. Why would to like to change your organisation?
Add your answer

C coding
Debugging
Data structures
Bitwise operation