Interview Questions:

  • Can you administer Oracle from the command line, without using OEM?  If they answer “no”, stop the interview here.
  • What is the name of Scott’s Cat?
  • What is the command to add a file to a tablespace?
  • What filesystems can you use with RAC?
  • How do you migrate a change into production?
  • What is the Oracle default SYSTEM password?
  • How can you tell if a SQL statement needs tuning?
  • What is the difference between the v$ and x$ tables?
  • What was the first Oracle data buffer pool advisory utility?
  • How to you open a file read-only in vi?
  • What does the oratab file do?
  • How many shells do you know?  If they don’t know that a shell is, they are a poser.
  • What files contain the Oracle login profiles?  This is OS and shell specific. . .
  • How do you change every occurrence of a string in vi?
  • What columns are important in vmstat?
  • How can you tell if a server is paging?

Source