Quiz
Oracle Database 19c Dataguard
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (80)
1Which THREE statements are true about the states of a physical standby database that is open in real- time query mode, which becomes a new primary database during role transition? (Choose three.)
- AAll sessions are disconnected, and all buffers are flushed by default.
- BSessions that are using database links can be retained.
- CAll current buffers can be retained.
- DSessions that have long running queries can be retained.
- EUser sessions and Current Buffers are maintained by default.
- FUser sessions can be retained.
2Your Data Guard environment has one physical standby database using Real-Time Query.
Two sentences have been created by these SOL statements: create sequence a global; create sequence b session;
Neither sequence has been used since being created. Session 1 connects to the primary database instance and issues these two SL statements: SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL; Then session 2 connects to the physical standby database instance and issues the same SQL statements. What output will be seen for session 2?
1. A) Sequence a output - 21
2. Sequence b output - 1
1. B) Sequence a output - 21
2. Sequence b output - 21
1. C) Sequence a output - 1
2. Sequence b output - 1
1. D) Sequence a output - 1
2. Sequence b output - 21- Aoption A
- Boption B
- Coption C
- Doption D
3Which THREE statements are TRUE about Global Temporary Tables, when connected to a physical st database instance operating in Real-Time Query mode? (Choose three.)
- ADDL operations on global temporary tables such as the CREATE or DROP Commands can be run.
- BDML statements on them generate undo.
- CDML statements are permitted on them by default.
- DTheir content is always kept in the SGA of the physical standby database.
- ESELECT statements on them will return data inserted into them on the primary database.
- FDML statements are permitted on them only if TEMP_UNDO ENABLED is explicitly set to TRUE.
4Which THREE statements are TRUE about the supported workload in Active Data Guard standby databases? (Choose three.)
- AThe DML operations on a standby can be transparently redirected to and run on the primary database.
- BYou might have to use sequences with global temporary tables to support read-mostly applications by using Active Data Guard.
- CThe DDL operations on private temporary tables are transparently redirected to the primary database.
- DRead-mostly reporting applications that use global temporary tables for storing temporary data can be offloaded.
- EPL/SQL blocks that you run on Active Data Guard standby databases can be always redirected to and run on the primary database.
5You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN.
Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases? (Choose three.)- AA local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host.
- BThe DG BROKER START parameter must be set to TRUE for both database instances.
- CThe standby database must have supplemental logging enabled.
- DThe primary database must have FORCE LOGGING enabled.
- EThe LOG_ARCHIVE_DEST_n parameters with the SERVICE attribute set must be cleared.
- FThe primary database must have supplemental logging enabled.
6Examine the command used to create a database service:
srvctl add service -db erp -service erponline role PRIMARY -fallovertype TRANSACTION commit_outcome TRUE -replay init time 1800 -retention 86400
What is the significance of the COMMIT_OUTCOME attribute in this command?- AIt ensures that all committed transactions are written to the primary database before a switchover can complete.
- BIt ensures that there is no lag while performing a switchover or a failover.
- CIt ensures that all committed transactions affected during a switchover are rolled back.
- DIt ensures that commit state for a transaction is retained after a recoverable outage.
7You must configure an Oracle Data Guard environment consisting of
1. 1. A primary database
2. 2. A physical standby database
3. 3. A snapshot standby database
You must meet these requirements:
1. 1. Primary database availability should not be compromised by the availability of the standby databases.
2. 2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?- ASYNC AFFIRM and Maximum Protection
- BASYNC and Maximum Performance
- CSYNC NOAFFIRM and Maximum Availability
- DSYNC AFFIRM and Maximum Availability
- ESYNC NOAFFIRM and Maximum Protection
8Examine the Data Guard configuration:
1. DGMGRL > show configuration:
2. Configuration -Animals
3. Protection Mode: MaxAvailability
4. Databases:
5. cats- Primary database
6. dogs-Physical standby database
7. sheep-Logical standby database
8. Fast-Start Failover: DISABLED
9. Configuration Status: SUCCESS
Which statement will be true after a switchover to Dogs?- ACats will be a disabled physical standby database.
- BDogs will need to be reinstated.
- CSheep will need to be reinstated.
- DSheep will be an enabled logical standby database.
9Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)
- AEnsure that supplemental logging is enabled on the primary database.
- BEnsure that flashback is enabled on the primary database.
- CDo not perform any nologging operations on the primary.
- DEnsure that no BFILE LOB data types are contained in the primary database.
- EEnsure that no ROWID data types are contained in the primary database.
10Which two are true about the creation of a Data Guard Broker configuration? (Choose two.)
- AA standby database profile may be added to the configuration prior to creating that standby database.
- BA newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
- CIn a broker configuration, the primary database name must match the DB UNIQUE NAME value in the database initialization parameter file.
- DA primary database profile may be added to the configuration prior to creating the primary database.
- EA newly created broker configuration is in the disabled state.
11Which two are true about rolling release upgrades in a Data Guard environment? (Choose two.)
- AThe recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.
- BThe KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.
- CThe background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure.
- DRolling release upgrades require the background process RVWR to write flashback logs on the standby database.
- EA physical standby database can be converted to a logical standby database temporarily.
12Examine the Data Guard configuration:
1. DGMGRL> show configuration:
2. Configuration -Animals
3. Protection Mode: MaxAvailability
4. Databases:
5. dogs- Primary database
6. sheep-Logical standby database
7. cats- Logical standby database
8. Fast-Start Failover: DISABLED
9. Configuration Status:
10. SUCCESS
Which three will be true after a switchover to Sheep? (Choose three.)- ACats will be an enabled logical standby database.
- BSheep will be the primary database.
- CCats will be a disabled logical standby database.
- DDogs will be a logical standby database.
- EDogs will be a physical standby database.
13Which TWO statements are true about block media recovery in a Data Guard environment? (Choose two.)
- AWhen using RMAN, the RECOVER CORRUPTION LIST Command can automatically use blocks from flashback logs.
- BDB LOST WRITE_PROTECT must be set to FULL to enable Automatic Block Media Recovery.
- CWhen using RMAN, the RECOVER CORRUPTION LIST command can use blocks from block change tracking files.
- DDB_LOST_WRITE_PROTECT must be set to TYPICAL to enable Automatic Block Media Recovery.
- EA corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has Real-Time Query enabled.
14When using RMAN, the RECOVER CORRUPTION LIST Command can automatically use blocks from flashback logs:
This statement is true. RMAN has the capability to automatically use blocks from flashback logs during block media recovery to repair corrupt blocks in a Data Guard environment.
A corrupt block on the primary database can be recovered automatically, using blocks from a physical standby database that has Real-Time Query enabled: This statement is true. In a Data Guard environment, if a primary database has a corrupt block, it can be automatically recovered using blocks from a physical standby database that has Real-Time Query enabled. This is possible because the physical standby database continuously receives and applies redo data from the primary database, and the Real-Time Query feature allows it to be used for block media recovery on the primary database.- ADGMGRL> convert database sheep to physical standby;
- BDGMGRL> convert database cats to physical standby;
- C1. DGMGRL>edit configuration set protection mode as maxperformance;
2. DGMGRL> convert database sheep to physical standby; - D1. DGMGRL> convert database sheep to physical standby;
2. DGMGRL> convert database cats to physical standby; - ENone, because you can directly failover to a Snapshot Standby Database
15Your 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.
1. 1. Switchovers or failovers are possible due to testing or in case of a disaster.
2. 2. 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? (Choose three.)- AClient TNS entries for the databases use the correct service names for the intended service
- BA service name is registered with the local listener of each database instance
- COracle Net connectivity to the primary database instance must be established on all the standby database instances
- DThe LOCAL_LISTENER parameter on the primary database instance must always be set
- EThe standby database services must be defined statically with the Listeners running on the standby database hosts
- FThe client applications must use the correct TNS entries when requesting connections to the database instances
- GThe DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment
16Examine the Data Guard configuration:
1. DGMGRL >show configuration;
2. Configuration-Animals
3. Protection Mode MaxAvailability
4. Databases
5. dogs-Primary database
6. sheep-Snapshot standby database
7. cats-Physical standby database
8. Fast-Start Failover: DISABLED
9. Configuration Status: SUCCESS
10. You receive an error while attempting to raise the protection mode to Maximum Protection:
11. DGMGDRL> edit configuration set protection mode as maxprotection;
12. Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?- AExamine the Data Guard configuration:
1. DGMGRL >show configuration;
2. Configuration-Animals
3. Protection Mode MaxAvailability
4. Databases
5. dogs-Primary database
6. sheep-Snapshot standby database
7. cats-Physical standby database
8. Fast-Start Failover: DISABLED
9. Configuration Status: SUCCESS
10. You receive an error while attempting to raise the protection mode to Maximum Protection:
11. DGMGDRL> edit configuration set protection mode as maxprotection;
12. Error ORA-16627 operation disallowed since no standby databases would remain to support protection mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection? - BDGMGRL> edit database cats set property LogXptMode= sync;
- CDGMGRL> edit database sheep set property LogXptMode= sync;
- D1. DGMGRL> edit database dogs set property LogXptMode= sync;
2. DGMGRL> edit database cats set property LogXptMode= sync;
3. DGMGRL> edit database sheep set property LogXptMode= sync; - E1. DGMGRL> edit database dogs set property LogXptMode= sync;
2. DGMGRL> edit database cats set property LogXptMode= sync; - F1. DGMGRL> edit database dogs set property LogXptMode= sync;
2. DGMGRL> edit database sheep set property LogXptMode= sync;
- AExamine the Data Guard configuration:
17You must configure an Oracle dataguard environment consisting of * A primary Database * Two physical standby database
Examine these requirements:
1. 1. Data loss is not permitted
2. 2. It should be possible to convert either of the physical standby to a snapshot standby database.
3. 3. Under normal operations, transactions shouldnot commit before redo is written to disk on both the primary database and atleast on one standby database
4. 4. The availability of the primary database should not be compromised by the availability of standby databases.
5. 5. It should be possible to enable fast-start failover.
6. 6. It should be possible to deploy Real Application clusters on all databases.
You configure FASTSYNC redo transport mode on both the standby databases in combination with Maximum Availability mode.
Which requirements will you meet?- A1,2,4,5 and 6
- B2,4,5 and 6
- C2,3,4,5, and 6
- D2,4, and 5
- E1,2,3,4,5, and 6
18You detected an unrecoverable archive gap in your data guard environment. So, you need to roll standby forward in time without applying a large number of archive log files using this command:
RMAN> recover standby database from service-<primary database name>;
When running this command, which of the steps are performed automatically?
1. 1. Remember all datafile names on the standby
2. 2. Restart standby in nomount
3. 3. Restore controlfile from primary
4. 4. Mount standby database
5. 5. Rename datafiles from stored standby names.
6. 6. Restore new data files to new names
7. 7. Recover standby- A1,2,5,6,7
- B2,3,5,6,7
- C2,3,6,7
- D1,2,3,4,5,6,7
- E1,2,3,4,6,7
19Which TWO observations are true about the Far Sync Instance? (Choose two.)
- AIncludes a standby controlfile, password files, datafiles, standby redo logs and archive logs
- BCan be created using the RMAN DUPLICATE command
- CApplies redo recieved
- DCan only be created using a series of SQL commands
- ERecieves redo synchronously from the primary database
20Which FOUR database parameters might be affected by or influence the creation of standby database? (Choose four.)
- ADB_NAME
- BARCHIVE_LAG_TARGET
- CCOMPATIBLE
- DDB_FILE_NAME_CONVERT
- EDB_UNIQUE_NAME
- FFAL_SERVER
- GSTANDBY_ARCHIVE_DEST
21You must configure an Oracle Data guard environment, consisting of
1. 1. A primary database
2. 2. A physical standby database
Examine these requirements:
1. 1. Data loss is not permitted
2. 2. It should be possible to convert the physical standby database to a snapshot standby database
3. 3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. 4. The availability of the primary database should not be compromised by the availability of the standby database.
5. 5. It should be possible to convert the physical standby database to a logical standby database.
6. 6. It should be possible to deploy the Real Application clusters on the primary database.
7. 7, It should be possible to deploy the Real Application clusters on the physical standby database.
8. You configure SYNC redo transport mode in combination with Maximum Protection Mode
Which requirement will you meet?- A1,2,3,4,5,6, and 7
- B1,2, and 5
- C1,2,6,and 7
- D1,6, and 7
- E1,2,3,6, and 7
22You must configure an Oracle Data Guard environment consisting of:
1. 1. A primary database
2. 2. Three Physical Standby Databases
You must meet these requirements:
1. 1. A designated physical standby database should become the primary database automatically whenever the primary database falls.
2. 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?- AFASTSYNC and Maximum Protection
- BFASTSYNC and Maximum Availability
- CSYNC and Maximum Protection
- DASYNC and Maximum Performance
23You are planning to perform block comparison using the DBMS_COMP package:
SQL> exec sys.dbms_dbcomp.dbcomp ('1', 'BlockCompare', :retval)
Which TWO statements are true? (Choose two.)- ALogical standby databases can be the target database for the DBMS_DBCOMP.DBCOMP procedure.
- BThe databases should be at least mounted before block comparison.
- CIt requires that the DB_LOST_WRITE_PROTECT initialization parameter be enabled.
- DYou can monitor the progress of an ongoing block comparison operation by querying V$SESSION_ LONGOPS.
- EIt can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.
24You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements:
1. 1. Data loss is not permitted,
2. 2. Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. 1. It should be possible to apply designated patches with a minimum amount of downtime.
2. 2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. 3. New application software releases should be tested against an exact and up-to-date replica of the prima database.
Which configuration meets these requirements with the fewest databases?- AA primary database with three physical standby databases
- BA primary database with one logical standby database
- CA primary database with one logical and one physical standby database
- DA primary database with one logical and two physical standby database
- EA primary database with two physical standby database.
- FA primary database with one physical standby database.
25You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:
1. 1. Data loss is not permitted.
2. 2. Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. 1. It should be possible to apply and test designated patches with a minimum amount of downtime.
2. 2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. 3. New application software releases should be tested against an exact up-to-date replica of the production database.
Your propose a primary database with one physical standby database configured in Maximum Protection mode.
Which requirements do you meet?- A1, 2, 3, 4, and 5
- B2, 3, 4, and 5
- Conly requirement 5
- Donly requirement 1
- E1 and 2
26Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment? (Choose two.)
- AA static service must be registered with the local listener to enable DGMGRL to restart instances during the course of broker operations.
- BEnterprise Manager does not require static service registration to restart instances during the course of broker operations..
- CInstall the oracle-database-preinstall-19c package to set the kernel parameters for Oracle Net based on the Data Guard best practice guidelines.
- DInstalling the oracle-database-preinstall-19c package is NOT sufficient to set up operating system kernel parameters for Oracle Net.
- EIt is necessary to use the FAILOVER clause for an ADDRESS_LIST with multiple address lists in the tnsnames.ora file.
27Which THREE are benefits of using the Data Guard Broker to manage standby databases? (Choose three.)
- AIt provides an easy switchover capability using a single command.
- BIt coordinates database state transitions and updates database properties dynamically.
- CIt provides an easy failover capability using a single command.
- DIt load balances connections between the primary and all the standby database instances that are open as read-only for reporting.
- EIt automatically changes database properties after the protection mode for a configuration is changed.
- FIt simplifies physical standby database creation.
- GIt simplifies logical standby database creation.
28Examine this query and its output:
1. SQL> select fs_failover_status, fs_failover_current_target, fs_failover_observer_present, fs_failover_observer_host from v$database;
2. fs_failover_status, fs_failover_current_target, fs_failover_observer_present, fs_failover_observer_host
3. ---------- ----- ------ -----------------
4. BYSTANDER cats NO ol7.example.com
Which two statements are true? (Choose two.)- AThe master observer is connected to the database on which the query was executed.
- BThe master observer is currently running on ol7.example.com.
- CThe master observer is not connected to the database on which the query was executed.
- DCats is a bystander database.
- EThe master observer is not running but should run on ol7.example.com.
29Which THREE statements are true about snapshot standby databases? (Choose three.)
- AFLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.
- BFLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.
- CA snapshot standby database may be opened read-write.
- DA snapshot standby database may be opened read-only.
- EFLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.
- FA snapshot standby database can have Real-Time apply enabled.
30Which three are always benefits of using a logical standby database? (Choose three.)
- AIt can be used for database rolling release upgrades
- BIt can be used to replicate a single pluggable database (PDB) in a multitenant container database.
- CIt can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
- DIt can be used for reporting workloads requiring additional indexes or materialized views or both.
- EIt provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
- FIt can be used for testing patches without affecting the primary database.
31Which three are true concerning database states after a successful switchover? (Choose three.)
- AIf the former primary database became a logical standby database, it will be open read-write.
- BIf the former primary database became a physical standby database, it will always be open read- only.
- CThe new primary database will be open read-write.
- DIf the former primary database became a physical standby database, it will be in the same state as the former physical standby database.
- EThe former primary database will always be open.
- FIf the former primary database became a logical standby database, it will be in mount state.
32Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structural changes on the primary database? (Choose two.)- AAdding or dropping a redo file group
- BCreating a PDB from the existing PDB within the same CDB
- CRenaming a data file in the primary database
- DPerforming transportable tablespaces
- EAdding a datafile or creating a tablespace
33Suppose that you manage the following databases in your environment:
* Boston: Primary database with a single PDB called DEV1.
* London: Physical standby database protecting the PDB called DEV1
* ORCL: Standalone database with a single PDB called PDB1 as a remote clone source
You are planning to run the following command to create a remote clone in the primary database(boston) using PDB1 in ORCL
SQL> CREATE PLUGGABLE DATABASE new_pdb1 FROM pdb1@clone_link;
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (London)? (Choose three.)- AOpen PDB (remote clone source) in Read Only.
- BOpen PDB1 (remote clone source) in Read Write.
- CSet STANDBY PDB SOURCE FILE DIRECTORY to <location of the PDB> in the london database.
- DEnable Active Data Guard in the london database.
- ESet STANDBY POB_SOURCE_FILE_DBLINK to clone_link in the London database.
- FSet STANDBY FILE MANAGEMENT to AUTO in the london database.
34A customer asks you to propose the most appropriate solution for this set of requirements:
1. 1. We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
2. 2. We want to generate reports from the proposed standby database at the same time that it is used for other purposes.
3. 3. Developers may need to test occasionally on a copy of the live database.
You have already confirmed that there are no unsupported data types on the primary database.
Which two solutions would you recommend? (Choose two.)- AA logical standby database
- BA read mostly implementation of a physical standby database
- CA physical standby database with real-time query enabled
- DA remote physical standby database with RedoRoutes via a far sync instance
- EA snapshot standby database with synchronous redo transport
35Your Data Guard environment consists of these components and settings:
1. 1. A primary database
2. 2. A remote physical standby database
3. 3. Real-time query is enabled.
4. 4. The redo transport mode is set to SYNC.
5. 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? (Choose two.)- AIncrease the network bandwidth between the primary and standby databases.
- BChange the protection mode to Maximum Protection.
- CReduce I/O latency for the storage used by the primary database.
- DIncrease the size of the buffer cache on the standby database instance.
36Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.)
- AEach pluggable database within a multi-tenant physical standby database has one MRP background process running during redo apply.
- BDB_UNIQUE_NAME must be specified differently for each pluggable database within a multi-tenant standby database.
- CEach pluggable database within a multi-tenant physical standby database has a minimum of one associated Oracle Net service name.
- DA pluggable database within a multitenant standby database can have a different database role than the container database.
- EA pluggable database within a multi-tenant standby database can have a different open mode than the container database.
37Which two statements are true regarding asynchronous redo transport in a Data Guard environment? (Choose two.)
- AThe performance of SQL apply on a logical standby database always improves when using this transport mode.
- BA transaction can commit without waiting for redo to be sent to any standby database in the data guard configuration.
- CThis transport mode satisfies the minimum requirements for Maximum Availability data protection mode.
- DReal-time query performance on a physical standby database improves for current read requests when using this transport mode.
- EThis transport mode satisfies the minimum requirements for Maximum Performance data protection mode.
38You are licensed to use Oracle Active Data Guard.
Which TWO statements are true after enabling block change tracking on a physical standby database? (Choose two.)- AIt allows fast incremental backups to be taken on the primary database.
- BIt starts the CTWR process on the physical standby database instance.
- CIt allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted.
- DIt starts the RVWR process on the physical standby database instance.
- EIt starts the CTWR process on the primary database instance.
- FIt allows fast incremental backups to be offloaded to the physical standby database.
39Examine the Data Guard configuration;
1. DGMGRL> show configuration;
2. Configuration Animals
3. Protection Mode: MaxPerformance
4. Databases: dogs- Primary database
5. sheep- Physical standby database
6. cats- Snapshot standby database
7. Fast-Start Failover: DISABLED
8. Configuration Status:
9. SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection:
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
What can you conclude based on this error?- AThe redo transport mode is set to ASYNC for both standby databases.
- BThe redo transport mode is set to ASYNC for the standby database Cats.
- CCats is a snapshot standby database.
- DThe redo transport mode is set to ASYNC for the standby database Sheep.
40Your Data Guard environment contains a primary database and three standby databases with these attributes:
s? (Choose two.)- ACreate database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.
- BCreate a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.
- CEstablish Oracle Net connectivity to the primary database instance from all the standby database instances.
- DCreate database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.
- ECreate role-based services with the srvtl utility when using cluster ware for Oracle RAC
41Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment? (Choose two.)
- AThe standby database cannot be registered in an RMAN catalog if the primary database has not been registered.
- BBackups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database.
- CThe standby database must be registered in an RMAN catalog after the primary database has been registered.
- DThe standby database must be registered in an RMAN catalog before the primary database has been registered.
42Examine the procedure that you plan to execute on your logical standby:
SQL> execute dbms_logstdby.skip(stmt => 'DML', schema_name => 'HR', object_name => 'EMPLOYEE');
What is a prerequisite for execution of this procedure?- AStop SQL apply on the logical standby database.
- BStop redo transport to the logical standby database.
- CChange the redo transport mode if necessary to ASYNC.
- DExecute the DBMS_LOGSTDBY.APPLY SET procedure to record errors that might cause SQL Apply to stop.
43Examine the Data Guard configuration:
1. DGMGRL> show configuration:
2. Configuration -Animals
3. Protection Mode: MaxAvailability
4. Databases:
5. dogs- Primary database
6. cats- Snapshot standby database
7. sheep- Snapshot standby database
8. Fast-Start Failover: DISABLED
Configuration Status:
ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs" DGM-17017: unable to determine configuration status
Which three will be true after a successful failover to Cats? (Choose three.)- ASheep will be in the disabled state.
- BThe configuration will be in Maximum Availability mode.
- CThe configuration will be in Maximum Performance mode.
- DDogs will bein the disabled state and has to be manually reinstated.
- ESheep will be in the enabled state.
44Which three types of backups offloaded to a physical standby database, are fully interchangeable with the primary database in a Data Guard configuration? (Choose three.)
- AOnline logs
- BData files
- CPassword files
- DArchive logs
- EBroker configuration files
- FControl files
45A customer has these requirements for their potential Data Guard implementation:
1. 1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. 2. The primary database must be protected against a regional disaster.
3. 3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. 4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:
1. prima|the primary database
2. fs1|the Far Sync instance in the primary region
3. physt|a physical standby database in a remote region
4. physt1|a physical standby database in the primary
5. physt2|a physical standby database in a remote region
Which Data Guard broker commands are needed to implement these requirements?- A1. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1SYNC);
2. EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=" (prima: physt ASYNC)'; |
3. EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - B1. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: physt1,FASTSYNC)';
2. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL:fs1 SYNC)’;
3. EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES=" (prima:physt2 SYNC)’;
EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - C1. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL:physt1, FASTSYNC)';
2. EDIT DATABASE prima SET PROPERY REDOROUTES=" (LOCAL: fs1, FASTSYNC)';
3. EDIT FAR_SYNC fs1SET PROPERTY REDORUOTES=" (prima: physt2 ASYNC)’;
4. EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY; - D1. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1ASYNC);
2. EDIT FAR_SYNC fs1 SET PROPERTY REDORUOTES="' (prima: physt FASTSYNC)';
3. EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION
- A1. EDIT DATABASE prima SET PROPERY REDOROUTES=' (LOCAL: fs1SYNC);
46You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.
Which of the following steps are required to restore the lost file over the network?
1. 1. Connect to the physical standby database as the TARGET
2. 2. Connect to the physical standby database as the AUXILLARY
3. 3. Back up the data file as copy on the standby host to a location only available on the standby host
4. 4. Back up the data file as copy on the standby host to a location that is available on the primary host
5. 5. Catalog the data file copy for RMAN to use on the primary database for restore.
6. 6. Connect to the primary database as the AUXILIARY.
7. 7. Connect to the primary database as the TARGET.
8. 8. Restore the lost data file from the physical standby database using the FROM SERVICE clause.- A2,4,7
- B1, 3, 5, 6
- C1, 4, 5, 6
- D7,8
47Which three statements are true about snapshot standby databases? (Choose three.)
- ATablespaces can be dropped.
- BTables can be dropped
- CTablespaces can be created.
- DThe switchover to command allows a switchover operation to a snapshot standby database
- EA logical standby database can be converted into a snapshot standby database.
- FThe failover to command results in a transition of a snapshot standby database to the primary role.
48Which THREE statements are true about Far Sync instances? (Choose three.)
- AThey enable standby databases to be configured at remote distances from the primary without impacting performance on the primary.
- BThey use as spfile, a standby controlfile, and standby redo logs.
- CThe Data Guard Broker must be used to deploy and manage Far Sync instances.
- DA primary database can ship redo directly to multiple Far Sync instances.
- EThey work with any protection level.
49Which 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? (Choose two.)
- AA corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.
- BA corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.
- CA corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.
- DA corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.
- EA corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.
50Which THREE are true about using flashback database in a Data Guard environment? (Choose three.)
- AWhen a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.
- BIt may not be used to flash back a primary database after a failover to a physical standby.
- CWhen a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.
- DYou can use it when real-time apply is enabled in case the phyIt may not be used to flash back a primary database after a failover to a logical standby.
- EYou can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.
- FIt may be used to flash back a physical standby that receives redo from a far sync instance.
51Examine this Validate command:
DGMGRL> VALIDATE DATABASE VERBOSE '<database name>';
Which THREE statements are TRUE? (Choose three.)- AThe command performs network connectivity checks between members of a broker configuration.
- BThe command performs a comparison of SPFILE entries between the primary database and a specified standby database.
- CThe command can be used for a logical standby database.
- DThe command uses information available in various Oracle Data Guard views as well as the Automatic Diagnostic Repository.
- EThe command performs a comprehensive set of database checks prior to a role change.
52Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?- AStandby Statspack
- BAutomatic Workload Repository (AWR)
- CSQL Tuning Advisor
- DIn-Memory Active Session History (ASH)
- EAutomatic Diagnostic Database Monitor (ADDM)
53Examine the Data Guard configuration:
1. DGMGRL> show configuration;
2. Configuration Animals -
3. Protection Mode: MaxAvailability
4. Databases:
5. dogs- Primary database
6. sheep- (*) Physical standby database
7. cats- Physical standby database
8. Fast-Start Failover: ENABLED -
Configuration Status:
SUCCESS -
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?- AThe switchover succeeds but Dogs needs to be reinstated.
- BThe switchover succeeds and Cats becomes the new failover target.
- CThe switchover succeeds and Fast-Start Failover is suspended.
- DIt results in an error indicating that a switchover is not allowed.
- EThe switchover succeeds and Dogs becomes the new failover target.
54Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control? (Choose three.)
- AYou can check if redo apply needs to be tuned.
- BYou can check the potential data loss in the event of a disaster.
- CYou can set a warning threshold on the redo generation rate metric for a physical standby database.
- DYou can monitor the redo apply rate on a logical standby database.
- EYou can set a critical threshold on the redo generation rate metric for a primary database.
- FYou can monitor the redo apply rate on a snapshot standby database.
55Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package? (Choose three.)
- Abuilding a LogMiner dictionary on the primary database instance
- Bswitching the primary database to the logical standby role
- Ccreating a guaranteed restore point on the primary database.
- Dcreating a guaranteed restore point on the standby databases.
- Econverting the designated physical standby database into a logical standby database
- Fstarting media recovery on all the Leading Group Standby databases
56Examine this list of possible steps:
1. 1 Raise the compatibility level on both databases.
2. 2 Restart SQL Apply on the upgraded logical standby database.
3. 3 Start SQL Apply on the old primary database.
4. 4 Perform a Switchover to the logical standby database.
5. 5 Upgrade the logical standby database.
6. 6 Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?- A4,6,5,2,3,1
- B5,2,4,6,3,1
- C1,5,2,4,6,3
- D5,2,4,1
- E5,2,4,3,6,1
57Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or GoldenGate configured? (Choose three.)
- AThe LGWR process writes to them on a standby database.
- BThey are required only for synchronous redo transport.
- CThey are required on a logical standby for real-time apply.
- DOnly standby databases can write redo to them.
- EIt is recommended to have them on the primary database.
- FThey are required on a physical standby for real-time apply.
58Which four factors can influence the rate of SQL apply on a logical standby database? (Choose four.)
- Athe number of full table scans performed by SQL apply
- Bthe number of APPLIER processes
- Cthe number of PREPARER processes
- Dthe size of the undo tablespace on the logical standby database
- Ethe size of the shared pool
- Fthe number of coordinator processes on the standby database instance
59Which THREE are required in order to use Real-Time Query without lagging behind the primary? (Choose three.)
- AReal-Time apply must be enabled on the standby.
- BThe primary must ship redo asynchronously.
- CThere must be standby redo logs on the standby database.
- DCOMPATIBLE must be set to 11.1.0 or higher.
- EThere must be standby redo logs on the primary database.
60A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary? (Choose three.)- AWith manual upgrade, catupard.agt can be executed on the primary and standby databases simultaneously.
- BRedo Apply on the standby database must be stopped while the primary database is upgraded.
- CThe broker must be disabled during the upgrade.
- DFast-Start Failover can be used to protect the primary database during the upgrade.
- EThe upgrade requires downtime until the upgrade of the primary is completed.
- FThe new release of the Oracle software must be installed on both the primary and standby database hosts.
- GThe upgrade requires downtime until the upgrade of the standby is completed.
61You must configure flashback database for your Oracle 19c databases that will be part of a dataguard 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? (Choose three.)- AIt will execute successfully on an Oracle 19c physical standby database while Real Time query is active.
- BIf executed successfully on an Oracle 19c primary database, flashback will also be enabled on all physical standy databases that are part of the configuration
- CIt will execute successfully while an Oracle 19c primary database is open.
- DIt will execute successfully while an Oracle 19c primary database is mounted.
- EIt executed successfully on an Oracle 19c primary database, flashback will also be enabled on all logical standby databases that are part of the configuration
- FIt will execute successfully on an Oracle 19c logical standby database while SQL apply is active
62Which two are prerequisites for configuring flashback database for Oracle 19c databases, in a Data Guard environment? (Choose two.)
- AA far sync instance must be configured to flash back a standby when the primary has been flashed back.
- BThe Data Guard real-time apply feature must be enabled.
- CThe data guard broker must be used.
- DA fast recovery area must be configured.
- EThe database must be in ARCHIVELOG mode.
63Which TWO statements are true about database parameters for databases in a Data Guard environment? (Choose two.)
- ALOG FILE NAME CONVERT applies to online redo logs and archived logs.
- BCOMPATIBLE must have identical values for primary and standby databases.
- CIf DB RECOVERY FILE_DEST is specified, then LOG ARCHIVE_DEST n is not required for local archive logs.
- DThe databases that are part of a Data Guard configuration must have different DB UNIQUE NAME initialization parameters.
- EDB FILE NAME CONVERT is only required if the standby database is on the same host as the primary database.
64Which two are true about managing and monitoring Oracle container databases in a Data Guard environment using the broker? (Choose two.)
- AIf the primary database is a container database, then a logical standby may be a non-container database.
- BAll broker actions execute at the root container for container databases.
- CIf the primary database is a container database, then a physical standby may be a non- container database.
- DIf the primary database is not a container database, then a standby may be a container database.
- EAfter a role change, the broker opens all Pluggable databases (PDBS) on the new primary.
65Which four are true about the DGMGRL SHOW command? (Choose four.)
- AIt can be used to show properties of a pluggable primary database.
- BIt can be used to show properties of a far sync instance.
- CIt can be used to show Fast Start Failover properties.
- DIt can be used to show instance-specific properties for a RAC database.
- EIt can be used to show properties of a primary container database.
- FIt can be used to show properties of a pluggable standby database.
66Which TWO are benefits of using Transaction Guard in a Data Guard environment? (Choose two.)
- AIt protects against user errors being replicated to standby databases
- BIt provides application continuity by replaying transactions interrupted by a failover or a switchover.
- CIt protects against recoverable errors during a planned or an unplanned outage of a primary database.
- DIt protects against logical corruptions being replicated to standby databases.
- EIt provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.
67Your Data Guard environment has two remote physical standby databases. Client applications use the local naming method to connect to the primary database instance. You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?- ASet 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.
- BSet 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. - CCreate 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. - DSet the LOCAL LISTENER parameter for all the database instance to register services with the default listener on the primary database host.
68Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose SID is PROD_SBY.
Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the primary database role:
srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150
Consider this list of tasks
1. On a node of the standby database cluster execute
srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdelay 10 -failoverretry 150
2. On the primary database, create the OLTPWORKLOAD database service using the DBMS_SERVICE.CREATE_SERVICE procedure
3. Configure the TAF clients in the tnsnames.ora files
4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances
5. On the standby database, create the OLTPWORKLOAD database service using the DBMS_SERVICE.CREATE_SERVICE procedure
Identify the required steps to configure and use Transparent Application Failover (TAF)- A3,4
- B5
- C1,4
- D1,3,4
- E4
- F2,3,4
69In Oracle Database 19c, you can set the value of database initialization parameters in a database using the EDIT DATABASE...SET PARAMETER Command:
DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace =1:
Which THREE statements are TRUE about the command? (Choose three.)- AThe value set using this command is directly stored in the broker configuration file.
- BThe value set using this command is directly applied to the boston database.
- CThe database must be available when the above command is run.
- DThe EDIT DATABASE PARAMETER command can only be used to modify the value of a dynamic parameter in a database.
- EThe EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.
70After converting your physical standby database to a logical database, you get an error:
1. DGMGRL> show configuration
2. Configuration- proddg
3. Protection Mode: MaxPerformance
4. Databases:
5. prod-Primary datatabse 1
6. prodsby-Physical standby database
7. Error: ORA-16810 multiple errors or warnings detected for database
8. Fast-Start Failover: DISABLED
Configuration Status: 1
ERROR
How can you rectify the error?- ARemove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
- BAdda logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
- CReinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is 2 logical standby updates to the metadata.
- DReinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
71Which three are prerequisites for enabling Fast-Start Failover? (Choose three.)
- AFlashback Database must be enabled only on the Fast-Start Failover target standby database.
- BFlashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.
- CThe Data Guard environment must be managed by the Data Guard Broker. You can specify only one standby database as the fast-start failover target.
- DThe configuration must be operating in either Maximum Performance or Maximum Protection mode.
- EThe maximum protection mode can be used, but with two or more standby databases.
72Examine the Data Guard configuration:
1. DGMGRL > show configuration;
2. Configuration-Animals
3. Protection Mode: MaxAvailability
4. Databases:
5. dogs- Primary database
6. sheep- Physical standby database
7. cats - Physical Standby database
8. Fast-Start Failover: DISABLED
9. Configuration Status: SUCCESS
10. An attempt to enable fast-start failover raises an eror:
11. DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover Failed.
Identify two possible reasons for this error.? (Choose two.)- ATHe LogXptMOde property is set to ASYNC on Dogs
- BThe LogXptMode property is set to FASTASYNC on Cats while Sheep is the target standby database
- CThe LogXptMode property is set to FASTASYNC on Dogs
- DThe LogXptMode property is set to ASYNC on sheep while Sheep is the target standby database
- EThe FastStartFailoverTarget property is not set on Dogs
73Which TWO statements are true regarding Data Guard Broker? (Choose two.)
- AIt can be used to monitor redo transport and log apply services.
- BIt can be used to create and manage standby databases.
- CIt automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
- Dcan be used to perform failovers and switchovers.
- EIt automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
74Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.)
- AThe primary database instance must be started using an SPFILE.
- BThe primary database must have flashback enabled
- CA backup of the primary database must exist.
- DThe primary database must be in archive log mode
- EThe primary host and the proposed standby database host must run the same operating system.
- FThe primary database must have FORCE LOGGING enabled.
75A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows As a result of this, you decide that an upgrade may use logical standby databases.
Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary? (Choose two.)- ASQL Apply on the local standby database must be stopped while the primary database is upgraded.
- BUsing manual upgrade, catctI.pI can be executed in some cases on the primary and standby database simultaneously.
- CThe upgrade always requires downtown until the upgrade of the logical standby is completed
- DThe upgrade always required downtime until the upgrade of the primary is completed
- EFast-Start Failover can be used to protect the primary database during the upgrade.
- FUsing manual upgrade, catupgr.sqI needs to run on the primary database only.
76You must manually reinstate a database using DGMGRL. To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?
- AThe target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration
- BThe target database should be MOUNTED and DGMGRL should be connected to the target database
- CThe target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration
- DThe target database should be in NOMOUNT state and DGMGRL should be connected to the primary database
- EThe target database should be MOUNTED and DGMGRL should be connected to the primary database.
77Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)
- ACreate a standby controlfile
- BCreate an SPFILE for the standby database
- CTransfer a copy of the passwordfile from the primary host to the standby host
- DRun the nid utility to modify the DBID of the primary database
- EConfigure Oracle Net connectivity between the primary host and the standby host
78What is the maximum number of standby databases supported by the Data Guard Broker?
- A10
- B20
- C30
- D40
79Attempting to start the observer raises an error:
1. DGMGRL> start observer:
2. DGM-16954: Unable to open and lock the Observer configuration file Failed.
Identify two possible reasons for this error.? (Choose two.)- AThe observer configuration file is marked read-only.
- BThere is another observer running for a Data Guard configuration which uses the same observer configuration file
- CThe broker configuration has not yet been created.
- DThere is already an observer running for this Data Guard configuration.
- EFast-Start Failover is not yet enabled for this Data Guard configuration
80Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled? (Choose three.)
- ATheir creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary
- BTheir usage may have a performance impact on the physical standby database if the CACHE size is too small
- CThey must have the NOORDER and CACHE options set.
- DIf the CACHE option is set then the size of the cache must be atleast 100
- ETheir usage will always have a performance impact on the primary database.
Information
- Description
- Quiz on Oracle Database 19c Dataguard, created by Elda Quintero on 28/08/2024.
- Author
- Elda Quintero
- Language
- English
- Views
- 11
- Tags
- Rating
- No ratings yet Rate this quiz