Which four requirements can be met by deploying a logical standby database?

• A.Support for workloads requiring additional materialized views.
• B.It must have the same physical structure as the primary database.
• C.It can be used to create additional tables.
• D.It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
• E.It can be used for Real Application Testing without affecting the disaster recovery capabilities.
• F.Support for workloads requiring additional indexes.
• G.It can be used to create additional schemas.

Comment: *

Name: *

Email: *

Verification: *

In 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?

• A.The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.
• B.The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.
• C.The database must be available when the above command is run.
• D.The value set using this command is directly stored in the broker configuration file.
• E.The value set using this command is directly applied to the boston database.

Comment: *

Name: *

Email: *

Verification: *

Which THREE are true about using flashback database in a Data Guard environment?

• A.When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.
• B.You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.
• C.It may be used to flash back a physical standby that receives redo from a far sync instance.
• D.You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.
• E.It may not be used to flash back a primary database after a failover to a physical standby.
• F.When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.

Comment: *

Name: *

Email: *

Verification: *

You created two remote physical standby databases using SQL and RMAN.
The primary database is a four-instance RAC database and each physical standby database has two instances.
Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.
Consider these operational requirements:
* The ability to manage multiple standby databases with a single tool
* The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases
* The automation of failovers to a specified target standby database
Which TWO tools can be used to fulfill these requirements7

• A.RMAN
• B.SQL*Plus
• C.CRSCTL
• D.Enterprise Manager Cloud Control
• E.DGMGRL
• F.SRVCTL
• G.GDCCTL

Comment: *

Name: *

Email: *

Verification: *

Which three types of backups offload ........ with the primary database in a data Guard

• A.Control files
• B.Broker configuration files
• C.Password files
• D.Data files
• E.Online logs
• F.Archive logs

Comment: *

Name: *

Email: *

Verification: *