Orbit Techsol Database Admin Interview Questions and Answers for Experienced

Round: Group Discussion
Experience: All got different topics to discuss on gd.
Tips: Plan before you speak. Be sure whether you are to or against.
Duration: 5 minutes

Round: Test
Experience: More questions on blood relationship, ages
Tips: Os db on technical
Duration: 1 hour

Skills: Technical Questions, Manage A Difficult Situation, Technical Knowledge(ML

Round: Test
Experience: There was an online test having 3 section, one for aptitude testing, one for logical testing and the last one for technical testing.
Aptitude and logical questions were very basic.
Technical questions included : C C++ Java DS DBMS DAA
Tips: For aptitude and logical part, you need to prepare regularly. Nothing comes out of the box, but you just have to be quick in solving the questions.
For the technical part, prepare well by revising your course materials. Basic one word questions are asked.
Duration: 1 hour
Total Questions: 60

Round: Coding
Experience: This round consists of multiple sets of coding. One question per paper. It's on your luck, which question you'll get. Also,net is allowed. You have to complete the code and show it to the invigilator.
Tips: This round is generally not there in placement drives of DELL. It is on your luck.

Skills: Communication, Data Structures, Basic Knowledge Of DBMS
College Name: Manipal University Jaipur

Round: Test
Experience: Objective based questions covering general aptitude, c programming, algorithms, os, dbms, software engineering

Round: HR Interview
Experience: Candidates are eliminated after each round of interviews. Number of interviews varies from candidate to candidate. However 1 HR and 1 Tech interview is compulsory. Some may have separate tech and coding interviews.

General Tips: The 1st round aptitude paper is not too tough but ensures that not everyone is able to clear the cutoff.
In the tech interview programming questions were easy but OS questions are tricky and interviewer is looking for a candidate with a solid basics.
Skill Tips: Try to score as much as you can in the 1st written round. If you have a good score it will help you during the interviews. Try to score as much as you can in the 1st written round. If you have a good score it will help you during the interviews.
Do not spend too much effort on coding questions. Instead focus on fundamentals of OS, DBMS concepts like paging, threading, system calls etc
Skills:
College Name: NIT Surathkal

Round: Test
Experience: It was constituted of two parts: Logic and DI. Both parts were simple. Questions were CAT type.

Round: Technical Interview
Experience: Simple C, C++ questions were asked. Technical questions based on internship project were asked. General questions asked to check reaction to sudden stress (for example: Why do earthquakes occur?).
Tips: Courses like DSP (application based) and information systems should be thorough. Knowing 1 programming language is very essential.

Round: HR Interview
Experience: Resume based questions were asked.
Tips: Know complete details of your interns, BTP and resume thoroughly.

College Name: IIT KANPUR

Round: Interview
Experience: A systematic approach is all what he expects from us. Our approach and our way of thinking is what he observes. An algorithm to solve a single face worked in my case. So called HR interview was more technical and a discussion about the projects mentioned in my resume.
Tips: An overview on problems like sudoku, rubik's cube, chess etc. A proper approach and a structure for solving the problem should be mentioned.

Round: Interview
Experience: Some questions on basic data structures, dynamic programming and recursion.
Tips: Recognize the problem(dp, recursion, etc.). Throw some algorithm.

General Tips: Be clear with basics.
Skill Tips: ""
Skills: Data structures, Data Processing, Recursion
College Name: IIT Madras
Motivation: SAMSUNG!
Funny Moments: A saviour for the leftover cse students especially b.tech and dual. It does not depend on whether your interview went well or not. Just basic cse stuff is enough.

Round: Test
Experience: Objective test in C(30 min),followed by a paper-based coding test.(1 hour, Written ).
Tips: There are old Samsung tests available online. The questions are based on the same fundamentals.Coding test focuses more on getting the pseudo code and logic right
Duration: 90 minutes

Round: Technical Interview
Experience: Interview questions were mostly based on projects and skills mentioned in the resume.Be sure to read up on your projects.They asked to explain the code.On the lines of how would I approach the problem of getting faster downloads in cellphones.

General Tips: I got selected because of my projects fit the profile they were looking for. They seemed to like the Olympiad ranks too.Data structures and algorithms basic fundaes, C coding and theory (asked in every profile), Revision of your electives (depending the core specialization)For any communication profile, do not ignore revision of courses and also it was necessary to read up
further as MTechs and MS students have an edge.
Skill Tips: Went through all the literature for all my projects.My courses and projects were all related to Communication Networks and Communication Systems. This background made the questions easier to answer. Majority of questions were about network protocols and network architecture.Started preparing DS&A at the beginning of seventh sem because I had never taken the course. The rest of it can be revised a couple of weeks before the tests start.
Skills: Algorithm, C Programming, Communication Networks, Communication Systems, Network protocols, Network architecture.
College Name: IIT Madras

Round: Resume Shortlist
Experience: Shortlisting done based on resume.
Tips: Create good resume highlighting projects and research work. Remain updated about the company's research work.

Round: Test
Experience: There are two written tests. One is based on C and algorithms.
Tips: Old Samsung tests that are available online.Knowledge of C is must.
Duration: 30 minutes

Round: Test
Experience: The second test is paper-based coding test.
Tips: Coding test is used to mainly gauge your logic applying abilities.
Duration: 60 minutes

Round: Interview
Experience: Personal Interview: one round lasting around 40 minutes.
 Interview questions were mostly straightforward, technical and based on projects and
research work mentioned in the resume.
 Previous day's code is also asked to explain.
 Couple of questions were about the company's on-going work. In-depth knowledge regarding courses related to the profile is necessary.
Tips: Revise courses, Project work. Additional reading is recommended.
Basics of core subjects.

College Name: IIT Madras

Round: Test
Experience: The first consisted of an online test which had an aptitude section which was pretty simply and then a programming section consisting of three different programs. The programs were logical required basic knowledge of array, sorting and a little bit of data structures.

Round: Technical Interview
Experience: Around 13 of us were shortlisted for the interview round, B.Tech and M.Tech included. The interview round was mostly interactive, where we had to mention about the various interns that we went through. A few programming questions were asked based on topics which we were comfortable with.
Tips: Just get used to coding, data structures and basic aptitude. GRE preparation as such helped me.

Round: HR Interview
Experience: Finally there was a HR round in which I was asked as to why I would like to work in Samsung R&D and general things about interests and future plans. On the whole Samsung took 3 B.Tech students and 2 M.Tech students when they came for placements apart from PPOs.

General Tips: Personally I feel that one should apply in only those companies in which they are sure of having job satisfaction. So don't apply to companies which you are not interested in just for the sake of having a backup because once you are placed you do not have a second chance.
Do not get dejected if you do not get through in the first few tries. Keep your hopes up and be confident when ever you get to interview rounds. Try to be assertive when giving answers. It is some times exhausting to go through placements but the moment you get placed you will have the best feeling ever.
Skill Tips: Just chill and take the test. Once you clear the online test, irrespective of your pointer if you have a good profile you can convince the interviewers.
Skills:
College Name: NIT Surathkal