Oracle 1Z0-076 Oracle Database 19c: Data Guard Administration Exam Exam Practice Test Questions

• Question 1

  Which four statements are true regarding SQL Apply filters for a logical standby database?

  • They can be used to skip execution of DML triggers on a table while allowing the DML to execute.
  • They can be used to skip CREATE TABLE commands.
  • They can be used to skip ALTE1 STEM and ALTER DATABASE commands.
  • They can only be used to skip DML statements on a table.
  • They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).
  • They can be used to stop SQL apply if it encounters an error.
  • They can be used to skip ALTER TABLE commands on specific tables.

  Show Answer Answer: A,B,C,G Next

• Question 2

  Which three are prerequisites for enabling Fast-Start Failover?

  • The Data Guard environment must be managed by the Data Guard Broker.
  • Flashback Database must be enabled only on the Fast-Start Failover target standby database.
  • You can specify only one standby database as the fast-start failover target.
  • The configuration must be operating in either Maximum Performance or Maximum Protection mode.
  • The maximum protection mode can be used, but with two or more standby databases.
  • Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

  Show Answer Answer: A, ,C, ,F Next

• Question 3

  You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements:

  • Creating and maintaining bitmap indexes should not impact the performance of the primary database.
  • Creating and maintaining materialized views should not impact the performance of the primary database.
  • Additionally, there are these requirements, only one of which is ever done at any one time:
  • It should be possible to apply designated patches with a minimum amount of downtime.
  • Upgrading to a new database release should be performed with the least possible amount of downtime.
  • New application software releases should be tested against an exact and up-to-date replica of the primary database.Which configuration meets these requirements with the fewest of databases?
  • A primary database with one logical standby database
  • A primary database with two logical standby databases
  • A primary database with one physical standby database
  • A primary database with two physical standby databases
  • A primary database with one logical and one physical standby database

  Show Answer Answer: A Next

• Question 4

  Which THREE statements are true about Far Sync instances?

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

  Show Answer Answer: A,C,E Next

• Question 5

  A customer asks for your recommendation regarding this requirement:

  • We plan to have a Data Guard Configuration with one primary database and one physical standby database.
  • We want zero data loss in case of a disaster involving the loss of one component.
  • We want to do Real Application Testing occasionally on the Standby Database. Which solution, if any, satisfies these requirements?
  • These requirements cannot be met.
  • A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing
  • A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing
  • A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

  Show Answer Answer: B Next