The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

• A.The database must be registered in an RMAN catalog.
• B.Only consistent backups can be created.
• C.Backups can be taken only if the database is in ARCHIVE LOG mode.
• D.Backups must be done incrementally.
• E.Backups must be contained in backup sets.
• F.Backups can be done incrementally.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

• A.Data Recovery Advisor can proactively check for failures.
• B.The Data Recovery Advisor change failure command can be used only to change failure priorities.
• C.Data Recovery Advisor can be used if a database is closed.
• D.Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.
• E.A failure can be closed only when it has been repaired.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases?

• A.It uses a single RPM that automatically extracts and installs the Oracle Database software.
• B.It does not require the setup wizard.
• C.It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
• D.It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
• E.It can only install and configure Oracle Database software. The database has to be created separately.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

• A.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• B.SBT tape compression can be used even if no RMAN compression is configured.
• C.The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
• D.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
• E.SBT tape compression and RMAN backup compression should be used in parallel.

Comment: *

Name: *

Email: *

Verification: *

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Enable only OMF.
• B.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• C.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• D.Set only the PDB_FILE_NAME_CONVERT parameter.
• E.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
• F.Add only the CREATE_FILE_DEST clause to the statement.

Comment: *

Name: *

Email: *

Verification: *