Lion Bridge Interview Questions

Excerpts from Interview #1:

• 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++.

• 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:

• 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.

• 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:

• 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.

• 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:

• 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?

• 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:

• 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.

• 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:

• 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?

• 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?