Nagarro-Software Interview Questions

Excerpts from Interview #1:
(CSE student having 10th grade - 96.1%, 12th grade - 80.9%, Graduation score - 79.8%)
Technical Interview:
  • Merge an array of size n into another array of size m+n.
  • Given an array , separate positives and negatives strings.
  • Tell us some of the components of PL/SQL.
  • State main two differences between simple and complex snapshots.
  • What do you mean by the term data segment?
HR Interview:
  • Tell me about yourself.
  • What are your short term and long term goals?
  • What is your dream job? Why?
  • What is the main problem that our country faces at the moment?
  • What is your biggest achievement?
Excerpts from Interview #2:
(Engineering student having 10th grade- 82.9% 12th grade-87.08% and graduation score-78.5%)
Technical interview:
  • Can you Implement queue using linked lists?
  • What are abstract classes in Java and what is the difference between an abstract class and an interface.
  • If a unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
  • Find the number of palindromes in a big string.
  • What is overloading and what is overriding? Illustrate with examples.
  • What is the difference between semaphore and mutex?
  • Explain 8 queens algorithm.
  • How does one create and drop database users?
  • What are Codd Rules?
HR Interview:
  • If you came on board with us, what changes would you make in the system?
  • How many hours a day/a week do you work? Do you think you’re a hard worker?
  • Tell me something about yourself that is not in your resume?s
  • What will be your favorable work location?
Excerpts from Interview #3:
(IIT-B student having 10th grade- 94.4% 12th grade-89% and graduation score-81.2%)
Technical interview:
  • Compare and contrast TRUNCATE and DELETE for a table.
  • Can you give the reasoning behind using an index?
  • Write a program to print the given matrix in a wave like form.
  • Use the describe command or use the dbms_metadata.get_ddl package.
  • Where would you look for errors from the database engine?
  • What is difference between Rename and Alias?
HR Interview:
  • Why Nagarro Software?
  • What are the traits of a good boss? Rate your previous supervisor accordingly.
  • How much change is in the works at your prospective company, and what kind?
  • What learnings and experiences that you can provide will help the company?
  • Why should I hire you from the outside when I could promote someone from within?
Excerpts from Interview #4:
(Engineering student having 10th grade- 81.4% 12th grade - 85.1% and graduation score- 88.9%)
Technical interview:
  • How would you determine the time zone under which a database was operating?
  • Explain the use of setting GLOBAL_NAMES equal to TRUE.
  • What command would you use to encrypt a PL/SQL application?
  • Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
  • Name three advisory statistics you can collect.
  • A string is given, count the frequency of each word in string and print it.
HR Interview:
  • How effective are HR Round Interview Tips?
  • What do you find is the most enjoyable part, working in a company?
  • What inspired you to come and attend my company’s interview?
  • What would be your ideal work atmosphere?
  • What do you think is our company’s philosophy?
  • Are you Extrovert or Introvert?
  • Which type of coding platform you prefer?
Excerpts from Interview #5:
(A student having 10th grade- 92.1%, 12th grade - 94.5% and graduation score - 78.9%)
Technical interview:
  • Write a program to print elements of a linked list in reverse order by using same single linked list?
  • What packages (if any) has Oracle provided for use by developers?
  • In what order should an open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?
  • What is a mutating table error and how can you get around it?
  • An array contains 6 different numbers, only 1 number is repeated for 5 times. So now total 10 numbers in array, Find that duplicate number in 2 steps only
  • What is ON DELETE CASCADE?
HR Interview:
  • What would you rate as your greatest weaknesses?
  • Don’t you think you are overqualified for this job?
  • How would you honestly evaluate the strengths and weaknesses of your previous/current company/boss/team?
  • Your competitor presses you to reveal some confidential information about your current or previous employer. Would you break?
  • Rank your programming skills on a scale of 1 to 10.
Excerpts from Interview #6:
(An  Engineering student having 10th grade- 92.24% 12th grade - 90.2% and graduation score- 89.9%)
Technical interview:
  • What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?
  • What are the uses of Database Trigger?
  • Which coding platform do you prefer?
  • What is ROWID in a session before accessing next value?
  • What is an UTL_FILE? What are different procedures and functions associated with it?
  • What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?
HR Interview:
  • How did you handle your most challenging experience in your previous job?
  • How will your qualification help you in doing this job?
  • What do you know about our organization and why do you want to join it?
  • How have your strengths helped you in getting your work done?
Test Site