Interview Questions on Oracle Data Access


General Oracle Data Access Interview Questions

Q1.What do you mean by Execution Plan?
Q2.What is an optimizer? State its function. While selecting the Optimization approach which factors affect the optimizer?
Q3.What do you mean by Read Only transaction?
Q4.What do know about COMMIT? Explain its function in detail.
Q5.How is it possible to delete tuples in a table which is based on date column?
Q6.Which values should be specified for the Alter Session’s Optimizer_Goal parameter?
Q7.Explain Cost based approach to Optimization in detail.
Q8.What can you tell us about Transaction? Can you define it?
Q9.What is Optimizer Mode Parameter?
Q10.Which approaches does the Optimizer choose while selecting an Execution plan?
Q11.When will a Transaction end?
Q12.What is a Rollback? Explain its function.
Q13.If you set the value All_Rows for the Optimizer_Goal parameter of Alter Session what will be the result?
Q14.What can you tell us about Alter session Command?
Q15.We want to store numerical in a field in a table with a field of type character. How should we sort the field in Java numerically?
Q16.If you set the value of Optimizer_Mode to Rule, what will be the result?
Q17.Can you tell us anything about SQL statements?
Q18.Say something about First_Rows.
Q19.Say something about All_Rows.
Q20.What can you tell us about Rule?
Q21.If you set the value First_Rows for the Optimizer_Goal parameter of Alter Session what will be the result?
Q22.Can you tell us anything about a data dictionary?
Q23.If the Optimizer_Mode is set to Cost, will the Optimizer only select cost based approach?
Q24.What do you mean by “Choose”?
Q25.What do you mean by “user sessions transactions”?
Q26.Which values does the Optimizer Mode parameter specify?
Q27.If you set the value Choose for the Optimizer_Goal parameter of Alter Session what will be the result?
Q28.What do you know about the Optimizer_Mode initializing parameter?
Q29.What can you tell us about save point?
Q30.State the Rule based approach to optimization.

Interview Questions for Oracle database Administrator

Q31. Tell us about your experience of working in development and integration testing.
Q32. What kind of PL/SQL Scripting knowledge do you have? Do you have any experience of working with Oracle Apps Server?
Q33. Tell us about your troubleshooting skills.
Q34. Describe your experience in the following segments:
Data Modeling
Design
Performance Tuning
Q35. How would you contribute towards DBA support if we hire you? Do you have any experience in Production Support?
Q36. How adept do you think you are at DB installations? Do you have any experience of managing DB migrations?
Q37. How can you help us with database capacity planning?
Q38. Describe your following skills:
Oracle DBA
Oracle 10g
Oracle 11g


RMAN
CDC
Oracle Shared Tech-Stack
RAC
Q 39. Rate your communication skills.
Q40. Tell us something about optimization.

Interview Questions for Oracle Apps Database Administrator

Q41. Do you have any experience in R12?
Q42. What kind of experience do you have in cloning?
Q43. What do you know about WF Setup and RMAN set up?
Q44. What kind of experience do you have in Datawarehousing?
Q45. What do you know about node installations?
Q46. Describe your exposure to the Software Services.
Q47. What kind of Performance Tuning experience do you have?
Q48. Describe your exposure to the IT Software.
Q 49. What do you know about mailer notification?
Q50. Do you have any experience in database security?
 


Post New Comment:


This website is up for sale at $3,000.00. Please contact 9811053538 for further details.