Free 1z0-076 – Oracle Certification Practice Test Question

Select all that apply, then click Submit answer.

• ○

  DB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.

• ○

  Each pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.

• ○

  Each pluggable database within a multi-tenant physical standby has one MRP background process running during redo apply.

• ○

  A pluggable database within a multi-tenant standby database can have a different open mode than the container database.

• ○

  A pluggable database within a multi-tenant standby database can have a different database role than the container database.
  
  

Select an option, then click Submit answer.

• ○

  Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

• ○

  Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

• ○

  Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

• ○

  Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.
  
  

Select all that apply, then click Submit answer.

• ○

  DGMGRL> convert database sheep to physical standby;

• ○

  DGMGRL> convert database cats to physical standby;

• ○

  DGMGRL> edit database dogs set property LogXptMode= fastsync;

• ○

  DGMGRL> edit database sheep set property LogXptMode= fastsync;

• ○

  DGMGRL> edit database cats set property LogXptMode= sync;
  
  

Select all that apply, then click Submit answer.

• ○

  Archive logs on the primary database may be deleted once they are applied on all standby databases.

• ○

  Archive logs on the primary database may be deleted once they are shipped on all standby databases.

• ○

  The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they backed up at least once on the remote physical standby database.

• ○

  The deletion policy for archive logs on the remote physical standby should be set so that archived logs are deleted once they are applied on all standby databases.

• ○

  Archive logs on the primary database may be deleted once they are archived locally to disk.
  
  

Select all that apply, then click Submit answer.

• ○

  A flash recovery area must be configured.

• ○

  The database must be in MOUNT state.

• ○

  The database must be in ARCHIVELOG mode.

• ○

  A far sync instance must be configured to flash back a standby when the primary has been flashed back.

• ○

  The Data Guard Broker must be used.
  
  

Select all that apply, then click Submit answer.

• ○

  If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

• ○

  The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

• ○

  Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

• ○

  Fast start failover can be enabled when making the chance.

• ○

  Real time apply will be automatically turned on.
  
  

Select all that apply, then click Submit answer.

• ○

  DB_NAME

• ○

  ARCHIVE_LAG_TARGET

• ○

  COMPATIBLE

• ○

  DB_FILE_NAME_CONVERT

• ○

  DB_UNIQUE_NAME

• ○

  FAL_SERVER

• ○

  STANDBY_ARCHIVE_DEST
  
  

Select an option, then click Submit answer.

• ○

  Option A

• ○

  Option B

• ○

  Option C

• ○

  Option D
  

Select an option, then click Submit answer.

• ○

  2, 3, 4, and 5

• ○

  1, 2, 3, 4, and 5

• ○

  1 and 2

• ○

  only requirement 5

• ○

  only requirement 1
  
  

Select an option, then click Submit answer.

• ○

  SYNC NOAFFIRM and Maximum Protection

• ○

  SYNC NOAFFIRM and Maximum Availability

• ○

  ASYNC and Maximum Performance

• ○

  SYNC AFFIRM and Maximum Availability

• ○

  SYNC AFFIRM and Maximum Protection