Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

A.

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 or OE_ADMIN role.

B.

It fails because the command does notspecify when the unified audit policy should be enforced.

C.

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

D.

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

Choose three. Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?

A.

If an RMAN command fails, the output will only identify the command that failed.

B.

Some messages in the error stack are not errors.

C.

If an RMAN command fails, the output will identify the channel ID where the failure occurred. D)Media Management errors appear as a line with "Additional information" and a number.

D.

Media Management errors appear as a line with "sbtio" and a number.

E.

Media Management errors appear as a line with "sbtio".

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

A.

The entire PGA is located in the System Global Area (SGA) when using shared servers.

B.

PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

C.

The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

D.

The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.

E.

Sorts and Hash Joins use PGA memory.

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A.

It requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.

B.

It creates one disk group during installation.

C.

It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

D.

Automatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.

E.

It requires the operating system ORACLE_BASDE environment variable to be predefined before installation.

F.

It requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

A.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D.

The UNDO TABLESPACE clause is never required.

E.

RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

Which three are true about an application container?

A.

It can contain a single application

B.

Two application containers can share an application seed PDB.

C.

It must have an application root PDB.

D.

An application PDB can belong to multiple application containers.

E.

It must have an application seed PDB.

F.

It can contain multiple applications.

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

A.

ADDM can recommend shrinking the buffer cache.

B.

ADDM can recommend extending the buffer cache.

C.

By default, MMON creates an AWR snapshot every 30 minutes.

D.

ADDM performs its analysis only when a DBA requests it.

E.

By default, AWR snapshots are automatically purged after eight days.

F.

AWR snapshots must be deleted when no longer required by ADDM.

Choose two. Which two are true in Oracle 19c and later releases?

A.

Schema Only accounts can be granted administrator privileges.

B.

If the password file location changes, then the instance must be restarted.

C.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

D.

All the Oracle-supplied accounts are Schema Only accounts.

E.

Unified Auditing can be configured to audit only events that are issued indirectly by all users

Which three are located by using environment variables?

A.

the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

B.

the location of Oracle Net Services configuration files

C.

the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

D.

default directories for temporary files used by temporary tablespaces

E.

the temporary disk space used by Oracle Installer during installation

F.

the maximum number of database files that can be opened by a database instance

Which three are true? (Choose three.)

A.

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

E.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

F.

Application-common OLS policies can be created in an application root inside an install/patch BEGIN¬END block.

G.

Unified auditing can be automatically synchronized to all application PDBs in an application container.