Question 1

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

Options :

A : AWR snapshots can be created in CDB$ROOT.

B : ADDM can run in a nonroot container.

C : AWR reports can be generated while connected to any container.

D : All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

E : AWR snapshots can be created in a PDB.

F : No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Answer: A,D

Question 2

Identify three benefits of Unified Auditing.

Options :

A : Decreased use ofstorage to store audit trail rowsin the database.

B : It improves overall auditing performance.

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.

Answer: A,B,D

Question 3

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 4

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

Options :

A : APP1_USER1can be created in PDB1.

B : APP1_USER1can be created in CDB1.

C : APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

D : C##_APP_USER1 can be created in CDB1.

E : P1_USER1can be created in CDB1.

F : C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

Answer: C,D

Question 5

Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

Options :

A : log writer performance

B : database writer performance

C : general operating system health

D : SQL statements

E : database instance memory management and sizes

Answer: C

Higher Test Marks with Free Online 1Z0-083 Exam Practice

Buying Options: