Infinite Computer Solutions Team Lead Interview Questions and Answers

Q1. Difference between Cluster and Non-Cluster Index?
Ans. 
Cluster index physically orders the data rows in the table, while non-cluster index does not.
• Cluster index determines the physical order of data rows in the table.

• Non-cluster index does not affect the physical order of data rows.

• Cluster index is faster for retrieval of data in the order specified by the index.

• Non-cluster index is faster for retrieval of data based on specific columns.

• Example: Cluster index on a primary...read more
Answered by AI
Add your answer
Q2. Difference between SQL DELETE and SQL TRUNCATE
Ans. 
DELETE removes specific rows from a table, while TRUNCATE removes all rows from a table.
• DELETE is a DML command, while TRUNCATE is a DDL command.

• DELETE can be rolled back, while TRUNCATE cannot be rolled back.

• DELETE triggers delete triggers on each row, while TRUNCATE does not trigger any delete triggers.

• DELETE is slower as it maintains logs, while TRUNCATE is faster as it does not maintain logs.
Answered by AI
Add your answer

Q1. Self introduction about urself
Add your answer
Q2. Mapping domain interview questions
Add your answer

Q1. Salary expectations and number
Add your answer
Q2. Any transport issue questions
Add your answer

Q1. Normal questions about lending and dealing
Add your answer

Q1. Oops concept asked in frame works
Add your answer
Q2. Inheritance encapsulation abstracts
Add your answer

Q1. Salary expectations
Add your answer

On risk assessment and as well as case study

Q1. Salary expectations
Add your answer
Q2. Job location etc etc
Add your answer

Q1. Team leader role nd responsibility
Add your answer
Q2. Team leader KPI
Add your answer

Q1. Tell me about your self, why you want to join, what do you know about NIQ,case study on people management
Add your answer