Online Access Free 1z1-074 Practice Test

Which statement is true about policy expressions?

• A.A redacted table can have only one policy expression defined on it.
• B.A named policy expression is stored in the Data Masking format library.
• C.A named policy expression is stored in the Enterprise Manager Database Express repository.
• D.A policy expression can be applied to columns in different redacted tables.
• E.A named policy expression applied to a column in a redacted table overrides the default expression of its redaction policy.

Identify two operations for which the bkup_api utility can be used. (Choose two.)

• A.to define the cycle period for backups
• B.to define the frequency of automatic backups
• C.to define which system files are backed up
• D.to define the retention period for backups
• E.to define which database configuration files are backed up

In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command:
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?

• A.Open DEPTCDB with RESETLOGS
• B.Take a backup of DEPTCDB
• C.Take a backup of HRPDB
• D.Open HRPDB with RESETLOGS
• E.Open DEPTPDB
• F.Open HRPDB

Which two statements are true about a PDB lockdown profile? (Choose two.)

• A.It is enabled by default on creation.
• B.It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
• C.It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.
• D.It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.
• E.It is created by a common user with the SYSDBA privilege in CDB$ROOT.
• F.It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.
For what purpose is this optimized?

• A.for query performance and space saving with greater bias toward space saving
• B.for parallel query performance only
• C.for query performance and space saving
• D.for space saving only
• E.for query performance only