Important Oracle Interview Questions with Answers



  • 9_Why use materialized view instead of a table
  • 10_What does ROLLBACK do
  • 11_Compare and contrast TRUNCATE and DELETE for a table
  • 12_what is null value
  • 13_Define transaction
  • 14_what is the difference between sql&oracle
  • 15_What are different Oracle database objects
  • 16_What is hash cluster
  • 17_What is a User_exit
  • 18_What is schema
  • 19_What are Roles
  • 20_What are the dictionary tables used to monitor a database spaces
  • 21_What is a SNAPSHOT
  • 22_What is a database instance
  • 23_What are parameters
  • 24_What are the different file extensions that are created by oracle reports
  • 25_What are clusters