So this was an on-campus opportunity. The first round was online and had two parts: the aptitude round plus some technical questions, and then an OA round, which had fairly easy questions.

135 were selected after the first round.

The second round was an F2F interview round, in which there was an 8-panel of members, each from HSBC. After this, there was an HR round.

1. Tell me about yourself.

2. Preferred language: C++ or Java?

3. Can you learn Java in one month if given a chance?

4. Can you connect to the SQL database through C++?

5. An easy output question based on pre-increment and post-increment operators.

6. A scenario-based question on a cloud garage that initially had a primary key order_id which was varchar(10), but after the orders increased, it had to be changed to varchar(20) or maybe varchar(30). So, is the ALTER command sufficient, or might we face some other problems? (Basically, can it be done in one day?)

7. What is unstructured data?

8. Is SQL good for handling very vast amounts of data?