Online Access Free 1Z0-083 Practice Test

Which three are true about the Oracle Optimizer? (Choose three.)

• A.It can re-optimize execution plans after previous executions detect suboptimal plans.
• B.It obeys all hints.
• C.It considers object statistics when generating execution plans for SQL statements.
• D.It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
• E.It considers the filters in WHERE clauses when generating execution plans for SQL statements.
• F.It updates stale object statistics in the Data Dictionary.

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A.Oracle Database Vault must be enabled.
• B.The password for the encryption must be set up.
• C.Oracle wallet for the encryption must be set up.
• D.All the tablespaces in the database must be encrypted

Identify three benefits of Unified Auditing.

• A.It improves overall auditing performance.
• B.Decreased use ofstorage to store audit trail rowsin the database.
• C.It guarantees zero-loss auditing.
• D.The audit trail cannot be easily modified because it is read-only.
• E.It automatically audits Recovery Manager (RMAN) events.

Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

• A.The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
• B.The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
• C.Sorts and Hash Joins use PGA memory.
• D.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• E.The entire PGA is located in the System Global Area (SGA) when using shared servers.

You plan to perform cross-platform PDB transport using XTTS. Which two are true?

• A.Automatic conversion of endianess occurs.
• B.The source and target platforms must have the same endianess.
• C.The source PDB can be in MOUNT or OPEN state.
• D.The source PDB must be in MOUNT state.
• E.A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
• F.The source PDB must not be an application root.