(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?
Issue the create spfile from pfile command.
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:
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.
What is difference between SQL and SQL*PLUS?
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?
Excerpts from Interview #5:
(IIT-G student having 10th grade- 92.1%, 12th grade - 94.5% and graduation score - 78.9%)
Technical interview:
Describe the use of %ROWTYPE and %TYPE in PL/SQL.
What packages (if any) has Oracle provided for use by developers?
In what order should a 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?
When is a declare statement needed?
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?
Excerpts from Interview #6:
(DTU 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?
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 ORACLE PRECOMPILERS?
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?
