Which four are true about RMAN backup sets?

• A.Blocks from multiple data files can be contained in one backup set.
• B.A backup piece can belong to only one backup set.
• C.A backup set must be written to media.
• D.A data file can be split into multiple sections stored in different backup sets.
• E.A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• F.A backup set must be written to disk.
• G.Blocks from multiple data files can be contained in one backup piece.
• H.A backup set can contain only one backup piece.

Comment: *

Name: *

Email: *

Verification: *

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

• A.It recompiles all stored PL/SQLcode 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_ADMINand AUDIT_VIEWERroles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can be run only manually.
• B.It is part of the DBMS_ADVISOR package.
• C.It can recommend changes to improve the statistics gathering process.
• D.It always analyzes all schemas in the database.
• E.It runs automatically every night by default.
• F.It is part of the DBMS_STATS package.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about backing up the control file?

• A.It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs.
• B.It can be backed up manually as a binary copy.
• C.It can be backed up manually as a trace file containing SQL statements for control file recreation.
• D.It can get backed up automatically as a binary copy.
• E.It cannot be backed up manually as a binary copy.
• F.It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.

Comment: *

Name: *

Email: *

Verification: *