Chetu DOT NET Developer Interview Questions, Process, and Tips for Experienced

Logically question, mathematics

Q1. C#,asp.net MVC,.net core
Add your answer
Q2. SQLserver.jquery
Add your answer
Q3. Linq, store procedure
Add your answer
Q4. Logically question like how we can pass data controller
Add your answer

Q1. Join in sql define and explain
Ans. 
Join in SQL 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 based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

First round will be assessment round where one guy from there team will share his screen to you have give the control and you have to complete the assessment….questions are related to .net field and c#

Q1. First introduce your self and then he will ask you to rate your self in all technology and then one by one they will ask you question basics to c# oops and then sql question , mvc, webapi
Add your answer

Q1. After taking all the interviews they told me that we don't have the opening...I asked them like why did you guys just waste my time...she was like the person who called you 1st day fired from the company.....read more
Add your answer

Total 50 Questions 40 from technology 10 from normal aptitude not so tough.

Q1. Telephonic interview by senior developer basic concepts of oops, sql, C#
Add your answer
Q2. Opps concepts indexes Array and arrylists Stored procedures and functions class structs object constructor etc
Add your answer
Q3. What is Encapsulation where you implement and why?
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit, known as a class.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for better control over the data by preventing direct access and manipulation from outside the class.

• Encapsulation also promotes code reusability and modularity by grouping related data and methods tog...read more
Answered by AI
Add your answer
Q4. Difference between Interfaces and abstraction?
Ans. 
Interfaces define contracts for classes to implement, while abstraction is a way to hide implementation details.
• Interfaces are like a blueprint that defines what methods a class must implement.

• Abstraction is a concept where we hide the implementation details and show only the necessary features of an object.

• Interfaces can have multiple inheritance, while abstraction is achieved using abstract classes or interfaces.

• Exam...read more
Answered by AI
Add your answer
Q5. Difference between Stored procedure and functions when we use where we use what the profits of its?
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are user-defined routines that return a value.
• Stored procedures are used for performing specific tasks or operations on the database, while functions are used to return a single value.

• Stored procedures can contain multiple SQL statements and can have input and output parameters, while functions are more limited in their functionality.

• ...read more
Answered by AI
Add your answer

Reverse no.
Star patterns
print numbers without loop
highest salary query
Count male female from the table