Oracle Database Interview Question Set-30

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. If your standby database is lagging relative to the primary database, you should focus on which areas?
  2. How You Determining transport or apply lag is done on the standby database?
  3. How you Find local time on the standby database when the datum used to compute the metric was received it means (the lag metrics are computed based on data that's periodically received from the primary database)?
  4. How you will Find out the history of apply lag values since the standby instance was last started?
  5. How to monitor and assess redo apply performance?
  6. What are the RECOVERY PROCESS WAIT EVENTS in Data Guard?
  7. Which Script creates the standby statspack schema to hold the standby
  8. Which script generates the standby statistics report?
  9. Which script is used to purge a set of snapshots in the Data Guard?
  10. Which script drops the stdbyperf user and tables?



With Best Wishes!!!!

Cloud Architect
Oracle Database Consultant

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

YouTube Channel:

1 Comment

AMER KHAN · September 28, 2020 at 8:23 pm

Very Good Set of real time environment based Questions for DG topic, Thanks for sharing!!

Leave a Reply

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