Which two are true about automatic block repair?

• A.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• B.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• C.It is not possible for media corrupt blocks.
• D.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
• E.Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• B.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• C.A Virtual Private Catalog used to register a container database can be created in a non-container database.
• D.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• E.It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• F.It is always possible for RMAN to connect to a pluggable database as a target.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about a read-only Oracle home?

• A.Its configuration data and log files reside in subdirectories under the Oracle home.
• B.It requires the Rapid Home Provisioning service.
• C.It contains an image that can be distributed across multiple servers.
• D.It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
• E.It is enabled by performing a software-only Oracle Database installation and then running the roohctl -enable script.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.PDB1is closed.
• B.CDB1is shut down.
• C.Uncommitted transactions in CDB1and PDB1have been rolled back.
• D.Uncommitted transactions in PDB1have been rolled back.
• E.CDB1is in MOUNT state

Comment: *

Name: *

Email: *

Verification: *

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A.It recompiles all stored PL/SQL code by using utlrp.sql.
• B.It empties the RECYCLE BIN.
• C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *