Important Oracle Interview Questions with Answers

  • 26_What is difference between SUBSTR and INSTR
  • 27_Define a view
  • 28_What is the difference between a view and a synonym
  • 29_What is the usage of SAVEPOINTS
  • 31_When do you use WHERE clause and when do you use HAVING clause
  • 32_What are the differences between stored procedures and triggers
  • 33_What must be installed with ODBC on the client in order for it to work with Oracle
  • 34_What are the different file extensions that are created by oracle reports
  • 35_what is trigger
  • 36_Explain the difference between a data block an extent and a segment
  • 37_What is bind reference and how can it be created
  • 38_How many LONG columns are allowed in a table Is it possible to use LONG columns in WHERE clause or ORDER BY
  • 39_What are various types of joins
  • 40_What is the maximum number of triggers can apply to a single table
  • 41_What command would you use to create a backup control file
  • 42_What is an Oracle index
  • 43_What are the different index configurations a table can have