CADD Centre Training Services Senior Consultant 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. PHP Questions, classes,
Add your answer
Q2. OOPs Fundamentals, echo print difference, dynamic variables
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What is your total work experience
Add your answer
Q3. What is your Current CTC
Add your answer

Q1. Where do you see yourself in next 5 years.
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. General questions regarding self and work
Add your answer

Q1. About myself and my working skills and my previous experience
Add your answer
Q2. What is expected salary
Add your answer
Q3. Are willing to reloacte
Ans. 
Yes, I am willing to relocate for the right opportunity.
• I am open to relocating for a position that aligns with my career goals

• I have relocated for previous job opportunities and am comfortable with the process

• I understand the importance of being flexible and adaptable in the tech industry
Answered by AI
Add your answer

C#,Dotnet MVC,Webform ,sql server, write code ,they give task ask about and explanation.

Q1. Policy term and conditions and expectation
Add your answer
Q2. Why i am leaving privious organization
Add your answer