Filter interviews by
Lot many questions around 50/60 including quants logical and english
Completely gereralized topics
General aptitude questions
Bristlecone interview questions for designations
I applied via Naukri.com and was interviewed in May 2021. There were 4 interview rounds.
Indexing is a technique to improve database performance by creating a quick lookup of data.
Indexing helps in faster retrieval of data from a database.
It reduces the time taken to search for data in a large database.
Indexes can be created on one or more columns of a table.
Examples of indexes include primary key, unique key, and clustered index.
Indexing can also help in optimizing query performance.
Query to retrieve hierarchical data from a table with parent-child relationship maintained by ID and parent ID.
Use a self-join to join the table with itself based on the parent ID and ID columns.
Use a recursive CTE (Common Table Expression) to traverse the hierarchy and retrieve all levels of data.
Order the results by the hierarchy level to display the data in a hierarchical structure.
I applied via Recruitment Consulltant and was interviewed before Mar 2021. There were 3 interview rounds.
Top trending discussions
I was interviewed in Dec 2024.
I applied via Referral and was interviewed in Sep 2023. There were 2 interview rounds.
Some of the top questions asked at the Bristlecone Consultant interview -
based on 3 interviews
1 Interview rounds
based on 58 reviews
Rating in categories
Consultant
648
salaries
| ₹4.5 L/yr - ₹18 L/yr |
Senior Consultant
511
salaries
| ₹8.8 L/yr - ₹30.2 L/yr |
Associate Consultant
315
salaries
| ₹2 L/yr - ₹7.3 L/yr |
Specialist
213
salaries
| ₹3.5 L/yr - ₹11 L/yr |
Principal Associate
160
salaries
| ₹13.6 L/yr - ₹40 L/yr |
Infosys Consulting
TCS
Wipro
Tech Mahindra