Oracle Database Interview Question Set-28

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?

Thanks

With Best Wishes!!!!

Ahmad
Cloud Architect
Oracle Database Consultant

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

YouTube Channel: https://www.youtube.com/c/OracleRide