3rd Round(Technical Round-2)

  • It was also an online technical round and the interviewer was strict.
  • Technical Questions asked:
    • Create a table for students, teachers, and courses for college and explain the relationship between them.
    • How will you choose primary key and foreign key in student table.
    • What are the various types of relationships in SQL ?
    • I was unable to answer the most of the questions from SQL, then the interviewer told me a good developer should have a command on SQL.
    • Then he asked me one puzzle (pattern in number series).
    • At last he asked me 2 easy coding questions and I was able to solve both of them.

Result: Not Selected

Suggestions:

  • Prepare SQL in depth and practice queries on joins.

Coditas Interview Experience(On Campus) | 2024 Passout Batch

Similar Reads

1st Round(Group Discussion):

It was an online group discussion round and the eligible students were divided into groups with each group having 4-5 students. For each group, there was a different topic provided by the interviewer. At a time only one group was asked to join the meeting for group discussion. After that, the interviewer provided the topic for group discussion. The topic for our group was “Pune or Pimpri-Chinchwad, which is better ?”. The interviewer was given 5 minutes to think about the topic and one by one students had to put their thoughts on the topic. The students who cleared this round were selected for 2nd round....

2nd Round(Technical Round-1):

It was an online technical round and the interviewer was so polite. He asked me to introduce yourself Technical Questions asked: Write down a code to find the second maximum element in the array. Basic Questions on SQL Do you know about OOPS? Give me HLD for your society. 4 pillars of OOPS. What is DSA? Explain Stack, Queue, Linked List, Tree. (Basics only). This interview went for 25-30 minutes and the students who cleared this interview were selected for 3rd round....

3rd Round(Technical Round-2):

It was also an online technical round and the interviewer was strict. Technical Questions asked: Create a table for students, teachers, and courses for college and explain the relationship between them. How will you choose primary key and foreign key in student table. What are the various types of relationships in SQL ? I was unable to answer the most of the questions from SQL, then the interviewer told me a good developer should have a command on SQL. Then he asked me one puzzle (pattern in number series). At last he asked me 2 easy coding questions and I was able to solve both of them....