Yardi Systems DOT NET Developer Interview Questions and Answers

Q1. Design pattern, write code to check lower case upper case, write singleton with lock, oops questions, what is cte, difference between sp and view, find highest salary in sql, Azure concepts for service bus...read more
Add your answer

Q1. 1. What is Dynamic Query 2. Types of indexes 3. Query optimization techniques
Ans. 
Dynamic query is a query that is constructed at runtime based on user input or conditions.
• Dynamic query allows for flexibility in querying data based on changing criteria.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Query optimization techniques include indexing, using proper join types, avoiding unnecessary columns in SELECT statements, and using WHERE clauses effectively.
Answered by AI
Add your answer

Q1. Explain MVC lifecycle
Ans. 
MVC lifecycle involves request routing, controller execution, view rendering, and response generation.
• Request is received by the routing engine which determines the appropriate controller and action method to handle the request.

• Controller executes the action method, interacts with the model to retrieve data, and passes it to the view.

• View renders the data received from the controller and generates the HTML response.

• Res...read more
Answered by AI
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

Q1. Worst company ever, where the interviewer himself does not know what are the requirements for the position they are hiring for. The interviewer interviewed me for .Net architect, and suddenly I found mysel...read more
Add your answer
Q2. You are just a resource waiting to be deployed on project. All they want to know is that why you are not deployed even if you haven't faced any client interview in the field of your expertise.
Add your answer

Q1. Multiple choice questions within 45 minutes. Mymapit is çonducting tests.
Add your answer

Q1. SQL, c#, asp.net, framework
Add your answer

Good not much difficult easily crakeable with normal knowledge

Q1. Normal question about the technology you are interested and mentioned in your resume
Add your answer
Q2. Oops concepts general concept related to the selected topics and the basic questions
Add your answer

Q1. Technical round 2 also asked the question related to the subject mentioned in resume
Add your answer

Q1. Nothing special only tells you about the company perks and you can ask if you have any query
Add your answer