Oracle Tough Interview Questions

  1. What do you understand by the word oracle? Why this is used in programming?
  2. Explain the commands used in Oracle programming system?
  3. What do you understand from DBA? How many activities you can handle during your work time?
  4. What are the other concerned parts in organization? How would you manage your communication with them?
  5. Explain the main difference in Oracle and SQL? State this with the help of an example?
  6. What is the difference between production DBA and development DBA? How these are different from each other?
  7. What is the meaning of backup in Oracle? Explain hot back up and cold back up? Also mention the difference associated with them?
  8. What is the method to switch ora file to init.ors?
  9. Explain the data block, a segment and an extent with example?
  10. Discuss the use of DELETE and TURNCATE for a table?
  11. What are constraints? Mention two examples referential integrity constraints?
  12. How do you use of index in Oracle?

Category: Tough Interview Questions

Leave a Reply