Oracle Database 19c: Data Guard Administration
Last Update May 3, 2024
Total Questions : 70
We are offering FREE 1z0-076 Oracle exam questions. All you do is to just go and sign up. Give your details, prepare 1z0-076 free exam questions and then go for complete pool of Oracle Database 19c: Data Guard Administration test questions that will help you more.
Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?
You must configure on Oracle Data .......
1. A primary database
2. Three Physical Standby Databases
Examine these requirements:
A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?
Which three statements are true……. With no Oracle Streams or Goldengate configured?
You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:
Which three statements are true regarding the execution of the command?
Which THREE are true about using flashback database in a Data Guard environment?
Examine the following parameter settings of the physical standby database:
• STANDBY_FILE_MANAGEMENT=AUTO
• ENABLED_PDBS_ON_STANDBY=
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?
Which two are true about database roles in an Oracle Data Guard configuration?
You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?
You must design an Oracle Data Guard configuration for a DSS database that meets these permanent
requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. 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:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. 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?
You are planning to perform block comparison using the dbms comp package:
Which TWO statements are true?
Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA-03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?
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?
Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing
Which TWO can be used to prevent clients from connecting to the wrong database instance?
Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?
A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
A)
B)
C)
D)
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances?
Examine this validate command:
DGMGRL> VALIDATE DATABASE VERBOSE "
Which THREE statements are TRUE?
Which three are true concerning database states after a successful switchover?
Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?