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