Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2024. There were 6 interview rounds.
Different types of joins in SQL can lead to performance issues and incorrect results if not used properly.
Inner join: Returns only the rows that have matching values in both tables.
Outer join: Returns all rows from both tables, filling in NULL values for unmatched rows.
Cross join: Returns the Cartesian product of the two tables, potentially leading to a large result set.
Self join: Joins a table to itself, useful for co
I have used various types of indexes such as clustered, non-clustered, unique, and composite indexes in my previous organization.
Utilized clustered indexes to physically sort the data on disk based on the index key
Implemented non-clustered indexes to improve query performance by creating a separate data structure
Employed unique indexes to enforce uniqueness on one or more columns
Created composite indexes to improve que
Various tools were used in the previous organization including SQL Server Management Studio, Oracle SQL Developer, and Toad.
SQL Server Management Studio
Oracle SQL Developer
Toad
I can join within two weeks of receiving an offer.
I can start within two weeks of receiving an offer.
I need to give a two-week notice at my current job.
I have some personal commitments that I need to wrap up before starting.
I can provide a specific start date once an offer is extended.
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
1.About sql statements
2.Stored Procedures
3.Database
4.ETL
5.Debugging
Top trending discussions
Mechanical Engineering offers a diverse range of opportunities to apply scientific principles to solve real-world problems.
Mechanical Engineering provides a strong foundation in math, physics, and materials science.
It offers a wide range of career opportunities in various industries such as automotive, aerospace, and manufacturing.
Mechanical Engineers design and develop machines, tools, and systems that improve our dai...
Yes, social media can be used for educational purposes.
Social media provides a platform for sharing educational content and resources.
It allows for collaboration and communication among students and teachers.
Social media can enhance learning through interactive discussions and real-time feedback.
It can also help in reaching a wider audience and promoting educational initiatives.
Examples include educational YouTube chan...
I am a highly motivated and experienced project engineer with a strong background in managing complex engineering projects.
I have a Bachelor's degree in Engineering and have been working as a project engineer for the past 5 years.
I have successfully managed multiple projects from conception to completion, ensuring they are delivered on time and within budget.
I have a proven track record of effectively coordinating with...
The present CEO is John Smith.
John Smith is the current CEO of the company.
He has been in this position since 2015.
Under his leadership, the company has experienced significant growth and expansion.
John Smith has a strong background in engineering and project management.
He is known for his strategic vision and ability to drive innovation.
Polymorphism is the ability of an object to take on many forms. In C++, it is achieved through function overloading and virtual functions.
Polymorphism allows objects of different classes to be treated as objects of a common base class.
Function overloading enables multiple functions with the same name but different parameters.
Virtual functions allow derived classes to override base class functions.
Print the level order traversal of binary tree in spiral form
Perform level order traversal of the binary tree
Alternate the direction of traversal for each level
Use a stack to reverse the order of nodes in each level
Print the nodes in the order of traversal
Find the maximum element in each subarray of size k in a given array.
Iterate through the array from index 0 to n-k.
For each subarray of size k, find the maximum element.
Store the maximum elements in a separate array.
Return the array of maximum elements.
To find the Kth largest element in two sorted arrays, we can use the merge step of merge sort algorithm.
Merge the two arrays into a single sorted array using a modified merge sort algorithm.
Return the Kth element from the merged array.
Merge two sorted arrays into one sorted array with expected time complexity of (m+n).
Use a two-pointer approach to compare elements from both arrays and merge them into the first array.
Start comparing elements from the end of both arrays and place the larger element at the end of the first array.
Continue this process until all elements from the second array are merged into the first array.
Interview experience
based on 1 review
Rating in categories
Quality Analyst
4
salaries
| ₹5 L/yr - ₹10.5 L/yr |
Product Manager
4
salaries
| ₹20 L/yr - ₹25.9 L/yr |
Product Developer
4
salaries
| ₹5.2 L/yr - ₹7.8 L/yr |
Senior HR Executive
4
salaries
| ₹4.8 L/yr - ₹6.6 L/yr |
Product Lead
4
salaries
| ₹16.2 L/yr - ₹30 L/yr |
Paytm
PolicyBazaar
Zerodha
PhonePe