JustDial SQL Database Administrator Interview Questions and Answers

Round: Test
Experience: Questions can be found here:

-----/
Tips: Try to solve all 3.
Duration: 60 minutes
Total Questions: 3

Round: Technical Interview
Experience: First discuss the solution and then paper-code it.
Tips: Try to code without mistakes.

Round: Technical Interview
Experience: First, I was asked to discuss my project based on networking and then I was given a question on network programming
Tips: Pay attention on discussion

Round: Technical Interview
Experience: Provide the optimised solution and code it without any mistakes.

Round: HR Interview
Experience: Why linkedin?
What changes will you make in 6 months?
Internship project: Discussion and lot of common questions on that.
Basic Questions of C++ and Java

Skills: Data Structure, Core courses understanding, Algorithms
College Name: IIT GUWHATI

Round: CODING ROUND
Experience: In the coding round there were 3 questions to be solved in about 3 hrs.

Round: HR Interview
Experience: Expect the usual crazy questions like "Why LinkedIn?" and if you are already placed, be ready to give a proper justification for "Why LinkedIn and not XYZ?" so on. Be cool, you need not be accurate. Be well prepared with your resume and expect questions from them.
Tips: For the interview, just be confident and have a good resume ready with you.

Round: Other Interview
Experience: Coding Interview:
Simple coding questions. Make sure you first explain the logic to them and then you may be asked to write the code for it on the board using any language of your choice. Syntax is not a big deal, but don't make any logical errors. They are very friendly and may suggest certain solutions of their own. Make sure you can grasp them quickly. Find faults in your own code before they find it. Always try to give the best optimal solution. In case you are unable to do so then suggest possible improvements.

Round: Other Interview
Experience: Design Interview:
Some people may find this round a bit uneasy. But this round tests how good you are at designing solutions to problems. Most of the candidates were asked to build an online gaming system. And then they keep adding extra constraints and ideas and see if you can integrate them to your design. Database knowledge may be tested. They may also ask questions pertaining to you projects listed in your resume.

General Tips: An updated LinkedIn account with decent connections. ;)
Skill Tips: Be very strong with your coding ability. Whenever you code, do follow some standard procedures and make the code look simple and structured. Whenever you solve a coding question make sure you answer it completely for all the test cases. Partial results will only indicate that there is something wrong with the logic. Try to solve a complete question rather than multiple questions with partial results.
College Name: NIT SURATHKAL

General Tips: It might help in general to try to become a better developer at all times. One way to get good at it is to really enjoy what you do!Do random projects, use linux, Read Hacker News (-----/)  daily and wear hippie computer t-shirts (:-P) - Interviewers really LOVE talking about these, especially HR rounds (my HR interviewer was also a programmer).
College Name: NIT SURATHKAL

Round: Technical Interview
Experience: It started with an informal talk after he gave his introduction. We talked about the cyclone that was going to be there and what I did in my internship and my previous projects. Then we moved to questions. After solving both questions he asked if I had questions.
Tips: Just walk the interviewer through the solution you're proposing.

Round: Other Interview
Experience: He started with a design question with how to stream an image such that all clients see the same image at the same time. You need to take care of delays, network problems. He kept on adding new elements like compression, streaming, utc time related issues, client rendering delays and so on.

Round: Other Interview
Experience: This was bar-raiser round.

Skills: Design, Algorithms And Data Structures, Graph Theory
College Name: IIT Madras

Eligibility criteriaAbove 8 CGPAUber interview preparation:Topics to prepare for the interview - Design, Algorithms And Data Structures, Graph Theory, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewRejected

Interview preparation tips for other job seekers - Read up on DS Algo and white paper coding and Leadership Principles

Round: Test
Experience: Aptitude was quite easy they just asked us basic questions from Math,logical reasoning and english
Tips: Just think well before u do..
Duration: 1 hour 30 minutes
Total Questions: 40

Round: Behavioural Interview
Experience: It was face to face .. the interviewee asked questions from our resume... Since I m from computer science background they asked some technical questions..

Tips: Beware filling ur resume.. they will ask every stuff that you have in resume

Round: Technical Interview
Experience: Discussion about my project that i vr done in my final year.they asked me what was my role in my project

College Name: Sri ganesh college of engineering and technology

Round: Test
Experience: The first test
contained 25 objective questions encompassing the basics of Computer Science ranging from
data structures, networks and operating systems to theory of computation
Duration: 45 minutes
Total Questions: 25

Round: Test
Experience: The second test contained 3 coding questions.
Duration: 45 minutes
Total Questions: 3

Round: HR Interview
Experience: After the written test, next day I appeared for 3 interviews.
They were checking if you can write code and also if you are aware of the practical issues faced while coding. In the final round they were testing if you could abstract out a real world
problem into code.
Tips: Overall I can say that you must hope for the best and prepare for the
worst. So make sure that you are prepared on all counts. You never know what might go wrong.