Online 1Z0-083 Practice Test

Question 1

Choose three. Which three activities are possible for PDBs?

Options :

A : converting an application seed to an application PDB

B : converting a regular PDB to an application PDB

C : converting an application PDB to an application root

D : copying an application container into another application container in the same CDB

E : copying an application container into another application container in a different CDB

F : converting an application PDB to an application seed G) converting an application PDB to a regular PDB

Answer: B,D,F

Question 2

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

Options :

A : redo logs

B : control files

C : all data dictionary metadata

D : user-defined PL/SQL packages

E : temporary tablespaces

F : mandatory Oracle-supplied PL/SQL packages

G : undo tablespaces

Answer: A,B,C

Question 3

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands: SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

Options :

A : It is enabled for all users having SELECT privilege on SH.SALES.

B : Only successful queries of SH.SALES are written to the audit trail.

C : It is only enabled for user SH.

D : Audit records are always stored in an external audit file.

Answer: A

Question 4

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

Options :

A : They are never considered obsolete by RMAN.

B : They can optionally be written to a fast recovery area (FRA).

C : Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D : Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E : The SPFILE is included in the archival backup.

F : Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 5

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

Options :

A : By default, the transported database will use Oracle Managed Files (OMF)

B : Data files can be converted on the destination system.

C : Data files can be converted on the source system.

D : A new DBID is automatically created for the transported database.

E : Databases can be transported between systems with different endian formats.

F : The password file is automatically converted by RMAN.

Answer: A,B,C

EXPERTY DESIGNED 1Z0-083 PRACTICE TEST