choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?

• A.user-managed backups of data files and control files
• B.RMAN backups that are obsolete
• C.flashback logs
• D.archived redo log files that have multiple copies in a different archive location

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true in Oracle 19c and later releases?

• A.Tablespaces never remain in read/write mode during transportable tablespace operations.
• B.Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
• C.An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
• D.A transportable data pump import can leave a plugged-in tablespace in read/write mode.
• E.A transportable data pump import can leave a plugged-in tablespace in read-only mode.
• F.Tablespaces always remain in read/write mode during transportable tablespace operations.

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?

• A.VSSESSTAT
• B.VSSESSION
• C.VSSESSION_EVENT
• D.VSSESSION_WAIT_CLASS
• E.V$SESSION_WAIT

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 cannot be backed up manually as a binary copy.
• C.It can be backed up manually as a binary copy.
• D.It gets backed up automatically by RMAN when the BACKUP SPFILE command is used.
• E.It can get backed up automatically as a binary copy.
• F.It can be backed up manually as a trace file containing SQL statements for control file recreation.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about Rapid Home Provisioning of Oracle software?

• A.It can be used to upgrade only single-instance databases running on Oracle Restart.
• B.It can be used only on nodes with Oracle Grid Infrastructure installed.
• C.It can be used to patch existing Oracle software installations.
• D.It can be used to create templates of Oracle homes as gold images of only Oracle databases.
• E.It can be used to create a single-instance Oracle Database in an already-installed Oracle home. D)It can be used to deploy new homes without disrupting active databases.

Comment: *

Name: *

Email: *

Verification: *