A. It fails because the command does not specify when the unified audit policy should be enforced.

B. It fails because system privileges cannot be granted with roles in the same audit policy.

C. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.

D. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

A. It requires Enterprise Manager Express to be configured

B. No data file needs to be specified

C. It loads data more efficiently than conventional SQL*Loader

D. It loads data faster than conventional SQL*Loader

E. It can load data in parallel

A. It must be made up of the value in ORACLE_SID and HOSTNAME.

B. It must be made up of a database name and a domain name.

C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

A. SQL Query Result Cache

B. User Global Area

C. Program Global Area

D. PL/SQL Function Result Cache

A. The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.

B. The source and target database must be running on the same operating system (OS) with the same endianness.

C. The impdp operation must be performed by the same user that performed the expdp operation.

D. The export dump file must be created before starting the import on the target database.

E. All the user-defined tablespaces must be in read-only mode on the source database.

A. SSH on port 22

B. SSL/TLS on port 443

C. Enterprise Manager on port 1158

D. Cloud Control on port 7799

E. telnet on port 23

A. Network auditing is available in the post-migrated database.

B. Operating system audit trail is available in the post-migrated database.

C. Mandatory auditing of audit administrative actions is available in the post-migrated database.

D. The ability of users to audit their own schema objects is not available in the post-migrated database.

A. It can be used to implement dependency-based scheduling.

B. It cannot invoke the same program or nested chain in multiple steps in the chain.

C. It cannot have more than one dependency.

D. It can be executed using event-based or time-based schedules.

E. It can contain a nested chain of jobs.

A. Optimizer statistics are collected automatically.

B. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

C. Automatic Workload Repository (AWR) snapshots are not generated automatically.

D. Only timed operating system (OS) statistics and plan execution statistics are collected.

A. A database destination must exist or be created for the remote database

B. It must run as a user that is defined on the remote database

C. A credential is optional for a remote database job

D. A destination is optional for a remote database job because DB links can be used instead

E. A credential must be created to define the remote user

F. Remote database jobs always run as the same user who submits the job on the local database

G. A database destination group must exist or be created for a job to run on multiple remote databases