AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
BNY
Compare
Filter interviews by
BNY Database Manager Interview Questions and Answers
BNY Database Manager Interview Experiences
1 interview found
Anonymous
(4 Questions)
- Q1. What currently you are doing in your project?
- Ans.
I am currently leading a team in designing and implementing a new database system for our project.
Leading a team in designing a new database system
Implementing the new database system
Ensuring data integrity and security measures are in place
- Q2. How proficient you are in SQL?
- Ans.
I am highly proficient in SQL with extensive experience in writing complex queries, optimizing database performance, and designing database schemas.
Extensive experience writing complex SQL queries
Optimizing database performance through SQL
Designing database schemas using SQL
Familiar with advanced SQL concepts such as joins, subqueries, and indexing
- Q3. Why you have gap before MBA?
- Ans.
I took a gap to gain practical work experience and save money for my MBA.
To gain practical work experience relevant to my field of study
To save money for tuition and living expenses during my MBA program
To take a break and reassess my career goals before committing to further education
- Q4. Explain procedures from SQL.
- Ans.
SQL procedures are reusable blocks of code that can be called to perform a specific task.
Procedures are created using the CREATE PROCEDURE statement.
They can accept input parameters and return output parameters.
Procedures can be called using the EXECUTE or CALL statement.
They are used to encapsulate logic for tasks that need to be performed repeatedly.
Procedures can improve performance by reducing network traffic.
Skills evaluated in this interview
Interview questions from similar companies
Associate Interview Questions & Answers
JPMorgan Chase & Co.
SHUBHAM VINAYAK KALE shubham
posted on 4 Dec 2016
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Interview Questionnaire
8 Questions
- Q1. Project/DDP based questions
- Q2. Any coding done in curriculum, explain the most complex one
- Ans.
Yes, I have coded in curriculum. The most complex one was a project on building a web application using React and Node.js.
Built a full-stack web application using React and Node.js
Implemented user authentication and authorization using JSON Web Tokens (JWT)
Used MongoDB as the database and Mongoose as the ODM
Implemented real-time updates using Socket.IO
Deployed the application on Heroku
Handled errors and implemented log
- Q3. What is 'Big data'? Why is it called 'Big'
- Ans.
Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big data is characterized by its volume, velocity, and variety
It is used in various industries such as healthcare, finance, and retail
Examples of big data include social media data, sensor data, and transactional data
It is called 'big' because it involves processing massive amounts of data
Big data requires ...
- Q4. Why do you want to switch to IT sector from your respective branch
- Ans.
I am passionate about technology and eager to learn new skills in the IT sector.
I have always had a keen interest in technology and enjoy working with computers.
I believe the IT sector offers more opportunities for growth and advancement in my career.
I have seen the impact of technology on various industries and want to be a part of that innovation.
I have taken courses in programming and networking to prepare myself fo
- Q5. I did a course on compute simulation and had extra curricular in chess, so was asked to simulate a chess game
- Q6. Two friends A & B meet after long time, A asks B about his family. B says he has 3 children, product of their ages is 36, and sum of their ages is equal to the (point towards a house on street) house numbe...
- Q7. A rat has 3000 gm of rice, he has to travel a distance of 3000m, he eats 1gm rice/m, his maximum carrying capcity is 1000 gm,how should he travel the distance to reach with maximum rice left
- Q8. A new software has 3 functions SelectSum(), log() and exp(). You have a table of 1000 data points, how will you find product of all points using only the above mentioned functions
- Ans.
To find the product of all data points using SelectSum(), log(), and exp() functions.
Use the log() function to convert the product into a sum of logarithms
Apply the SelectSum() function to calculate the sum of logarithms
Finally, use the exp() function to convert the sum back into the product
Interview Preparation Tips
Experience: Aptitude part has easy questions, including number series, picture series, interest rate and some quant based questions.
The coding part is difficult.2-3 coding questions, Codes will be related to linked lists , trees or sorting.
Tips: Try to get maximum marks in aptitude, which should be fine with some practice . One of the code will be easy, so complete it and make a try for second
Duration: 1 hour
Total Questions: 30
Round: Puzzle Interview
Experience: very easy puzzles, I was able to solve all puzzles in first attempt
Tips: Be confident in your approach they are locking for approach more than result
Round: Technical Interview
Experience: I answered all resume based questions, he liked my choice of projects, though they were not exactly related to the profile. He liked me and said I would recommend you directly to HR round
Tips: Prepare in details about all points in resume, course work mentioned and projects, Based on performance in this interview, they decide to whether to take one more technical interview or send directly to HR
Skills: Behavioural Skills, Puzzle Solving Capability, Approaching A Problem, Basic Coding
College Name: IIT Madras
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Interview Questionnaire
13 Questions
- Q1. Tell me about yourself?
- Ans.
I am a highly motivated individual with a passion for learning and achieving my goals.
I have a degree in computer science and have worked as a software developer for 3 years.
I am proficient in multiple programming languages including Java, Python, and C++.
I enjoy working in a team environment and collaborating with others to solve complex problems.
In my free time, I enjoy hiking and exploring new places.
- Q2. Tell me about your family or life before college?
- Ans.
I grew up in a small town with my parents and younger sister. We were a close-knit family.
Grew up in a small town
Close-knit family
Parents and younger sister
Participated in community events
Enjoyed outdoor activities
- Q3. What do you do in free time?
- Ans.
I enjoy reading, hiking, and trying new recipes in my free time.
Reading books on various topics, including fiction, non-fiction, and self-improvement
Hiking in local parks and nature reserves to explore new trails and enjoy the outdoors
Experimenting with new recipes and cooking techniques in the kitchen
Attending cultural events such as concerts, plays, and art exhibits
Spending time with family and friends, playing board
- Q4. What would you expect from this company?
- Ans.
I would expect a supportive work environment, opportunities for growth and development, and a commitment to excellence.
Supportive and collaborative team culture
Clear communication and feedback
Opportunities for professional development and advancement
Commitment to high-quality work and customer satisfaction
Competitive compensation and benefits package
- Q5. Questions related to family and past life?
- Q6. Do you have any family member or friend in Bangalore?
- Ans.
Yes, I have a cousin who lives in Bangalore.
I have a cousin who has been living in Bangalore for the past 5 years.
We keep in touch and he has shown me around the city during my visits.
He works in the IT industry and enjoys the vibrant culture of Bangalore.
- Q7. How will you find loop in the circular linked list?
- Ans.
Loop in a circular linked list can be found using Floyd's cycle-finding algorithm.
Initialize two pointers, slow and fast, both pointing to the head of the linked list.
Move slow pointer by one node and fast pointer by two nodes in each iteration.
If there is a loop, both pointers will eventually meet at some point.
If there is no loop, fast pointer will reach the end of the linked list.
Time complexity of this algorithm is
- Q8. How will you perform pre-fix and post-fix operation for the given string expression?
- Ans.
Pre-fix and post-fix operations can be performed on a string expression using appropriate operators.
Pre-fix operation involves placing the operator before the operand in the expression.
Post-fix operation involves placing the operator after the operand in the expression.
Examples of pre-fix operators include ++, --, !, and ~.
Examples of post-fix operators include ++ and --.
- Q9. What is data analytics(cause I had mentioned it on the resume)? Just explain the basic and tell them how it can help us make decision/inference
- Ans.
Data analytics is the process of examining data sets to draw conclusions about the information they contain.
Data analytics involves collecting, cleaning, and analyzing data to identify patterns and trends.
It can help businesses make informed decisions by providing insights into customer behavior, market trends, and operational efficiency.
For example, a retail company can use data analytics to analyze sales data and ide...
- Q10. In my final year project I have used random forest. So he asked me to explain random forest. And other projects related questions
- Q11. What is your strength and weakness? why J P Morgan Chase? What do you expect from this company? I am from Mechanical Engineering, so she asked me why non-core?
- Ans.
Strengths include adaptability and teamwork. Weaknesses include public speaking. Non-core background allows for diverse perspective. JPMorgan Chase's reputation and opportunities attract me.
Strengths: adaptability, teamwork
Weakness: public speaking
Non-core background brings diverse perspective
Attracted to JPMorgan Chase's reputation and opportunities
- Q12. Few behavioral questions: What will you do if you have enough money and good idea to start your own company?
- Ans.
I would pursue my entrepreneurial dream and start my own company.
I would conduct market research to validate my idea and identify potential competitors.
I would create a business plan outlining my goals, strategies, and financial projections.
I would secure funding through investors or loans.
I would assemble a team of talented individuals with diverse skills and experiences.
I would continuously evaluate and adapt my busi
- Q13. How would you resolve team conflict between your idea and other idea, supported by majority?
- Ans.
I would listen to both sides, gather more information, and try to find a compromise that satisfies everyone.
Listen to both sides and understand their perspectives
Gather more information about both ideas
Try to find common ground and a compromise that satisfies everyone
Encourage open communication and respect for each other's ideas
Consider the potential impact and benefits of each idea
Involve a neutral third party if nec
Interview Preparation Tips
Experience: The company came to our campus on day 3 and agreed to take walk-ins.
Therefore resume shortlisting was the procedure.
They had a cut off of 7 CGPA.
Tips: It would be good if you have some coding background with few projects. It could anything from class projects to your internships, extra-curricular or final year projects. Don't forget to mention what all programming language you know on your resume.
Round: Technical + HR Interview
Experience: The first round consists of two panels. One of them was asking HR. And the other was asking technical questions. They were just looking whether you have the basic technical knowledge and if given an offer you will join or not.
Tips: For technical knowledge, you can refer OOPs basic concepts, standard coding interview problems, geeksforgeeks, cracking the coding interview by Laxman Gayle etc. It would be better if you can first practice hr questions among your friends instead of going directly to interview. I found a youtube channel explains technical relatively easier and simpler way. you can follow that. Just try to show that you are interested in that company.
For HR questions, one can prepare from 64 HR questions.
For the basic OOPs concepts, one can read first 10 chapters from E.Balaguruswamy but any other OOPs book will also be fine.
Confidence is the key ace any interview!!
Round: HR Interview
Experience: This round was mainly to check your personality. He was trying to know whether you will fit in the company or not. Most of the question was from my personal life. They will see whether you are serious about your life or not.
Tips: Be ready to give them instances of your life where you did things differently. Try to show that you are passionate about the company. Try to show you have a clear vision in your life and working hard to achieve that.
Round: HR Interview
Experience: This round was just a formality. The HR from the second round interview introduced me to the third interviewer. He asked few question related to the family.
Tips: One important thing I would like to is that NEVER ASSUME THAT WHATEVER YOU TOLD TO YOUR PREVIOUS INTERVIEWER WILL BE KNOWN TO THE NEXT INTERVIEW. So, if you think some specific points will help you do good in an interview...just let him know. I could be anything your project, conference, paper presentation or your past life as well.
Skills: Programming, Object Oriented Programming (OOP) Basics, Team Working Ability, Passion, Data Strrutures, Algorithm
College Name: IIT Madras
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Dec 2016. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Tested DSA and Aptitude
- Q2. Checked design aspect questions
- Q3. What do you know about company
- Ans.
Company is a global technology company known for its innovative products and services.
Founded in 1976 by Steve Jobs, Steve Wozniak, and Ronald Wayne.
Known for products such as iPhone, iPad, Mac computers, and Apple Watch.
Offers services like Apple Music, iCloud, and Apple Pay.
Has a strong focus on design and user experience.
Interview Preparation Tips
Shubham Jain
I was interviewed in Dec 2016.
Interview Questionnaire
5 Questions
- Q1. Write the algorithm for reversing the string
- Ans.
The algorithm reverses a given string.
Iterate through the string from the last character to the first character.
Append each character to a new string or an array in reverse order.
Return the reversed string or array.
- Q2. Write an algorithm to select the number between min and maximum from a number series and that number shouldn't be a multiple of 10
- Q3. This was puzzle: you have 2 eggs and 100 floors. Eggs will start break beyond a particular floor. You can throw eggs from any of the floor. How will you minimise the total number of throws.
- Q4. Assume yourself as CEO of a company. You have vacancies and you are conducting interviews. 4 candidates (1. An IITian, 2. A woman, 3. Gay, 4.Physically handicapped) are equally capable and qualified have a...
- Ans.
As the CEO, I would select the candidate based on their qualifications and skills, regardless of their background or personal characteristics.
I would focus on the qualifications, skills, and experience of each candidate.
I would consider their ability to contribute to the company's goals and objectives.
I would ensure a fair and unbiased selection process.
I would prioritize diversity and inclusion in the workplace.
I woul...
- Q5. My interview was just after demonetization. So question was, assume you are CEO of Paytm. What will be your key values and what will be your strategy to add more customers.
Interview Preparation Tips
Experience: Aptitude part was pretty straightforward. Make sure you don't loose too much time on one question. Most of the questions were very easy. Number series, men working hours, probability and simple math calculations are enough to crack the test.
Coding part will definitely have one easy question (mostly will be on sorting algos). Basic coding knowledge is enough for this part.
Tips: Aptitude : Speed is the key. Since questions are easy, one who gets more than others will be shortlistled for the Interviews.
Coding: Make sure you solve atleast 1 problem correctly. And then try to attempt others.
Duration: 1 hour
Total Questions: 28
Round: Behavioural Interview
Experience: They also asked basic interview hr questions. Be prepared with your stories. If One of your story can make you look out of the stand, it will definitely work for this round. Strengths, weakness and where do you see yourself after 5 years.
Tips: Be confident. And be ready to defend your answers.
Skills: Math Puzzles, Algorithms And Data Structures, HR Skills, Inter Person Communication Skills
College Name: IIT Madras
Skills evaluated in this interview
Sachin Aglave
Interview Questionnaire
4 Questions
- Q1. Tell me about your internship, B.Tech project(BTP), CV
- Q2. Implement LRU cache.
- Ans.
Implement LRU cache
LRU stands for Least Recently Used
It is a cache eviction policy that removes the least recently used item
It can be implemented using a doubly linked list and a hash map
Newly accessed items are moved to the front of the list
When the cache is full, the item at the end of the list is removed
- Q3. What is virtual memory? Will we need virtual memory even if we have infinite amount of RAM?
- Ans.
Virtual memory is a memory management technique that allows a computer to use more memory than it physically has.
Virtual memory uses a combination of RAM and hard disk space to store data.
It allows programs to use more memory than is physically available.
If a program tries to access memory that is not currently in RAM, it will be swapped in from the hard disk.
Even if we had infinite RAM, virtual memory would still be n...
- Q4. Given an array, Find out maximum length of subarray where max of subarray <= 2*min of subarray
- Ans.
Find maximum length of subarray where max <= 2*min.
Iterate through array and keep track of max and min values.
Update max length when condition is met.
Time complexity: O(n)
Interview Preparation Tips
Experience: No CPI cut off and It was open for all departments.
Round: Test
Experience: In muliple choice question Mostly questions were base on maths, probability, c programs, algorithms, Systems. If you are prepared then Questions were not that much tough. Keep strong concepts of Operating systems. For subjective part, Some problems were from maths proofs, some were from probability, some were from algo. We had to write algorithms. etc
Duration: 180 minutes
Round: Problem Statement
Experience: Questions were doable.
Round: Interview
Experience: Everyone was cool, They made me feel comfortable and then started asking questions.
Tips: If you have good rank in online coding competition, do mention it in CV.Most of the students think that GS asks only probability-puzzles. They did not asked me any question on probability or puzzle. Everything they asked was based on Algorithms problems and Operating system. I think it depends on team for which they are hiring. Most important point is don’t lose hope because you have low CPI or you are not good at something. Keep Operating systems fundamental concepts strong.
General Tips: We should balance in Placement and Compititive online coding. Keep in mind Placements and Compititive online coding are some what different things. Keep on improving our mistakes on daily basis. I would strongly suggest you to do introspection daily it will help you to find out your weaknesses and strong points, where we are going wrong etc. There are two thing on which we shoud focus.1. Preparation (I have told everything requered for preparation).2. Get output of all hard work. How to keep our mind on 100% output while the actual exam(placement).For this, I used to go for physical exercise daily in the morning and medidate for 20-30 minutes. Along with exercise i used to do Sudarshan Kriya(Art of Living). Meditation has lot of power :).
Skill Tips: Keep your OS fundamentals strong. To improve codgin skills practice as many problems as you can. Regularly participate in online coding competitions it really helps to solve or approach any new problem. Many time instead of correct answer the approach to solve the problems is very important. How you think, How you approach the problem is checked in interview.
Skills: Coding Skills, Operating Systems , Problem solving skills
College Name: IIT Guwahati
Motivation: The name GS itself enogh for motivation.
Skills evaluated in this interview
I was interviewed before Mar 2021.
(3 Questions)
Round duration - 60 minutes
Round difficulty - Medium
Technical round with questions on DSA and OS.
- Q1.
LRU Cache Design Problem Statement
Design and implement a data structure for a Least Recently Used (LRU) cache that supports the following operations:
get(key)- Retrieve the value associated with the...
- Ans.
Design and implement a Least Recently Used (LRU) cache data structure that supports get and put operations with a specified capacity.
Implement a doubly linked list to keep track of the order of keys based on their usage.
Use a hashmap to store key-value pairs for quick access and updates.
When a key is accessed or updated, move it to the front of the linked list to mark it as the most recently used.
When the cache reaches...
- Q2.
Maximum of All Subarrays of Size K
Given an array of non-negative integers and an integer K representing the length of a subarray, your task is to determine the maximum elements for each subarray of size ...
- Ans.
Find the maximum elements for each subarray of size K in a given array.
Iterate through the array and maintain a deque to store the indices of elements in decreasing order.
Pop elements from the deque that are out of the current window.
Keep track of the maximum element in each subarray of size K.
Return the maximum elements for each subarray.
- Q3. What is virtual memory?
- Ans.
Virtual memory is a memory management technique that allows a computer to compensate for physical memory shortages by temporarily transferring data from RAM to disk storage.
Virtual memory allows programs to use more memory than is physically available on the system.
It helps in multitasking by allowing multiple programs to run simultaneously without running out of memory.
Virtual memory uses a combination of RAM and disk...
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.
Interview Preparation Tips
Experience: Practice questions on Indiabix.
Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics
General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.
Interview Preparation Tips
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.
Round: Technical + HR Interview
Experience: There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products. The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.
Round: Case Study Interview
Experience: The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study:
Interview Questionnaire
2 Questions
- Q1. Demonetization
- Q2. Banking sector questions
Interview Preparation Tips
Experience: Basic aptitude test. East to clear.
Duration: 1 hour
Total Questions: 25
Skills: Reasoning Ability, Mathematical Logic, Logical Reasoning, General Knowledge
College Name: Sri Bhagawan Mahaveer Jain
BNY Interview FAQs
Tell us how to improve this page.
BNY Interviews By Designations
- BNY Senior Associate Interview Questions
- BNY Software Developer Interview Questions
- BNY Analyst Interview Questions
- BNY Intermediate Representative Interview Questions
- BNY Associate Interview Questions
- BNY Senior Analyst Interview Questions
- BNY Senior Representative Interview Questions
- BNY Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Database Admin Interview Questions
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Database Analyst Interview Questions
- Database Administrator DBA Interview Questions
- Senior Database Administrator Interview Questions
- SQL Database Developer Interview Questions
- Show more
BNY Database Manager Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Analyst
1.9k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Analyst
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
1.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Intermediate Representative
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Vice President
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
State Street Corporation
Northern Trust
HSBC Group
JPMorgan Chase & Co.
- Home >
- Interviews >
- BNY Interview Questions >
- BNY Database Manager Interview Questions
