SCENARIOS Oracle Interview Questions [25 Questions]

  1. Block Corruptionwhere we can find block corruption? which view desc block corruption?
  2. Explain few Real time scenarios related to deadlock, flashback queries and autonomous transaction
  3. If you disable the index, can you use it or not?
  4. Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
  5. See, If the export dump is in one characterset and the target database which has to be imported is in another characterset how could we import that particular dumpfile into target database ?
  6. You must first Login or Register to view all 25 questions from this category.

    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.