Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

• A.After the change, only one undo tablespace can exist in CDB$ROOT.
• B.After the change, each existing PDB has to be reopened for the new undo mode to take effect.
• C.After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• D.Undo tablespaces existing in PDBs must be dropped before the change.
• E.Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
• F.After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

Comment: *

Name: *

Email: *

Verification: *

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

• A.RANDOM redaction is active on the MGR column
• B.PARTIAL redaction is active of the HIREDATE column.
• C.RANDOM redaction is active on the HIREDATE column
• D.PARTIAL redaction is active on the MGR column.
• E.FULL redaction is active on the SAL column

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

• A.By default, MMON creates an AWR snapshot every 30 minutes.
• B.ADDM can recommend extending the buffer cache.
• C.ADDM performs its analysis only when a DBA requests it.
• D.By default, AWR snapshots are automatically purged after eight days.
• E.AWR snapshots must be deleted when no longer required by ADDM.
• F.ADDM can recommend shrinking the buffer cache.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database running in archivelog mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are inactive.
4. Redo log group 3 is the current group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

• A.1, 3, 5, 6, 9
• B.1, 3, 5, 6, 10
• C.1, 3, 5, 7, 10
• D.1, 3, 5, 6, 10
• E.1, 3, 5, 8, 6, 10
• F.1, 2, 5, 7, 4, 10

Comment: *

Name: *

Email: *

Verification: *

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

• A.A base recovery catalog should exist.
• B.The recovery_catalog_owner role should be granted to the virtual catalog owner.
• C.At least one target database should be registered in the recovery catalog.
• D.The register database privilege should be granted to the virtual catalog owner.
• E.The owner of VPC cannot own recovery catalog.

Comment: *

Name: *

Email: *

Verification: *