Problem of the day
Tip 1 : Practice at least 5-7 Codes daily from the beginning of preparation.
Tip 2 : Be thoroughly prepared with concepts of Data Structure, Database and Operating System
Tip 3 : Always go through the Company's Job description and About the Company and prepare your answers according to that
Tip 4 : Only mention Projects that you've complete idea about.
Tip 1 : Have a few Projects on your resume and make sure you know it all about your Projects.
Tip 2 : Only mention the Skills you feel you are confident about. Never lie on your resume.
This round was scheduled for 9am in the morning. The test environment was pretty good . I didn't face any issues on the HireVeu platform. The first test was of Aptitude and then in next section it was Technical MCQ's. The level of questions were mid to high level of difficulty.
What is DML and DDL?
Write an SQL query to print the FIRST_NAME from Worker table after replacing ‘a’ with ‘A’.
Write an SQL query to print details of the Workers whose FIRST_NAME contains ‘a’.
What is Normalization?
Tip 1: Do practice SQL Queries
Tip 2: Read Database Normalisation and Transaction.
Tip 3: Read Raghu Ram Krishnan thoroughly
The exam was on the same Platform. The first question was about the most difficult Project I've worked on. I have to record a video in that particular platform and then move to the next questions. There was option for a demo video of 1 minute in which you can practice your answers and then can record your answer in the next video of max 5 minutes. The next 2 question were Coding Problems of moderate difficulty and you've to record your approach and then proceed towards solving the code and then record a video stating if you succeed or not and what better could you've done to make it work.
Run a loop from 10^(n-1) to 10^(n) – 1 and check when the current number is palindrome or not. If it is, adds its value to answer.
This round was scheduled for 3pm. The interviewer was quite friendly. He asked about me and told me to relax and then answer. He started with asking questions from my Project and how the ideas behind the Project. My Project was related to Deadlock So he asked whether I can implement my Project on any environment. I answered . Then one of my internship Project was related to Web development so He asked me about the backend of the Project. He gave me a few SQL queries and some general DBMS concepts based on the response about using Mysql in the Project. He asked me a few things about AWS and Cloud Computing which I answered. At last he asked some LINUX commands and corrected me once and was satisfied with my answers.
1) What is Kernel?
2) What is Deadlock?
3) Why you use Binary semaphores instead of Counting Semaphores?
4) What is threads? What is hardware thread?
5) What is TLB?
Tip 1 : Read Galvin for OS thoroughly
Tip 2 : Practice MCQ's from GFG OS QUIZ Section
1) Explain DDL VS DML.
2) Explain Normalization
3) B+ Trees and it's working.
Tip 1 : Do practice SQL queries
Tip 2 : Give answers to Normalisation questions with examples for each
Tip 3 : Keep a paper with you while giving interview from home. Comes handy when I tried explaining B+ trees to him.
It was late evening that I got a call from the HR team. They told me that they are satisfied with my Technical skills and asked me which role I would like to work for - Software Developer or System engineer. I was fine with both. Then they asked about location preferability and wished me luck for the results.