Question 1

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 2

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?

Options :

A : restore and recover database

B : flashback transaction

C : flashback database

D : flashback table and transaction

E : flashback table

Answer: C

Question 3

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

Options :

A : Enable Memory Access Mode, which reads performance data from SGA.

B : Use emergency monitoring to fetch data directly from SGA for analysis.

C : Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D : Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E : Run ADDM in diagnostic mode.

Answer: B

Question 4

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Options :

A : Create the PDB1 application PDB and synchronize it with poB$SEED.

B : Create the PDB1 application PDB and synchronize it with HR_ROOT.

C : Create the PDB1 application PDB and install HR_APP in it.

D : Create an application seed, and install HR_APP in it.

E : Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Answer: A,B

Question 5

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

Options :

A : the data dictionary in CDB$ROOT

B : the log writer process (LGWR)

C : SYSAUX tablespaces

D : temporary tablespaces

E : the Process Monitor Process (PMON)

F : undo tablespaces

Answer: A,B

Smartly Prepare Exam with Free Online 1Z0-083 Practice Test

Buying Options: