Oracle Database Interview Question Set-28

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 we move an online datafile in a data guard from one physical file to another physical file while the database is actively accessing the file?
  2. Can we create a physical standby of a Multitenant container database(CDB)?
  3. Can we use SYNC & NOAFFIRM ATTRIBUTES use together in maximum availability mode?
  4. Using CURRENT LOGFILE clause is required to start real-time apply in data guard?
  5. Can we do DML operations on global temporary tables on Oracle Active Data Guard standbys?
  6. Can we use sequences in an Oracle Active Data Guard environment?
  7. When you perform a switchover from an Oracle RAC primary database to a physical standby database, it is necessary to shut down all but one primary database instance?
  8. Can we use Application Continuity Feature for Oracle Data Guard switchovers to physical standby databases?
  9. Can we use Application Continuity Feature for fast-start failover to physical standbys in maximum availability data protection mode?
  10. Can we create a logical standby of a CDB?



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

Jenel Parekh · September 11, 2020 at 1:24 pm

Hi Ahmad
Your questions are really worth to practice and have gianed good knowledge from these question and also helping me to clear my interviews

Just 1 request was please if its possible then get some query level questions from basic to deep.

Thank you so much ?

Leave a Reply

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