Filter interviews by
A trigger is a special kind of stored procedure that automatically executes when an event occurs in a database.
Triggers are used to maintain the integrity of the database by enforcing business rules or performing actions when certain events occur.
They can be used to automatically update related tables, enforce constraints, or log changes.
Examples of triggers include auditing changes to a table, updating a timestamp whe...
A trigger in MySQL is a set of SQL statements that automatically 'fires' when a specified event occurs on a particular table.
Triggers can be used to enforce business rules, perform data validation, or maintain referential integrity.
Syntax: CREATE TRIGGER trigger_name trigger_time trigger_event ON table_name FOR EACH ROW trigger_body;
Example: CREATE TRIGGER update_salary BEFORE UPDATE ON employees FOR EACH ROW SET NEW.s
Indexing in MySQL is a way to optimize database queries by creating indexes on columns for faster retrieval of data.
Indexes in MySQL are created using the CREATE INDEX statement.
Indexes can be created on single or multiple columns.
Indexes help in speeding up SELECT queries but may slow down INSERT, UPDATE, and DELETE operations.
Primary keys automatically create a unique index in MySQL.
Examples: CREATE INDEX idx_name ON
A view in MySQL server is a virtual table that is based on the result set of a SELECT query.
Views do not store any data themselves, but display data from one or more tables based on the query used to create the view.
Views can be used to simplify complex queries, restrict access to certain columns, or provide a consistent interface to users.
Views are created using the CREATE VIEW statement and can be queried like regula
MySQL database engine provides various methods for interacting with the database.
MySQL database engine methods include SELECT, INSERT, UPDATE, DELETE for data manipulation
Other methods include CREATE, ALTER, DROP for database schema management
Functions like COUNT, SUM, AVG can be used for data analysis
Transactions can be managed using BEGIN, COMMIT, ROLLBACK
Top trending discussions
There were three coding questions.
posted on 6 Jan 2025
I applied via Campus Placement
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
Question Related to the DP and the Graph
Find the Kth maximum element in an array of strings.
Sort the array in descending order.
Return the element at index K-1.
Coin change problem can be solved using dynamic programming to find the minimum number of coins needed to make a certain amount of change.
Use dynamic programming to build up solutions for smaller subproblems
Start by initializing an array to store the minimum number of coins needed for each amount from 0 to the target amount
Iterate through each coin denomination and update the array with the minimum number of coins need
Two sum problem DSA fromleetcode
Libuv is a multi-platform support library with a focus on asynchronous I/O.
Provides event loop, networking, and file system access APIs
Supports asynchronous operations for handling I/O events efficiently
Used in Node.js for handling non-blocking I/O operations
Async programming in JS allows for non-blocking operations, improving performance and user experience.
Use async/await to write asynchronous code in a synchronous manner
Promises are a common way to handle asynchronous operations
Callbacks can also be used for async programming, but can lead to callback hell
Utilize setTimeout and setInterval for delayed and repeated tasks
MCQ test consisting of 70 mcqs in 75 minutes from aptitude english and cs fundamentals. If cleared next paper 2 coding qs medium level
I faced challenges with integrating third-party APIs and debugging complex logic.
Difficulty in understanding and implementing third-party APIs
Issues with data synchronization between different systems
Troubleshooting complex logic errors
Managing dependencies and version conflicts
Time constraints affecting problem-solving
posted on 1 Oct 2024
I applied via Campus Placement
DP graphs strings it was good
Reverse a linked list by changing the direction of pointers
Start with three pointers: current, previous, and next
Iterate through the list, updating pointers to reverse the direction
Return the new head of the reversed list
The Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.
Start with two variables initialized to 0 and 1
Loop through desired number of iterations, adding the previous two numbers to get the next number
Print or store each number in the series
posted on 8 Aug 2024
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
Object-oriented programming concepts that focus on data encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: bundling data and methods that operate on the data into a single unit (class)
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
Abstraction: hiding the complex implementation details
Assistant Manager
3
salaries
| ₹4.2 L/yr - ₹5 L/yr |
Senior Business Development Manager
3
salaries
| ₹4.8 L/yr - ₹4.8 L/yr |
Finance Manager
3
salaries
| ₹9 L/yr - ₹10 L/yr |
Bajaj Finserv
Wells Fargo
JPMorgan Chase & Co.
HSBC Group