Filter interviews by
Joins in SQL are used to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables in a single query
Common types of joins include inner join, left join, right join, and full outer join
Join conditions are specified using the ON keyword and a related column in each table
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Yes, I have worked on several SQL projects.
Developed a database for a retail company to manage inventory and sales data using SQL Server
Created complex queries to extract data from multiple tables for a financial services firm
Optimized database performance by indexing and partitioning tables for a healthcare organization
Duplicates can be removed in SQL using DISTINCT keyword or GROUP BY clause.
Use DISTINCT keyword to select unique values from a single column.
Use GROUP BY clause to group rows with same values and select unique values from multiple columns.
Use HAVING clause to filter out groups with count greater than 1.
Use INNER JOIN to join tables and select unique values from multiple tables.
Use ROW_NUMBER() function to assign a uniq...
I applied via Referral and was interviewed in Oct 2022. There were 4 interview rounds.
Tower of Hanoi, LinkedList, Array, SQL, OOPs Concept
I have command over multiple languages including Java, Python, and C++.
I have experience in developing applications using Java, Python, and C++.
I am proficient in writing clean and efficient code in these languages.
I have worked on various projects using these languages, including web development, data analysis, and machine learning.
I keep myself updated with the latest developments in these languages and their framewo...
I applied via Instahyre and was interviewed before Apr 2023. There were 3 interview rounds.
Neustar interview questions for popular designations
Get interview-ready with Top Neustar Interview Questions
I applied via Referral and was interviewed before Feb 2023. There were 2 interview rounds.
To avoid Whitelabel Exception in Spring Boot, customize error handling and provide appropriate error responses.
Create a custom error controller to handle exceptions
Implement a custom exception handler to map specific exceptions to appropriate HTTP responses
Use @ControllerAdvice to handle exceptions globally
Configure error properties to provide custom error messages and codes
Use appropriate HTTP status codes for differe
A constructor is a special method used to initialize objects in a class.
Constructors have the same name as the class they belong to.
They are called automatically when an object is created.
Constructors can have parameters to initialize object properties.
They can be overloaded to have multiple constructors with different parameters.
Constructors can also call other constructors using the 'this' keyword.
Aptitude ,reasoning ,small programs .it was easy.
I applied via Approached by Company and was interviewed before Mar 2022. There were 4 interview rounds.
Terraform State File locking mechanism in AWS ensures concurrent access to state files is managed safely.
Terraform uses a locking mechanism to prevent concurrent access to state files
Locking is achieved using a DynamoDB table in AWS
When a user runs Terraform, it acquires a lock on the state file in DynamoDB
Other users attempting to run Terraform on the same state file will be blocked until the lock is released
This ensu...
Variable precedence in Ansible
Ansible follows a specific order to determine variable precedence
Highest precedence: Variables defined in playbooks or roles
Next: Variables defined in inventory files or inventory plugins
Then: Variables defined in command line or extra vars
Lowest precedence: Variables defined in role defaults or inventory group_vars
I applied via Naukri.com and was interviewed in Nov 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Apr 2021. There were 5 interview rounds.
Program to print right angle triangle of number pattern using Python.
Use nested loops to print the pattern.
The outer loop will iterate through the rows.
The inner loop will iterate through the columns.
Use the range function to control the number of rows and columns.
Print the numbers in the pattern using string formatting.
Program to merge and sort 2 lists using Python.
Create two lists and merge them using the extend() method.
Sort the merged list using the sort() method.
Alternatively, use the sorted() function to sort the merged list.
Example: list1 = ['apple', 'banana', 'cherry'], list2 = ['orange', 'kiwi', 'mango']
Example: merged_list = list1 + list2
Example: merged_list.sort() or sorted(merged_list)
Interview experience
Software Engineer
46
salaries
| ₹5.8 L/yr - ₹21.3 L/yr |
Associate Software Engineer
41
salaries
| ₹4.3 L/yr - ₹9 L/yr |
Senior Software Engineer
19
salaries
| ₹13.4 L/yr - ₹32.6 L/yr |
Devops Engineer
16
salaries
| ₹5.2 L/yr - ₹18 L/yr |
Data Analyst
16
salaries
| ₹5 L/yr - ₹14.8 L/yr |
Akamai Technologies
Verisign
Comcast
Equinix