NewVision Software & Consultancy Technical Lead Interview Questions and Answers

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

Written test conducted with basic logic reasoning and grammer

Q1. Basic introduction
Add your answer

Q1. More about ur personal life
Add your answer

Q1. LC coding round hard level
Add your answer

Coding test on online platform LC tagged

Q1. How do you describe yourself?
Add your answer
Q2. What is softest bone?
Ans. 
Clavicle bone is the softest bone in human body
Answered Anonymously
View 2 more answers
Q3. What is largest organ?
View 1 more answer
Q4. Why you want this job?
Add your answer

Q1. How would you imply your previous experience in our company?
Add your answer
Q2. What are antibiotics? describe about them.
View 1 more answer
Q3. What is emperical treatment?
Add your answer
Q4. All about pharmacology
Add your answer

Q1. What is stroke and its treatment?
Add your answer
Q2. What is CABG where can we use it?
View 1 more answer
Q3. How do we diagnose heart failure?
Add your answer

Conceptual understanding

Q1. About the family
Add your answer
Q2. Self introduction
Add your answer
Q3. Comfortable mean
Add your answer
Q4. Are you willing to work on weekends
Ans. 
Yes, I am willing to work on weekends as needed to meet project deadlines and support team goals.
• I understand the importance of meeting project deadlines and supporting team goals

• I am flexible with my schedule and willing to work weekends if necessary

• I have previous experience working weekends in a professional setting
Answered by AI
Add your answer
Q5. Say about your weekness
Ans. 
My weakness is that I tend to be overly critical of my own work.
• I have a tendency to be a perfectionist and can spend too much time on a task trying to make it perfect.

• I sometimes struggle with delegating tasks to others because I want to ensure they are done to my high standards.

• I am working on improving my ability to accept constructive criticism and not take it personally.
Answered by AI
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