Bank of America Interview Experience

Round 1: Technical interview: Duration: approx. 30 min, Difficulty level: Medium
Questions/Topics asked in Detail: 

• Introduce yourself
• Project explain 
• Copy constructors
• Programming question:
  • Write a SQL query to find the 2nd maximum salary of an employee from a particular department
  • Write a C++ program to check whether a given number is prime or not.
  • Write a C++ program to find the sum of each digit in a no. eg. IP = 123, op = 6 (1+2+3)
• Difference between dropping and deleting a command
• What is concurrency control?
• Linux commands

Round 2: Technical Interview/ HR: Duration: approx. 30 min. Difficulty level- Medium. Questions/Topics asked in Detail:

• Introduce yourself
• Project explain (in detail)
• Question-related to project technology that you used in the project.

SQL queries: Related to joins and count(), Keys, Situational questions:

• Suppose in our team everyone has different ideas related to our upcoming project so as a team leader how do you handle this situation?
• Have Ever you faced a tense situation in your life and overcome that situation?

Personal Experience: Also mention (Important Subjects/Topics to study)

• Make SQL basic concept strong.
• Coding question difficulty lies between easy to medium.
• DBMS and OS are important subjects.