Welspun Transformation Services Limited 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

General aptitude questions

Q1. Do you have computer knowledge?
Ans. 
Yes, I have computer knowledge including proficiency in Microsoft Office, basic troubleshooting skills, and experience with project management software.
• Proficient in Microsoft Office suite (Word, Excel, PowerPoint, Outlook)

• Basic troubleshooting skills for hardware and software issues

• Experience with project management software like Trello or Asana
Answered by AI
Add your answer
Q2. Do you know about GIS or Lidar ?
Ans. 
Yes, GIS (Geographic Information System) and Lidar (Light Detection and Ranging) are tools used for mapping and analyzing geographical data.
• GIS is a system designed to capture, store, manipulate, analyze, manage, and present spatial or geographic data.

• Lidar is a remote sensing method that uses light in the form of a pulsed laser to measure variable distances to the Earth.

• Both GIS and Lidar are commonly used in fields s...read more
Answered by AI
Add your answer
Q3. Do you know about company background?
Add your answer

Q1. What is your expectations?
Add your answer

Q1. What would you do if you're given the role/ what would be your plan of actions if you're on boarded
Add your answer
Q2. Let's say there are 7 in the team 3 are on leave and you would need to finish a project which needs 7 folks but now you have only 4 resources. How would you manage to deliver the project?
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