Filter interviews by
Clear (1)
I applied via Campus Placement and was interviewed in Sep 2023. There were 2 interview rounds.
It was good but prepared on technical basis
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is unique
It can be a single column or a combination of columns
Primary key values cannot be NULL
Example: In a table of students, student ID can be a primary key
Foreign key is a column or a set of columns in a table that uniquely identifies a row in another table.
A foreign key establishes a relationship between two tables in a database.
It ensures referential integrity by enforcing a link between the data in the two tables.
Foreign key constraints prevent actions that would destroy links between tables, such as deleting a row that is referenced by another table.
Example: In a dat...
Top trending discussions
I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 2 interview rounds.
posted on 14 Mar 2015
I applied via LinkedIn and was interviewed before Aug 2020. There were 4 interview rounds.
I applied via Company Website and was interviewed in Jul 2020. There were 4 interview rounds.
Java 8 introduced several new features including lambda expressions, streams, and default methods.
Lambda expressions allow for functional programming and concise code.
Streams provide a way to process collections of data in a parallel and functional manner.
Default methods allow for adding new functionality to interfaces without breaking existing implementations.
Method references provide a way to refer to methods without...
Customised immutable java class can be written by declaring all fields as final and not providing any setters.
Declare all fields as final
Do not provide any setters
Provide a constructor to initialize all fields
Override equals() and hashCode() methods
Make the class final
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
Bigdata systems architecture involves distributed storage, processing, and analysis of large volumes of data.
Utilize distributed file systems like HDFS for storage
Use parallel processing frameworks like Apache Spark or Hadoop for data processing
Implement data pipelines for ETL processes
Leverage NoSQL databases like Cassandra or MongoDB for real-time data querying
Consider data partitioning and replication for fault tole
Big data system distribution for storage and compute involves partitioning data across multiple nodes for efficient processing.
Data is partitioned across multiple nodes to distribute storage and processing load.
Hadoop Distributed File System (HDFS) is commonly used for storage distribution.
Apache Spark utilizes a cluster computing framework for distributed computing.
Data locality is important to minimize data transfer ...
Morgan Stanley is a top-tier investment bank with a strong reputation for innovation and excellence.
Morgan Stanley has a long history of success in the financial industry
The company is known for its innovative approach to investment banking
Morgan Stanley has a strong reputation for excellence in research and analysis
The firm offers a wide range of services to clients, including wealth management and investment banking
M...
Tower and Morgan Stanley are both financial services companies.
Tower is a global investment management firm with over $1 trillion in assets under management.
Morgan Stanley is a multinational investment bank and financial services company.
Both companies offer a range of financial services including wealth management, investment banking, and asset management.
Tower is known for its focus on sustainable investing, while Mo...
The job profile offered is for an analyst position. A PhD is not required for this role.
The job involves analyzing data and providing insights to clients
A PhD is not necessary as the role focuses more on practical application of analytical skills
The job may require a bachelor's or master's degree in a related field
Examples of job responsibilities may include data collection, statistical analysis, and report writing
Innovations to minimize cost of pen
Use recycled materials for pen body and ink
Simplify design to reduce production costs
Implement refillable ink cartridges to reduce waste and cost
Partner with companies for bulk purchasing of materials
Automate production process to reduce labor costs
Prove N>=N^.5+N^(1/3)+N^(1/4) for N>=a
Use AM-GM inequality
Substitute N with a and prove the inequality holds
Use calculus to find the minimum value of the expression
Finding the probability distribution for the minimum of two random variables with given distributions.
Use the formula P(min(x,y)>z) = P(x>z)P(y>z)
Integrate over the range of z to get the distribution of min(x,y)
Final distribution is 2ke^(-kx)ue^(-ux)exp(-uz)
Given prob. p of dying out and prob. (1-p) of spawning into 2, find prob. of dying out starting from 1 organism.
Use probability tree to visualize outcomes
Probability of dying out starting from 1 is p + (1-p) * (probability of dying out starting from 2)^2
Solve recursively to get final answer
Probability of a rectangle being inside a unit circle with p chosen uniformly on the circle and q inside the circle.
The probability can be found by calculating the ratio of the area of the rectangle to the area of the circle.
The area of the circle is pi and the area of the rectangle can be found using the distance between p and q.
The probability is 1/4.
Example: If the distance between p and q is 0.5, then the area of t...
Find local minima of an array in o(log n) in functional programming.
Use binary search to find the local minima.
Check if the mid element is a local minima, if not, move towards the lower side.
If the mid element is greater than its left element, move towards the left side, else move towards the right side.
Repeat until a local minima is found.
Example: [5, 3, 2, 4, 6, 8, 9] -> local minima is 2.
Code to sort a list without pipes
Use a sorting algorithm like bubble sort, insertion sort, or selection sort
Implement the algorithm in the programming language of your choice
Test the code with different input sizes and types
To find an even length palindrome in a string in O(n), we can use the two-pointer approach.
Initialize two pointers at the center of the string.
Expand the pointers outwards while checking if the characters at both pointers are equal.
If they are not equal, return the previous substring as the even length palindrome.
If the pointers reach the end of the string, return the entire string as the even length palindrome.
Possible values of determinant of matrix A given Avi=Vj for n linear vectors
The possible values of |A| are non-zero as the given vectors are linearly independent
The value of |A| can be calculated using the formula |A| = (-1)^n * det(A)
If the given vectors are orthogonal, then |A| is the product of the magnitudes of the vectors
A and B play a game with unfair coin. A wins if # of heads > #tails +1 at any point. Find prob. of A winning.
The game is played with an unfair coin with P[Heads]=p
A wins if # of heads > #tails +1 at any point
Find the probability of A winning
Find two elements in a sorted array that add up to a given sum in linear time.
Use two pointers, one at the beginning and one at the end of the array.
If the sum of the two pointers is greater than the target, move the right pointer to the left.
If the sum of the two pointers is less than the target, move the left pointer to the right.
Repeat until the sum is found or the pointers meet.
Example: Given [1, 2, 3, 4, 5] and ta
The probability of element at 20th position landing up at 31st position after the first iteration.
The probability depends on the size of the dataset and the algorithm used for iteration.
If the algorithm involves swapping adjacent elements, the probability is higher.
If the dataset is sorted in a way that the element at 20th position is adjacent to the element at 31st position, the probability is 1.
The probability can be...
Expected number of collisions between randomly moving ants on a rod after 30 seconds.
Calculate the probability of two ants colliding at any given time.
Use the formula for expected value to find the expected number of collisions.
Assume that the ants are point masses and collisions are perfectly elastic.
Consider the possibility of multiple ants colliding at the same time.
Simulation can also be used to estimate the expect
Counting permutations where numbers between u and i+1 are less than i for all i in the permutation.
The first number in the permutation must be 1.
For each i in the permutation, all numbers between u and i+1 must be less than i.
Use dynamic programming to count the number of valid permutations.
The answer is (n-1)th Catalan number.
Example: for n=4, the answer is 5.
Finding f(n) for a normal standard distribution with a given constant k.
Calculate the product of probability density function and cumulative distribution function.
Integrate the product of f(x) and F(kx) from -inf to +inf.
The value of k is a constant greater than 0.
Number of inversions in an array in O(nlogn) time.
Use merge sort algorithm to count inversions
Divide the array into two halves and recursively count inversions
Merge the two halves and count split inversions
Time complexity is O(nlogn)
I applied via Referral
based on 1 interview
Interview experience
Senior Associate
4.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate2
3.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
1.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
1.8k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate
1.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
BNY
Northern Trust
Blackrock
JPMorgan Chase & Co.