Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?

• A.creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
• B.opening the cloned PDB
• C.backing up the cloned PDB
• D.creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
• E.leaving the cloned PDB in mount state

Comment: *

Name: *

Email: *

Verification: *

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

• A.It succeeds.
• B.It fails because no parallel channels are allocated for the auxiliary database.
• C.It fails because connection to the AUXILIARY instance must be as SYSDBA.
• D.No catalogued backup of the TARGET is used to duplicate the database.
• E.Itsucceeds only if the target database is greater than 400M.

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: *

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

• A.Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
• B.If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
• C.Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
• D.If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
• E.Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
• F.Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
• G.If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle Database?

• A.A media corrupt block is one where the block is not formatted correctly.
• B.The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.
• C.If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.
• D.DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.
• E.If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.
• F.DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

Comment: *

Name: *

Email: *

Verification: *