i
Infinite Computer Solutions
Compare
Filter interviews by
Infinite Computer Solutions Team Lead Interview Questions and Answers
Infinite Computer Solutions Team Lead Interview Experiences
2 interviews found
Anonymous
I applied via Approached by Company and was interviewed in Aug 2023. There were 4 interview rounds.
(1 Question)
- Q1. How to get 3rd highest salary?
(1 Question)
- Q1. What is the difference between primary key and unique key?
- Ans.
Primary key uniquely identifies each record in a table, while unique key ensures that all values in a column are distinct.
Primary key does not allow NULL values, while unique key allows one NULL value.
A table can have only one primary key, but multiple unique keys.
Primary key automatically creates a unique index, while unique key does not.
Primary key is used to establish relationships between tables, while unique key i
(1 Question)
- Q1. Will you work from office in hybrid mode?
Interview Preparation Tips
I have selected all rounds of the interview
And they finalised salary as well and mentioned like going to send offer letter but EOD HR was bargaining about Salary
If we are reducing salary then they are again bargaining.
They wasted my time to fill all documents as well.
I applied via Company Website and was interviewed before Apr 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. It's all depends on client interview
- Q2. Everything depends on client
- Q3. Everything depends on client and contract
Interview Preparation Tips
Untill the contact between infinite and client
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Contents of test plan and stratergy
- Ans.
Test plan and strategy outline the approach for testing a software application.
Test plan includes objectives, scope, resources, schedule, and risks.
Test strategy defines testing approach, techniques, tools, and responsibilities.
Both documents are essential for successful testing and quality assurance.
Example: Test plan may include test cases, test scenarios, and test data.
Example: Test strategy may outline automation t...
- Q2. Sql query to find unique records, what is truncate, abort,what are DML commands
- Ans.
SQL query to find unique records, truncate, abort, DML commands
To find unique records in SQL, you can use the DISTINCT keyword in your SELECT statement.
Truncate is a SQL command used to quickly delete all records from a table, but it cannot be rolled back.
Abort is a command used to cancel a transaction in SQL.
DML (Data Manipulation Language) commands in SQL include INSERT, UPDATE, DELETE.
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- 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...
- 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.
Skills evaluated in this interview
lakshmi sravani888
I applied via Job Portal and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self introduction about urself
- Ans.
I am a dedicated and experienced professional with a strong background in leadership and team management.
Over 5 years of experience in leading teams and managing projects
Proven track record of successfully achieving team goals and targets
Strong communication and interpersonal skills
Ability to motivate and inspire team members to perform at their best
- Q2. Mapping domain interview questions
(2 Questions)
- Q1. Salary expectations and number
- Q2. Any transport issue questions
(1 Question)
- Q1. Normal questions about lending and dealing
(2 Questions)
- Q1. Oops concept asked in frame works
- Q2. Inheritance encapsulation abstracts
(1 Question)
- Q1. Salary expectations
Ankur dwivedi
(2 Questions)
- Q1. Team leader role nd responsibility
- Q2. Team leader KPI
Interview Preparation Tips
(1 Question)
- Q1. Tell me about your self, why you want to join, what do you know about NIQ,case study on people management
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Dec 2023. There were 2 interview rounds.
The AMCAT test was conducted.
Information Technology development in India.
Interview Preparation Tips
Infinite Computer Solutions Interview FAQs
Tell us how to improve this page.
Infinite Computer Solutions Interviews By Designations
- Infinite Computer Solutions Software Engineer Interview Questions
- Infinite Computer Solutions Senior Software Engineer Interview Questions
- Infinite Computer Solutions Associate Software Engineer Interview Questions
- Infinite Computer Solutions Technical Lead Interview Questions
- Infinite Computer Solutions Senior Technical Lead Interview Questions
- Infinite Computer Solutions Softwaretest Engineer Interview Questions
- Infinite Computer Solutions Java Developer Interview Questions
- Infinite Computer Solutions Senior Systems Engineer Interview Questions
- Show more
People are getting interviews through
Team Lead Interview Questions from Similar Companies
Fast track your campus placements
Infinite Computer Solutions Team Lead Reviews and Ratings
based on 7 reviews
Rating in categories
|
Software Engineer
1.4k
salaries
|  ₹3.7 L/yr - ₹14 L/yr |
|
Senior Software Engineer
1.2k
salaries
| ₹6.5 L/yr - ₹22 L/yr |
|
Technical Lead
776
salaries
| ₹10 L/yr - ₹34.3 L/yr |
|
Associate Software Engineer
673
salaries
| ₹2 L/yr - ₹10 L/yr |
|
Softwaretest Engineer
601
salaries
| ₹3 L/yr - ₹10.6 L/yr |
TCS
Wipro
HCLTech
Tech Mahindra
Calculate your in-hand salary
- Home >
- Interviews >
- Infinite Computer Solutions Interview Questions >
- Infinite Computer Solutions Team Lead Interview Questions
