Which four are true about RMAN backup sets? (Choose four.)

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

Comment: *

Name: *

Email: *

Verification: *

Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

• A.2,4,5
• B.1,3,4,5
• C.2,4,5,6
• D.1,2,4,5
• E.1,2,3,4,5,6

Comment: *

Name: *

Email: *

Verification: *

Which two are true about monitoring waits for sessions and services?

• A.v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.
• B.v$session_wait_class displays waits broken down by wait class only for waiting sessions.
• C.v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.
• D.v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• E.v$service_event displays wait counts for every wait event whether waited on or not, for each service.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

• A.Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
• B.The Oracle Application Express configuration should be updated after upgrading Oracle Database.
• C.After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
• D.Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
• E.The new extended data type capability must be enabled by running the utlrp.sql script

Comment: *

Name: *

Email: *

Verification: *

How do you configure a CDB for local undo mode?

• A.Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
• B.Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
• C.Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
• D.Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
• E.Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

Comment: *

Name: *

Email: *

Verification: *