BNY Interview Questions, Process, and Tips

Q1. Tell me about yourself
Ans. 
I am a motivated and detail-oriented individual with a passion for learning and problem-solving.
• I have a strong academic background in computer science and have completed several internships in the tech industry.

• I am proficient in programming languages such as Java, Python, and SQL.

• I have experience working on projects involving data analysis and machine learning.

• I am a quick learner and enjoy taking on new challenges.
Answered by AI
Add your answer
Q2. Why do you want this job
Ans. 
I am passionate about helping individuals with disabilities and want to gain hands-on experience in the field.
• Passionate about helping individuals with disabilities

• Seeking hands-on experience in the field

• Interested in learning more about SSD services and support
Answered by AI
Add your answer

Q1. Why do you want to work at bny
Ans. 
I want to work at BNY because of its reputation for innovation and commitment to excellence in the financial industry.
• BNY has a strong reputation for innovation and excellence in the financial industry

• I am impressed by BNY's commitment to diversity and inclusion

• I believe BNY offers great opportunities for professional growth and development
Answered by AI
Add your answer
Q2. Tell be about a time you struggles
Ans. 
I struggled during my first semester of college due to the transition from high school and the workload.
• Transitioning from high school to college was challenging

• Struggled to balance coursework and extracurricular activities

• Sought help from professors and peers to improve study habits
Answered by AI
Add your answer

60 minutes 60 Questions, quite easy

Q1. My role in project
Add your answer
Q2. What are the joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the righ...read more
Answered by AI
Add your answer

Q1. Normalization, types and needs
Add your answer
Q2. Prime number code in my day to day language
Ans. 
A prime number code is a program that identifies and prints out prime numbers in a given range.
• Identify prime numbers using a loop and checking for factors

• Print out the prime numbers found in the range

• Handle edge cases like 0 and 1 not being prime numbers
Answered by AI
Add your answer

Q1. SQL query by screen sharing, like where and group by
Add your answer
Q2. What do you know about bny
Add your answer

Hacker rank test for Java programming codes

Q1. Java Spring boot annotations
Add your answer
Q2. Java basics question
Add your answer

Topics that where coverd in MCQ test are OS, DBMS, OOPS, AND some CS fundamentals

Q1. What is #include
Ans. 
The #include directive is used in C and C++ programming languages to include the contents of another file in the current file.
• Used to include header files that contain function prototypes and declarations

• Improves code organization and reusability

• Example: #include includes the standard input/output library in the current file
Answered by AI
Add your answer
Q2. What are pointers
Ans. 
Pointers are variables that store memory addresses of other variables in programming languages like C and C++.
• Pointers are used to directly access and manipulate memory locations.

• They are often used for dynamic memory allocation and deallocation.

• Pointers can be used to pass variables by reference to functions.

• Example: int *ptr; // declaring a pointer variable
Answered by AI
Add your answer
Q3. What is main difference between Java and cpp
Ans. 
Java is platform-independent, object-oriented language while C++ is platform-dependent, procedural language.
• Java is platform-independent, meaning it can run on any platform with the help of Java Virtual Machine (JVM)

• C++ is platform-dependent, meaning the code needs to be compiled separately for each platform

• Java is an object-oriented language with features like inheritance, encapsulation, and polymorphism

• C++ is a proce...read more
Answered by AI
Add your answer