i
Smollan Group
Filter interviews by
Triggers are special types of stored procedures that are automatically executed when certain events occur in a database.
Triggers are used to maintain referential integrity, enforce business rules, and automate actions in a database.
They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
Examples of triggers include auditing changes to a table, updating a related table when a record is
Stored procedures are precompiled SQL queries stored in a database for reuse.
Stored procedures are used to perform specific tasks or operations in a database.
They can improve performance by reducing the amount of data sent between the database and application.
Stored procedures can be called from within other SQL queries or from application code.
They can also help with security by controlling access to data and enforcin
Top trending discussions
Algorithms for manipulating arrays and strings in coding
Use sorting algorithms like quicksort and mergesort for arrays
Use string manipulation functions like substring and replace for strings
Use dynamic programming for optimizing solutions to array and string problems
Designing a large scale Ad Server
Use distributed systems for scalability
Implement caching for faster ad delivery
Ensure high availability and fault tolerance
Use real-time bidding for efficient ad placement
Implement fraud detection mechanisms
Ensure compliance with privacy regulations
I applied via Campus Placement
I am an avid traveler and have visited over 20 countries
I love experiencing new cultures and trying new foods
I have backpacked through Europe and Asia
I have volunteered in orphanages in Cambodia and Nepal
Mobile advertising platform
Adtech
Mobile marketing
App monetization
Maximum sub sequence sum in an array
Use Kadane's algorithm
Initialize max_so_far and max_ending_here to 0
Iterate through the array and update max_ending_here and max_so_far
Return max_so_far
Endianness refers to the byte order of a system. It determines how multi-byte data types are stored in memory.
Little-endian systems store the least significant byte first, while big-endian systems store the most significant byte first.
Endianness can affect the way data is transmitted between systems.
To determine the endianness of a system, you can use the byte order mark (BOM) or write a test program that checks the by...
Sort an array of 0's and 1's only.
Use two pointers, one at the beginning and one at the end of the array.
Swap 0's from the beginning with 1's from the end until the pointers meet.
Alternatively, use a counting sort algorithm to count the number of 0's and 1's and then reconstruct the array.
Heaps are data structures used to efficiently find the maximum or minimum element in a collection.
Max heap: parent nodes are always greater than or equal to child nodes
Min heap: parent nodes are always smaller than or equal to child nodes
Heaps are commonly used in priority queues and sorting algorithms
Heap operations include insert, delete, and extract max/min
Example: An array [3, 8, 2, 5, 1, 4, 6] can be represented a
Find 3 numbers in an array where a+b=c.
Loop through the array and check for all possible combinations of a and b.
Use a hash table to store the values of a and b, and check if c is present in the hash table.
Sort the array and use two pointers to find a and b, and then check if their sum equals c.
The program capitalizes the first letter of each reversed word in a sentence.
Split the sentence into an array of words using space as a delimiter.
Reverse each word in the array and capitalize the first letter.
Join the modified words back into a sentence.
posted on 9 Oct 2024
Two Medium DSA questions, then questions about react and springboot
DSA - Linked List, Trees
I applied via Referral and was interviewed in Oct 2022. There were 4 interview rounds.
Printing the right view of a tree using recursion and level order traversal.
Recursively traverse the right subtree first and then the left subtree.
For level order traversal, use a queue to store nodes at each level.
Print the rightmost node at each level.
Example: For tree 1-2-3-4-5, the right view is 1-2-4-5.
I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.
Calender, time, relationship
I applied via Job Portal
It was a virtual coding round with coding questions on Java fundamentals, Array, LinkedList
Questions on java fundamentals, some code snippets, Array
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Sales Executive
111
salaries
| ₹1.6 L/yr - ₹4.2 L/yr |
Marketing Executive
90
salaries
| ₹1.4 L/yr - ₹3.8 L/yr |
Team Lead
85
salaries
| ₹2.1 L/yr - ₹6.2 L/yr |
Field Manager
68
salaries
| ₹5.2 L/yr - ₹13.5 L/yr |
Rural Sales Promoter
61
salaries
| ₹1.3 L/yr - ₹3.2 L/yr |
Epsilon
Denave
Regalix
Dentsu Aegis Network