1z0-083 Practice Test

Which three are true in Oracle 19c and later releases? (Choose three.)

A.

If the password file location changes, then the new location is used automatically by the Oracle Server.

B.

Schema Only accounts can be granted administrator privileges

C.

All the Oracle-supplied accounts are Schema Only accounts.

D.

Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

E.

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

F.

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

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A.

Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a
PDB.

B.

Oracle attempts to convert conventional database users to local users when moving schemas from a non-
CDB to a PDB.

C.

A new PDB is automatically created when importing a non-CDB into a CDB.

D.

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a
non-CDB.

E.

Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and
import.

F.

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

A.

Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT
parameter.

B.

Addonly the CREATE_FILE_DEST clause to the statement.

C.

Set only the PDB_FILE_NAME_CONVERT parameter

D.

Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E.

Enable only OMF.

F.

Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)

Which three are true about Audit policies In container databases (CDBs)?

A.

All audit records are written to the audit trail in CDB$ROOT

B.

A common unified audit policy can be created at the application root level.

C.

A common unified audit policy can be created at the CDB level.

D.

An application PDB cannot have a local audit policy

E.

Fine-grained auditing policies defined in an application root must be manually synchronized by each
application PDB contained in the application root.

F.

Application-common unified audit policies defined In an application root must be manually
synchronized by each application PDB contained in the application root.

Which two are facets of performance planning that should always be considered or implemented for an Oracle
Database environment? (Choose two.)

A.

defining primary keys for all tables to speed up all queries

B.

using check constraints to speed upupdates

C.

defining foreign keys for all tables to speed up joins

D.

the physical data model

E.

the configuration of storage arrays