Online Access Free 1z0-076 Exam Questions

Which three are true about using Flashback database through role transitions in a Data Guard environment?

• A.Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.
• B.Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.
• C.Flashback database may not be used to undo a physical standby database activation.
• D.Logical standby database roles are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.
• E.Logical standby databases retain their current role when you flash back through to a point in time before the switchover occurred which caused this database to become a logical standby.

A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION;
Which TWO statements are TRUE?

• A.The sequence is usable on physt1 but not usable on physt2.
• B.physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.
• C.The sequence is usable on physt1 and physt2.
• D.The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.
• E.physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

You must configure flashback database for your Oracle 19c databases that will be part of a Data Guard Broker configuration.
The databases are all in ARCHIVELOG mode.
You will execute the SQL statement:
ALTER DATABASE FLASHBACK ON;
Which three are true concerning this command?

• A.If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration.
• B.It will execute successfully while an Oracle 19c primary database is open.
• C.It will execute successfully on an Oracle 19c logical standby database while SQL apply is active.
• D.It will execute successfully while an Oracle 19c primary database is mounted.
• E.If executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standby databases that are part of the configuration.
• F.It will execute successfully on an Oracle 19c physical standby database while Real Time Query is active.

Which THREE statements are true about snapshot standby databases?

• A.A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.
• B.A snapshot standby database can be the only standby database in a Maximum Protection Oracle Data Guard configuration.
• C.If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.
• D.A snapshot standby database must be opened at least once in read-write mode before it can be converted into a physical standby database.
• E.Snapshot standby databases may be used for rolling database upgrades.

Which THREE statements are true about Far Sync instances?

• A.They work with any protection level.
• B.They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.
• C.They use an spfMe, a standby controlfile, and standby redo logs.
• D.A primary database can ship redo directly to multiple Far Sync instances.
• E.The Data Guard Broker must be used to deploy and manage Far Sync instances.