Filter interviews by
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Triggers are special stored procedures in databases that are automatically executed or fired when certain events occur.
Triggers are used to maintain data integrity by enforcing business rules or automating actions.
They can be set to execute before or after an INSERT, UPDATE, or DELETE operation on a table.
Examples of triggers include auditing changes to a table, updating a related table when a record is inserted, or en
No, primary keys should not be deleted as they uniquely identify each record in a database.
Primary keys are essential for maintaining data integrity and ensuring uniqueness of records.
Deleting a primary key can lead to data inconsistencies and errors in the database.
If a primary key needs to be changed, it is better to update it rather than delete it.
Drop means to remove a database object, while delete means to remove data from a table.
Drop is used to remove an entire database object like a table, view, or database itself.
Delete is used to remove specific rows of data from a table.
Drop operation is irreversible and can lead to loss of data, while delete operation can be rolled back if within a transaction.
Example: DROP TABLE employees; DELETE FROM employees WHERE a
Top trending discussions
I applied via campus placement at Mepco Schlenk Engineering College, Coimbatore and was interviewed before Apr 2023. There were 2 interview rounds.
Normal APTITUDE SYLLABUS
I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.
Just asked some concepts of coding
Island Perimeter and Number of Provinces. Basic Leetcode question
Data structure and algo with arrays and hash
System design involves both high level and low level design to create a comprehensive architecture.
High level design focuses on overall system architecture and functionality
Low level design delves into specific components, modules, and interactions
Examples: High level - deciding on database structure, Low level - designing specific API endpoints
The notification engine in a project is designed to send timely and relevant notifications to users.
Implement a system to track user preferences and settings for notifications.
Utilize a queue system to prioritize and schedule notifications.
Include options for users to customize notification frequency and content.
Integrate with external services like email or SMS for notifications delivery.
I applied via Job Portal and was interviewed in Dec 2021. There were 4 interview rounds.
I applied via Job Portal and was interviewed in Jun 2021. There were 5 interview rounds.
Oops concepts are fundamental to object-oriented programming. They help in creating modular and reusable code.
Encapsulation - hiding implementation details of an object from the outside world
Inheritance - creating new classes from existing ones, inheriting their properties and methods
Polymorphism - ability of objects to take on many forms, depending on the context
Abstraction - focusing on essential features of an objec
Multiple inheritance is not allowed in Java to avoid the diamond problem.
Java supports multiple interface inheritance to achieve the same functionality.
Diamond problem occurs when a class inherits from two classes with a common method.
Java prioritizes single inheritance to maintain simplicity and avoid ambiguity.
Arrays are fixed in size while ArrayLists can dynamically grow and shrink.
Arrays are of fixed size while ArrayLists can be resized dynamically.
Arrays can hold primitive data types and objects while ArrayLists can only hold objects.
Arrays are faster for accessing elements while ArrayLists are faster for adding and removing elements.
Arrays use square brackets [] to declare while ArrayLists use angle brackets <>.
Example: ...
Java collections are classes and interfaces that provide a way to store and manipulate groups of objects.
Java collections include List, Set, Map, Queue, and their respective implementations
They provide methods for adding, removing, and accessing elements
Examples include ArrayList, HashSet, TreeMap, and PriorityQueue
Time theta is a measure of the worst-case time complexity of an algorithm.
It is used to analyze the performance of algorithms.
It represents the maximum amount of time an algorithm takes to complete.
It is denoted by the symbol Θ(n).
Bubble sorting is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.
Bubble sort is a comparison-based algorithm
It works by comparing each pair of adjacent elements and swapping them if they are in the wrong order
The algorithm repeats this process until no more swaps are needed
It has a worst-case and average-case complexity of O(n^...
Code to generate a random number between 15-25
Use Math.random() to generate a random number between 0-1
Multiply the result with the range (25-15) and add the minimum value (15)
Use Math.floor() to round down the result to an integer
I applied via Company Website and was interviewed in Dec 2021. There were 5 interview rounds.
Interview experience
Software Engineer
6
salaries
| ₹4 L/yr - ₹5.5 L/yr |
Devops Engineer
4
salaries
| ₹5.6 L/yr - ₹9 L/yr |
Python Developer
3
salaries
| ₹8.1 L/yr - ₹10.1 L/yr |
Senior Software Engineer
3
salaries
| ₹7.9 L/yr - ₹23.2 L/yr |
TCS
Infosys
Wipro
HCLTech