Sapient Interview Questions

Excerpts from Interview #1:

• Define Join and explain its types.
• What is a composite primary key?
• What are null pointers and when are they used?
• What is the difference between set & lists?

• Where do you see yourself in 5 years?
• Why should we hire you?
• Tell us about yourself.
• Why do you want to join SapientNitro?

Excerpts from Interview #2:

• Explain dynamic & static binding.
• Explain truncate & round functions.
• What are you understand by meta-dictionary?
• Explain materialized views.

• Where do you see yourself in 5 years?
• What do you know about our company?
• Why did you choose this college & why this stream?
• How do plan to motivate your team if you become a team leader?

Excerpts from Interview #3:

• What are advantages of using cin & cout compared to printf & scanf, respectively?
• Explain a function template.
• What are the conditions for a deadlock to occur in OS?
• What is SQL Data Definition Language (DDL)?

• Why do you want to join our company?
• Are you willing to relocate or travel?
• What motivates you to do a good job?
• Describe your ideal company, location & job.

Excerpts from Interview #4:

• What are cursors? Explain its types.
• Explain the procedure for deleting a singly linked list.
• Differentiate between a Copy Constructor & Assignment Operator.
• What is backtracking? Explain 8-Queens problem & brief approach to solve it.

• Tell us about yourself.
• Who is your inspiration in your life & why?
• What are your goals in life?
• What is the toughest decision you’ve had to make in your life?

Excerpts from Interview #5:

• Explain the steps to convert ER Diagram to tables.
• Explain the approaches of flattening the table & decomposing the table in 1NF.
• Swap two integer variables without using a third temporary variable.
• What is the difference between malloc() & calloc() function?

• Tell us about yourself.
• How much salary do you expect from us?
• What are three qualities that your friends will describe you having?
• How do feel about working according to US timings – 1:00pm to 9pm?

Excerpts from Interview #6:

• What do you mean by Hash Table?
• What do you mean by polymorphism in C++?
• What do you mean by Hash Table?
• State two differences between DBMS and RDBMS.

• Introduce Yourself.
• Do you have problem solving skills?
• What is your biggest strength?
• How would you rate your technical interview?