Round 1: Aptitude Test
The first round of the interview process was an aptitude test. It consisted of multiple-choice questions covering quantitative aptitude, logical reasoning, and verbal ability. The difficulty level was moderate, and time management was the key to clearing this round.
Round 2: Technical Interview
After clearing the aptitude round, I moved on to the technical interview. The interviewer started by asking me to introduce myself. I gave a brief introduction, education, technical skills, and interests.
Next, he asked me to explain my project. I described my latest project, explaining its objective, technology stack, challenges faced, and how I overcame them. The interviewer seemed interested and asked a few follow-up questions about specific features of my project.
Coding Question in Java
After the project discussion, the interviewer asked me to write a Java program to check if any word from an array is present in a given string. I quickly wrote the program and explained my approach.
Here’s the Java code I wrote:
public class WordInStringCheck {
public static boolean containsWord(String[] words, String input) {
for (String word : words) {
if (input.contains(word)) {
return true;
}
}
return false;
}
public static void main(String[] args) {
String[] words = {"hello", "world", "java", "interview"};
String input = "This is a java programming interview.";
if (containsWord(words, input)) {
System.out.println("The input string contains at least one word from the array.");
} else {
System.out.println("No words from the array were found in the input string.");
}
}
}
The interviewer was satisfied with my solution.
DBMS and SQL Discussion
After the coding question, the interviewer moved on to database management systems (DBMS) and SQL. He asked me to give an introduction to DBMS and SQL, where I explained:
DBMS: A software that allows users to create, retrieve, update, and manage data efficiently.
SQL: A structured query language used to interact with databases.
SQL Query Writing
Finally, the interviewer gave me a scenario and asked me to write an SQL query. The problem was:
write a query to count the number of employees in each department.
I wrote the following query:
SELECT department COUNT(*) AS employee_count FROM employee GROUP BY department;
The interviewer appreciated my answer and my interview ends here.