CADD Centre Training Services Team Manager Interview Questions and Answers

Write a pivot dinamic column from rows in SQL server.

Q1. Clustered and non clustered indexing in SQL server
Ans. 
Clustered indexing physically reorders the data in the table, while non-clustered indexing creates a separate structure.
• Clustered indexing determines the physical order of data rows in a table based on the indexed column.

• Non-clustered indexing creates a separate structure that contains the indexed column's values and pointers to the actual data rows.

• Clustered indexes are faster for retrieval but slower for inserts and ...read more
Answered by AI
Add your answer
Q2. Nested loops in SQL server
Ans. 
Nested loops in SQL server are used to iterate through multiple levels of data.
• Nested loops are used when you need to iterate through a set of data within another set of data.

• They can be implemented using nested SELECT statements or JOIN clauses.

• Example: SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id WHERE t1.column = 'value'
Answered by AI
Add your answer

Repository pattern in asp.net core API

Q1. About experience
Add your answer

Q1. Experience, skills
Add your answer

About job position experience & Role for which applying, short keys of concern department

Q1. General Questions reated to personal and professional profile.
Add your answer
Q2. General Questions related to personal and professional profile.
Add your answer

Q1. General questions related to techincal knowledge of the profile.
Add your answer

Q1. Qualification Related Questions
Add your answer
Q2. Experience Related Questions
Add your answer

Q1. Take me through your professional journey
Add your answer
Q2. What changes and amendments you think you could do with your current role
Ans. 
I would enhance team collaboration, streamline processes, and implement feedback mechanisms for continuous improvement.
• Foster a culture of open communication by implementing regular team check-ins to discuss challenges and successes.

• Introduce project management tools like Trello or Asana to improve task tracking and accountability.

• Establish a feedback loop where team members can share insights on processes, leading to ...read more
Answered by AI
Add your answer

Q1. Ask anything to related to experience
Add your answer
Q2. Can you describe your project and your planning strategies to achieve your targets?
Ans. 
Effective project planning involves setting clear goals, defining milestones, and utilizing resources efficiently to meet targets.
• Goal Setting: I start by defining SMART goals (Specific, Measurable, Achievable, Relevant, Time-bound) to ensure clarity in objectives.

• Milestone Planning: I break the project into phases with specific milestones, such as completing the initial research phase within two weeks.

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