Lion Bridge Interview Questions

Excerpts from Interview #1:
(A B.E. ECE student having 10th grade - 92.4%, 12th grade - 86%, Graduation score - 65.4%)
Technical Interview:
  • Define ACID properties?
  • What is write ahead logging in DBMS?
  • What are the deadlock avoidance schemes?
  • What is clustering index?
  • There is a program which inserts and deletes node in a sorted singly linked list. There is a bug in one of the modules, how would you debug it?
  • What are the ways in which fault tolerance can be ensured in systems?
  • A pair of redundant systems are operating, how would you ensure that when one of them goes down, the other one will take over its operation?
  • Define Virtual function in C++.
HR Interview:
  • Are you willing to relocate or travel?
  • What motivates you to do a good job?
  • Describe your ideal company, location & job.
  • Who is your inspiration in life & why?
Excerpts from Interview #2:
(An engg student having 10th grade- 78.9% 12th grade-71.08% and graduation score-67.9%)
Technical interview:
  • Program to find duplicate number from array in minimum time complexity.
  • String Handling program.
  • What are triggers? How do you invoke a trigger on demand?
  • How do you get the distinct rows without using the keyword DISTINCT?
  • What are the charactersticts of Final,Finally and Finalize keywords.
HR Interview:
  • Interests of the candidate and his/her hobbies.
  • The leadership qualities of the candidate.
  • Comfort level with coding, testing or support role.
  • A puzzle (the common 3 and 5 jug problem) though more than 1 solution may be demanded.
Excerpts from Interview #3:
(An engg student having 10th grade- 90% 12th grade-81.2% and graduation score-74.9%)
Technical interview:
  • Explain the different OSI layers.
  • Explain the TCP/IP protocol.
  • Calculate the IP address , based on a set of information.
  • C/C++ basic programs.
  • Popular algorithms for sorting and searching of arrays & link lists.
  • Program on popular data structures like stack and queue.
HR Interview:
  • Why Should we recruit you.
  • Would you be able to sustain yourself at erricson given the environment.
  • The attributes that differentiate you from others.
  • Would you be able to work at the different work locations, away from your hometown.
  • How do you spend your free time, and why so.
Excerpts from Interview #4:
(Punjab University student having 10th grade- 76.23% 12th grade - 89.2% and graduation score- 72.43%)
Technical interview:
  • What is the difference between Hash Table and Hash map?
  • What is the difference between Grant And Revoke statements in SQL?
  • Write a function to print Fibonacci series and Tribonacci series?
  • What is Backtracking?Explain the 8-Queens problem and brief an approach to solve it?
  • Explain the selection sort algorithm and state its time complexity?
HR Interview:
  • Introduce yourself.
  • Why a sudden decline in score keeping in view your 10th and 12th score?
  • Some discussion about my hobbies.
  • Tell me about your family.
  • Why Should we recruit you?
  • Would you be able to sustain yourself at Lion Bridge given the environment?
  • How do you spend your free time, and why so?
Excerpts from Interview #5:
(CCET student having 10th grade- 94.6% 12th grade - 85.7% and graduation score- 67.22%)
Technical interview:
  • What is a composite primary key?
  • What is the difference between quicksort & mergesort? When should they be used? What is their running time?
  • Is linked list a linear or non-linear data structure?
  • C/C++ basic programs.
  • Popular algorithms for sorting and searching of arrays & link lists.
HR Interview:
  • Tell us about yourself and what are your weaknesses?
  • What do you know about our competitors?
  • Walk us through your resume.
  • A lot of companies have visited your campus for recruitments, why haven’t you been placed yet?
Excerpts from Interview #6:
(CCET student having 10th grade- 86% 12th grade - 84% and graduation score- 71%)
Technical interview:
  • What is rollback?
  • What is primary key?
  • What are different modes of parameters used in function and procedures?
  • What is the difference between procedures and functions?
  • What are snapshots?
  • What are mutating objects?
  • What are the advantages of views?
  • What is a tablespace?
  • What is rollback segment?
  • What is an index cluster?
HR Interview:
  • Tell me about yourself.
  • What do you know about Lion Bridge?
  • What is your role in the project?
  • Tell me about your strengths.
  • What are your short term and long term goals?
  • What are your Hobbies?
  • Do you have any questions for us?
Test Site