Oracle Database Interview Question Set-29

Published by Ahmad on

My DBA Community,

My today’s post is very important for those who are looking for a job and preparing for an Interview. I am writing Oracle Database interview questions.
I hope these IQ will help you.
  1. Can A logical standby accept archived logs while a rolling upgrade is taking place?
  2. How to determine whether any tables involved in a rolling upgrade performed with the
    DBMS_ROLLING PL/SQL package contains unsupported data types?
  3. Can we transport of redo data to a Recovery Appliance?
  4. For rolling upgrades which Procedure Support?
  5. Can we rename the data file on the standby site when the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO?
  6. If the standby site is not receiving redo data, Which view you will check for error messages?
  7. Can we mount the standby database if the standby control file was not created?
  8. If you specify REOPEN for a MANDATORY destination, and redo data is not transmitted then what will happen on Primary Database?
  9. Which tool(Procedure) you will use for handling logical standby database failures?
  10. If the switchover does not complete successfully, which view you will check?



With Best Wishes!!!!

Cloud Architect
Oracle Database Consultant

Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |

YouTube Channel:


Saleh Bin Mohsin · September 14, 2020 at 11:27 am

Thanks for the questions on the important topic like Oracle DataGuard

anand · September 15, 2020 at 1:26 pm

Hello Ahmad ,

Thanks for shearing your knowledge i have a little request to you could you please also share a answer of question

Leave a Reply

Your email address will not be published. Required fields are marked *