Oracle Interview Questions [1900 Questions]

Filter with Oracle subcategories : Backup and Recovery [36] • Basics [47] • Concepts and Architecture [73] • D2K [71] • Data Access [27] • Database Administration [226] • Database security [30] • Tuning [2] • Distributed Processing [19] • General [210] • Memory Management [114] • Oracle Forms 3 0 [66] • Oracle Forms 4 0 [92] • PL SQL [237] • Programmatic Constructs [13] • RMAN [48] • Scenarios [25] • SQL [170] • SQL Plus [132] • System Architecture [33] • Oracle (FAQs) [229]

  1. Authentication Methods for DBAsWhat are the steps to creating a password authentication file?
  2. Corrupted Archieve LogsThere are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
  3. Configure CommandWhat is configure command? When do you use this?
  4. Recovery CatalogWhat is recovery catalog? Why do you need this?
  5. RMAN BackupDetail script of backup using RMAN in both mode catalog and nocatalog
  6. You must first Login or Register to view all 1900 questions from this category.


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