Excerpts from Interview #1:

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

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

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

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

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

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

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

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

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

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

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

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