SingleStore Interview Questions and Answers

Round: Test
Experience: The sections were Quantitative, Logical, Verbal and Computer Science.The three sections contained very basic questions of general aptitude while the Computer Science section contained questions on Database Management, OS, SQL and Programming Aptitude.

Round: Test
Experience: The question was to program a logic to test the correctness of a solved sudoku. We were allowed to code in C++, Java, C or pseudo code.

Round: Technical Interview
Experience: Were asked simple questions and program them like reversing string without temporary variables, finding the earlier date when entered as string and finding the difference in number of days between them.
I was asked to explain him my internship project in great detail and above all one should be prepared to answer the question 'Why IT?' if from a non IT background. Then I was asked to program a logic for 'Search and replace" tool of MS Word.

Round: HR Interview
Experience: Was asked about my background in detail and stressed again and again on 'Why IT?'. Then he asked me to prepare a summary on the merits and demerits of various Employee Data Management techniques for an organisation. For the end of the interview you should have a question which you would ask to the interviewer.

General Tips: Don't try to over emphasize the correctness of your logic if the interviewer finds a glitch. It irritates him. Be interactive in your HR round. In our case it was the VP of Oracle India who took the final round. So I asked him about his experience in the company. He was very happy to share it with me. But asses your interviewer before you put forth these queries cause your interviewer might not be as jolly as mine was.
Skills:
College Name: NIT Surathkal

Round: Resume Shortlist
Tips: If you think it is worth it, write it in the resume.

Round: Technical Interview
Experience: I discussed a political party in one such interview in another company. He was impressed rather inspired.
Tips: All they are looking for in this interview is that you have a basic aptitude

Round: HR Interview
Tips: Try to be as real as possible. They know people and have great deal of experience. You cannot fake it.

General Tips: Peace yoo
College Name: IIT BOMBAY

Round: Test
Experience: apti and logical reasoning ques  were not tough and with basic knowledge on C and SQL I could easily solve the questions
Tips: Just try to  maintain a good speed while solving

Round: Technical Interview
Experience: mostly they focus their questions based on the form that we had to fill. it had details about our extracurricular activities, main courses of interest, training and project work, software languages known, academics.
Tips: the form was to be filled with accuracy and only those points about which one is confident enough should be added

Round: HR Interview
Experience: it was just a normal interaction. they wanted to know the kind of person i am, my strengths and weakness. any impressive qualities unique of me. my favourite author. it lasted no longer than 10 minutes . and try to acquire as much background information as you about the company.
Tips: try to be honest with your answers. do not fake since they can easily catch you. do not give any such answers about which you are not confident or any view where you cannot defend yourself.

Skill Tips: I learned sql from w3school.com.
Skills: confidence, amicable nature, leadership qualities, participation in extracurricular activities, puzzle solving, Aptitude
College Name: NIT ROURKELA
Motivation: Its quite simple, I wanted to land with good job before i leave  nit.
Funny Moments: Since it was the first time i was facing an interview, so i asked my interviewer how were my answers.

Round: Resume Shortlist
Experience: I had a standard resume for this company as per the norms of our institute’s placement cell. For Oracle I laid emphasis on my programming skills and projects related to it.

Round: Test
Experience: The first round was the written test that comprised of 5 sections – vocabulary, aptitude, pattern matching, logical reasoning and programming. The questions in the programming section were asked from data structures and C++. The questions in the programming section were mainly from trees (from data structures). Around 400 students appeared for their written test out of which around 100 were shortlisted.

Round: HR Interview
Experience: The next round was the interview round. They gave me some puzzles to solve and a program to write. One of the puzzles that I remember was that if I were to be given an egg then how would I determine its durability, i.e. how would I determine that from which floor do I need to throw the egg from so that the egg does not break if thrown from any floor below it.
For the coding question I was given a mathematical formula and I was asked to devise a code such that the program uses the formula and gives the output.
Tips: Prepare for Data Structures as well as the commonly asked puzzles for Oracle.

College Name: IIT ROORKEE
Motivation: Oracle is a reputed company in the space of software and ITeS. It had come to our campus with five profiles. The best means to know about all of them is to attend the pre-placement talk of the company.

Round: Test
Experience: It was an online test. The company who hosted the test messed up with the interface, and a lot of people had trouble with a coding question that could not be solved because of the faulty interface. There was no retest.
The shortlisting was done after studying compile attempts, time devoted to various sections and other performance measures.

Round: Technical Interview
Experience: Told about myself, my interests, my internship projects and my work so far.
A few coding questions were asked too.
In the end, they asked if i have any questions.
Tips: Interviewers are friendly. Be calm, give your best.

General Tips: Start preparing early.
Develop priorities both sector wise and company wise.
Take sufficient water and food with you. Interviews can start at 4 am on the first day!
Have enough copies of resume and transcripts with you.
If you have been shortlisted for many companies, it is preferable to have a portfolio manager who manages your phone during the day and enables you to focus on the interviews.
College Name: IIT KANPUR

General Tips: Before going for the interviews, take a sheet of paper and write an error free code, with extremely well named variables and optimized runtime each on Matrices, Linked List and Binary Tree. This will ensure that you have confidence and don't feel rusty while writing the code. Check your code twice to make it error free before showing the interviewer.
Skill Tips: geeksforgeeks is the most valuable site. The questions are generally taken from there. Careercup.com has the most common questions asked by Microsoft. Try to even brush up on OS concepts. Some interviewers ask that too. Practice all questions on linked list. This is generally the first interview question.
College Name: NIT SURATHKAL

General Tips: Don't ignore aptitude because it is really important. Never give up on any question in interview. Tell your interviewer anything you know about the question even if it is too simple to tell. Be confident.
College Name: NIT SURATHKAL

General Tips: 0. The most important thing. Know your level. Improve yourself by practicing more and be well aware of how smart you are. Wishful thinking can only get you so far.1. Writing fluent and optimized code is an art. I was lucky because I have been coding for a long time. If your coding skills aren't great, practice! I answered one crucial question completely wrong and still got through because of this skill.2. If you know an answer to a question, do not answer it immediately. Try to derive that answer from scratch and understand it before you go about blurting out the answer out of excitement. Let it look like a challenge.3. Learn External Sorting and Kadane's algorithm.4. Learn some basic OS facts like details about a program stack and what not.Make a CV right now! Compress it to one page. No one cares about your extra-curricular activities as much as you do. Include relevant details. Selection Procedure Preparation
College Name: NIT SURATHKAL